DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on FND_GLOBAL

Line 3192: , FND_GLOBAL.USER_ID -- created_by

3188: null,
3189: MSC_ATP_PVT.G_SUMMARY_FLAG
3190: -- dsting 2535568 purge temp table fix
3191: , sysdate -- creation_date
3192: , FND_GLOBAL.USER_ID -- created_by
3193: , sysdate -- last_update_date
3194: , FND_GLOBAL.USER_ID -- update_by
3195: , FND_GLOBAL.USER_ID -- login_by
3196: )

Line 3194: , FND_GLOBAL.USER_ID -- update_by

3190: -- dsting 2535568 purge temp table fix
3191: , sysdate -- creation_date
3192: , FND_GLOBAL.USER_ID -- created_by
3193: , sysdate -- last_update_date
3194: , FND_GLOBAL.USER_ID -- update_by
3195: , FND_GLOBAL.USER_ID -- login_by
3196: )
3197: RETURNING pegging_id INTO l_pegging_id;
3198: IF PG_DEBUG in ('Y', 'C') THEN

Line 3195: , FND_GLOBAL.USER_ID -- login_by

3191: , sysdate -- creation_date
3192: , FND_GLOBAL.USER_ID -- created_by
3193: , sysdate -- last_update_date
3194: , FND_GLOBAL.USER_ID -- update_by
3195: , FND_GLOBAL.USER_ID -- login_by
3196: )
3197: RETURNING pegging_id INTO l_pegging_id;
3198: IF PG_DEBUG in ('Y', 'C') THEN
3199: msc_sch_wb.atp_debug('Add_Coproducts: ' || ' rec_count : = ' || rec_count);

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

3679: l_ship_method,
3680: l_ship_method_text,
3681: nvl(l_default_flag,1),
3682: l_sources.organization_id(counter),
3683: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
3684: FND_GLOBAL.USER_ID,
3685: FND_GLOBAL.USER_ID;
3686:
3687: IF PG_DEBUG in ('Y', 'C') THEN

Line 3684: FND_GLOBAL.USER_ID,

3680: l_ship_method_text,
3681: nvl(l_default_flag,1),
3682: l_sources.organization_id(counter),
3683: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
3684: FND_GLOBAL.USER_ID,
3685: FND_GLOBAL.USER_ID;
3686:
3687: IF PG_DEBUG in ('Y', 'C') THEN
3688: msc_sch_wb.atp_debug('get_Supply_Sources: '

Line 3685: FND_GLOBAL.USER_ID;

3681: nvl(l_default_flag,1),
3682: l_sources.organization_id(counter),
3683: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
3684: FND_GLOBAL.USER_ID,
3685: FND_GLOBAL.USER_ID;
3686:
3687: IF PG_DEBUG in ('Y', 'C') THEN
3688: msc_sch_wb.atp_debug('get_Supply_Sources: '
3689: || ' after exec of above sql ');

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

3763: -- ' AND FND.LOOKUP_CODE = msim.ship_method';
3764:
3765: execute immediate sql_stmt
3766: using l_sources.organization_id(counter),
3767: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
3768: FND_GLOBAL.USER_ID,
3769: FND_GLOBAL.USER_ID,
3770: x_session_id,
3771: l_from_location_id,

Line 3768: FND_GLOBAL.USER_ID,

3764:
3765: execute immediate sql_stmt
3766: using l_sources.organization_id(counter),
3767: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
3768: FND_GLOBAL.USER_ID,
3769: FND_GLOBAL.USER_ID,
3770: x_session_id,
3771: l_from_location_id,
3772: l_sources.instance_id(counter),

Line 3769: FND_GLOBAL.USER_ID,

3765: execute immediate sql_stmt
3766: using l_sources.organization_id(counter),
3767: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
3768: FND_GLOBAL.USER_ID,
3769: FND_GLOBAL.USER_ID,
3770: x_session_id,
3771: l_from_location_id,
3772: l_sources.instance_id(counter),
3773: l_customer_site_id,

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

4145: x_other_cols.sr_supplier_id(j),
4146: x_other_cols.sr_supplier_site_id(j),x_other_cols.org_code(j),
4147: x_other_cols.vendor_name(j),x_other_cols.vendor_site_name(j),
4148: x_other_cols.ship_method_text(j),
4149: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
4150: FND_GLOBAL.USER_ID,
4151: FND_GLOBAL.USER_ID,
4152: x_session_id;
4153: IF PG_DEBUG in ('Y', 'C') THEN

Line 4150: FND_GLOBAL.USER_ID,

4146: x_other_cols.sr_supplier_site_id(j),x_other_cols.org_code(j),
4147: x_other_cols.vendor_name(j),x_other_cols.vendor_site_name(j),
4148: x_other_cols.ship_method_text(j),
4149: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
4150: FND_GLOBAL.USER_ID,
4151: FND_GLOBAL.USER_ID,
4152: x_session_id;
4153: IF PG_DEBUG in ('Y', 'C') THEN
4154: 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 4151: FND_GLOBAL.USER_ID,

4147: x_other_cols.vendor_name(j),x_other_cols.vendor_site_name(j),
4148: x_other_cols.ship_method_text(j),
4149: FND_GLOBAL.USER_ID, -- dsting 2535568 purge temp table fix
4150: FND_GLOBAL.USER_ID,
4151: FND_GLOBAL.USER_ID,
4152: x_session_id;
4153: IF PG_DEBUG in ('Y', 'C') THEN
4154: 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));
4155: msc_sch_wb.atp_debug('insert_atp_sources: ' || ' inserted rows '||SQL%ROWCOUNT);