DBA Data[Home] [Help]

APPS.CTO_ATP_INTERFACE_PK dependencies on FND_GLOBAL

Line 440: gUserId := nvl(fnd_global.user_id, -1);

436:
437: /* initialize session specific variables */
438: initialize_session_globals ;
439:
440: gUserId := nvl(fnd_global.user_id, -1);
441: gLoginId := nvl(fnd_global.login_id, -1);
442:
443: /* get assignment set and check its validity */
444: initialize_assignment_set( x_return_status ) ;

Line 441: gLoginId := nvl(fnd_global.login_id, -1);

437: /* initialize session specific variables */
438: initialize_session_globals ;
439:
440: gUserId := nvl(fnd_global.user_id, -1);
441: gLoginId := nvl(fnd_global.login_id, -1);
442:
443: /* get assignment set and check its validity */
444: initialize_assignment_set( x_return_status ) ;
445:

Line 5597: guserid := nvl(FND_GLOBAL.user_id,-1);

5593: oe_debug_pub.add('create_cto_model_demand: ' || 'Session id passed by ATP = '||to_char(p_session_id),1);
5594: END IF;
5595:
5596: -- Get the user id and Login id by calling the FND api
5597: guserid := nvl(FND_GLOBAL.user_id,-1);
5598: gloginid := nvl(FND_GLOBAL.login_id,-1);
5599:
5600: IF PG_DEBUG <> 0 THEN
5601: oe_debug_pub.add('create_cto_model_demand: ' || 'Record count in the ATP Shipset = '||to_char(p_shipset.action.count),2);

Line 5598: gloginid := nvl(FND_GLOBAL.login_id,-1);

5594: END IF;
5595:
5596: -- Get the user id and Login id by calling the FND api
5597: guserid := nvl(FND_GLOBAL.user_id,-1);
5598: gloginid := nvl(FND_GLOBAL.login_id,-1);
5599:
5600: IF PG_DEBUG <> 0 THEN
5601: oe_debug_pub.add('create_cto_model_demand: ' || 'Record count in the ATP Shipset = '||to_char(p_shipset.action.count),2);
5602: END IF;

Line 6578: guserid := nvl(FND_GLOBAL.user_id,-1);

6574:
6575: IF PG_DEBUG <> 0 THEN
6576: oe_debug_pub.add('create_cto_item_demand: ' || ' Begin CREATE_CTO_ITEM_DEMAND module...',1);
6577: END IF;
6578: guserid := nvl(FND_GLOBAL.user_id,-1);
6579: gloginid := nvl(FND_GLOBAL.login_id,-1);
6580:
6581: -- Flush the data from BCOD table which is being populated
6582: -- by the previous collection run.

Line 6579: gloginid := nvl(FND_GLOBAL.login_id,-1);

6575: IF PG_DEBUG <> 0 THEN
6576: oe_debug_pub.add('create_cto_item_demand: ' || ' Begin CREATE_CTO_ITEM_DEMAND module...',1);
6577: END IF;
6578: guserid := nvl(FND_GLOBAL.user_id,-1);
6579: gloginid := nvl(FND_GLOBAL.login_id,-1);
6580:
6581: -- Flush the data from BCOD table which is being populated
6582: -- by the previous collection run.
6583: -- The parent_demand_type = 2 tells that those rows are ato item rows

Line 6970: guserid := nvl(FND_GLOBAL.user_id,-1);

6966: x_return_status out varchar2,
6967: x_msg_count out number,
6968: x_msg_data out varchar2) is
6969: BEGIN
6970: guserid := nvl(FND_GLOBAL.user_id,-1);
6971: gloginid := nvl(FND_GLOBAL.login_id,-1);
6972: /* First level model and Option class rows are inserted in to the bcod table.*/
6973: insert into
6974: bom_cto_order_demand(

Line 6971: gloginid := nvl(FND_GLOBAL.login_id,-1);

6967: x_msg_count out number,
6968: x_msg_data out varchar2) is
6969: BEGIN
6970: guserid := nvl(FND_GLOBAL.user_id,-1);
6971: gloginid := nvl(FND_GLOBAL.login_id,-1);
6972: /* First level model and Option class rows are inserted in to the bcod table.*/
6973: insert into
6974: bom_cto_order_demand(
6975: bcod_line_id,