DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on FND_GLOBAL

Line 3184: , FND_GLOBAL.USER_ID -- created_by

3180: null,
3181: MSC_ATP_PVT.G_SUMMARY_FLAG
3182: -- dsting 2535568 purge temp table fix
3183: , sysdate -- creation_date
3184: , FND_GLOBAL.USER_ID -- created_by
3185: , sysdate -- last_update_date
3186: , FND_GLOBAL.USER_ID -- update_by
3187: , FND_GLOBAL.USER_ID -- login_by
3188: )

Line 3186: , FND_GLOBAL.USER_ID -- update_by

3182: -- dsting 2535568 purge temp table fix
3183: , sysdate -- creation_date
3184: , FND_GLOBAL.USER_ID -- created_by
3185: , sysdate -- last_update_date
3186: , FND_GLOBAL.USER_ID -- update_by
3187: , FND_GLOBAL.USER_ID -- login_by
3188: )
3189: RETURNING pegging_id INTO l_pegging_id;
3190: IF PG_DEBUG in ('Y', 'C') THEN

Line 3187: , FND_GLOBAL.USER_ID -- login_by

3183: , sysdate -- creation_date
3184: , FND_GLOBAL.USER_ID -- created_by
3185: , sysdate -- last_update_date
3186: , FND_GLOBAL.USER_ID -- update_by
3187: , FND_GLOBAL.USER_ID -- login_by
3188: )
3189: RETURNING pegging_id INTO l_pegging_id;
3190: IF PG_DEBUG in ('Y', 'C') THEN
3191: msc_sch_wb.atp_debug('Add_Coproducts: ' || ' rec_count : = ' || rec_count);

Line 3674: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix

3670: l_ship_method,
3671: l_ship_method_text,
3672: nvl(l_default_flag,1),
3673: l_sources.organization_id(counter),
3674: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
3675: FND_GLOBAL.USER_ID,
3676: FND_GLOBAL.USER_ID;
3677:
3678: IF PG_DEBUG in ('Y', 'C') THEN

Line 3675: FND_GLOBAL.USER_ID,

3671: l_ship_method_text,
3672: nvl(l_default_flag,1),
3673: l_sources.organization_id(counter),
3674: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
3675: FND_GLOBAL.USER_ID,
3676: FND_GLOBAL.USER_ID;
3677:
3678: IF PG_DEBUG in ('Y', 'C') THEN
3679: msc_sch_wb.atp_debug('get_Supply_Sources: '

Line 3676: FND_GLOBAL.USER_ID;

3672: nvl(l_default_flag,1),
3673: l_sources.organization_id(counter),
3674: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
3675: FND_GLOBAL.USER_ID,
3676: FND_GLOBAL.USER_ID;
3677:
3678: IF PG_DEBUG in ('Y', 'C') THEN
3679: msc_sch_wb.atp_debug('get_Supply_Sources: '
3680: || ' after exec of above sql ');

Line 3758: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix

3754: -- ' AND FND.LOOKUP_CODE = msim.ship_method';
3755:
3756: execute immediate sql_stmt
3757: using l_sources.organization_id(counter),
3758: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
3759: FND_GLOBAL.USER_ID,
3760: FND_GLOBAL.USER_ID,
3761: x_session_id,
3762: l_from_location_id,

Line 3759: FND_GLOBAL.USER_ID,

3755:
3756: execute immediate sql_stmt
3757: using l_sources.organization_id(counter),
3758: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
3759: FND_GLOBAL.USER_ID,
3760: FND_GLOBAL.USER_ID,
3761: x_session_id,
3762: l_from_location_id,
3763: l_sources.instance_id(counter),

Line 3760: FND_GLOBAL.USER_ID,

3756: execute immediate sql_stmt
3757: using l_sources.organization_id(counter),
3758: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
3759: FND_GLOBAL.USER_ID,
3760: FND_GLOBAL.USER_ID,
3761: x_session_id,
3762: l_from_location_id,
3763: l_sources.instance_id(counter),
3764: l_customer_site_id,

Line 4140: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix

4136: x_other_cols.sr_supplier_id(j),
4137: x_other_cols.sr_supplier_site_id(j),x_other_cols.org_code(j),
4138: x_other_cols.vendor_name(j),x_other_cols.vendor_site_name(j),
4139: x_other_cols.ship_method_text(j),
4140: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
4141: FND_GLOBAL.USER_ID,
4142: FND_GLOBAL.USER_ID,
4143: x_session_id;
4144: IF PG_DEBUG in ('Y', 'C') THEN

Line 4141: FND_GLOBAL.USER_ID,

4137: x_other_cols.sr_supplier_site_id(j),x_other_cols.org_code(j),
4138: x_other_cols.vendor_name(j),x_other_cols.vendor_site_name(j),
4139: x_other_cols.ship_method_text(j),
4140: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
4141: FND_GLOBAL.USER_ID,
4142: FND_GLOBAL.USER_ID,
4143: x_session_id;
4144: IF PG_DEBUG in ('Y', 'C') THEN
4145: msc_sch_wb.atp_debug('insert_atp_sources: ' || ' In atp_insert_sources x_atp_sources.ship_method(j) is ' || x_atp_sources.ship_method(j));

Line 4142: FND_GLOBAL.USER_ID,

4138: x_other_cols.vendor_name(j),x_other_cols.vendor_site_name(j),
4139: x_other_cols.ship_method_text(j),
4140: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
4141: FND_GLOBAL.USER_ID,
4142: FND_GLOBAL.USER_ID,
4143: x_session_id;
4144: IF PG_DEBUG in ('Y', 'C') THEN
4145: msc_sch_wb.atp_debug('insert_atp_sources: ' || ' In atp_insert_sources x_atp_sources.ship_method(j) is ' || x_atp_sources.ship_method(j));
4146: msc_sch_wb.atp_debug('insert_atp_sources: ' || ' inserted rows '||SQL%ROWCOUNT);