DBA Data[Home] [Help]

APPS.AS_BUSINESS_EVENT_PVT dependencies on FND_GLOBAL

Line 237: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,

233: )
234: values (
235: AS_EVENT_DATA_S.nextval,
236: l_new_key, 'AAA', l_param.GetName(), l_param.GetValue(),
237: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
238: FND_GLOBAL.CONC_LOGIN_ID
239: );
240: IF l_debug THEN
241: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 238: FND_GLOBAL.CONC_LOGIN_ID

234: values (
235: AS_EVENT_DATA_S.nextval,
236: l_new_key, 'AAA', l_param.GetName(), l_param.GetValue(),
237: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
238: FND_GLOBAL.CONC_LOGIN_ID
239: );
240: IF l_debug THEN
241: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
242: l_param.GetName() || ' : ' || l_param.GetValue()) ;

Line 255: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,

251: )
252: values (
253: AS_EVENT_DATA_S.nextval,
254: l_new_key, 'AAA', 'EVENT_NAME', l_event_name,
255: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
256: FND_GLOBAL.CONC_LOGIN_ID
257: );
258:
259: insert into AS_EVENT_DATA (

Line 256: FND_GLOBAL.CONC_LOGIN_ID

252: values (
253: AS_EVENT_DATA_S.nextval,
254: l_new_key, 'AAA', 'EVENT_NAME', l_event_name,
255: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
256: FND_GLOBAL.CONC_LOGIN_ID
257: );
258:
259: insert into AS_EVENT_DATA (
260: EVENT_DATA_ID,

Line 268: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,

264: )
265: values (
266: AS_EVENT_DATA_S.nextval,
267: l_new_key, 'AAA', 'EVENT_KEY', l_key,
268: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
269: FND_GLOBAL.CONC_LOGIN_ID
270: );
271:
272: Copy_Event_Data(l_key, l_new_key);

Line 269: FND_GLOBAL.CONC_LOGIN_ID

265: values (
266: AS_EVENT_DATA_S.nextval,
267: l_new_key, 'AAA', 'EVENT_KEY', l_key,
268: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
269: FND_GLOBAL.CONC_LOGIN_ID
270: );
271:
272: Copy_Event_Data(l_key, l_new_key);
273:

Line 365: l_security_group_id := fnd_global.security_group_id;

361:
362: IF l_security_group_id IS NULL THEN
363: --l_security_group_id := fnd_profile.value( 'SECURITY_GROUP_ID');
364: /* BugNo: 3007012 */
365: l_security_group_id := fnd_global.security_group_id;
366: END IF;
367: l_param := WF_PARAMETER_T( NULL, NULL );
368: -- fill the parameters list
369: x_list.extend;

Line 567: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,

563: CHAR36, CHAR37)
564: select
565: AS_EVENT_DATA_S.nextval,
566: p_item_key, p_indicator,
567: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
568: FND_GLOBAL.CONC_LOGIN_ID,
569:
570: -- NUM01 - NUM21
571: lead_id, customer_id,

Line 568: FND_GLOBAL.CONC_LOGIN_ID,

564: select
565: AS_EVENT_DATA_S.nextval,
566: p_item_key, p_indicator,
567: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
568: FND_GLOBAL.CONC_LOGIN_ID,
569:
570: -- NUM01 - NUM21
571: lead_id, customer_id,
572: address_id, owner_salesforce_id,

Line 660: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,

656: CHAR22)
657: select
658: AS_EVENT_DATA_S.nextval,
659: p_item_key, p_indicator,
660: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
661: FND_GLOBAL.CONC_LOGIN_ID,
662:
663: -- NUM01-03, 05, 12-15, 19, 22-24
664: lead_line_id, lead_id,

Line 661: FND_GLOBAL.CONC_LOGIN_ID,

657: select
658: AS_EVENT_DATA_S.nextval,
659: p_item_key, p_indicator,
660: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
661: FND_GLOBAL.CONC_LOGIN_ID,
662:
663: -- NUM01-03, 05, 12-15, 19, 22-24
664: lead_line_id, lead_id,
665: last_updated_by, created_by,

Line 712: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,

708: NUM01, NUM02, NUM03, NUM04)
709: select
710: AS_EVENT_DATA_S.nextval,
711: p_item_key, p_indicator,
712: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
713: FND_GLOBAL.CONC_LOGIN_ID,
714:
715: -- NUM01-09
716: salesforce_id, sales_group_id, access_id, lead_id

Line 713: FND_GLOBAL.CONC_LOGIN_ID,

709: select
710: AS_EVENT_DATA_S.nextval,
711: p_item_key, p_indicator,
712: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
713: FND_GLOBAL.CONC_LOGIN_ID,
714:
715: -- NUM01-09
716: salesforce_id, sales_group_id, access_id, lead_id
717: from AS_SALES_TEAM_EMP_V where lead_id = p_lead_id;

Line 741: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,

737: NUM01, NUM02, NUM03, NUM04, NUM05)
738: select
739: AS_EVENT_DATA_S.nextval,
740: p_item_key, p_indicator,
741: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
742: FND_GLOBAL.CONC_LOGIN_ID,
743:
744: -- NUM01-09
745: salesforce_id, sales_group_id, access_id, customer_id, address_id

Line 742: FND_GLOBAL.CONC_LOGIN_ID,

738: select
739: AS_EVENT_DATA_S.nextval,
740: p_item_key, p_indicator,
741: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
742: FND_GLOBAL.CONC_LOGIN_ID,
743:
744: -- NUM01-09
745: salesforce_id, sales_group_id, access_id, customer_id, address_id
746: from AS_SALES_TEAM_EMP_V where customer_id = p_cust_id and lead_id IS NULL and