APPS.IBW_OE_PVT dependencies on FND_GLOBAL

Line 170: ,fnd_global.user_id

166: ,LAST_update_LOGIN)
167: VALUES(l_guest_party_id
168: ,1
169: ,l_guest_person_id
170: ,fnd_global.user_id
171: ,SYSDATE
172: ,fnd_global.user_id
173: ,SYSDATE,fnd_profile.VALUE('LOGIN_ID'));
174:

Line 172: ,fnd_global.user_id

168: ,1
169: ,l_guest_person_id
170: ,fnd_global.user_id
171: ,SYSDATE
172: ,fnd_global.user_id
173: ,SYSDATE,fnd_profile.VALUE('LOGIN_ID'));
174:
175: ELSE
176: UPDATE ibw_guest_party

Line 354: , fnd_global.user_id

350: , useragent
351: , user_id
352: , guid
353: , DECODE(customer_id,party_id,null,customer_id) AS rel_id
354: , fnd_global.user_id
355: , pat_last_update_date
356: , fnd_global.user_id
357: , pat_last_update_date
358: , fnd_global.conc_login_id

Line 356: , fnd_global.user_id

352: , guid
353: , DECODE(customer_id,party_id,null,customer_id) AS rel_id
354: , fnd_global.user_id
355: , pat_last_update_date
356: , fnd_global.user_id
357: , pat_last_update_date
358: , fnd_global.conc_login_id
359: , 1
360: , fnd_global.conc_program_id

Line 358: , fnd_global.conc_login_id

354: , fnd_global.user_id
355: , pat_last_update_date
356: , fnd_global.user_id
357: , pat_last_update_date
358: , fnd_global.conc_login_id
359: , 1
360: , fnd_global.conc_program_id
361: , fnd_global.conc_login_id
362: , fnd_global.prog_appl_id

Line 360: , fnd_global.conc_program_id

356: , fnd_global.user_id
357: , pat_last_update_date
358: , fnd_global.conc_login_id
359: , 1
360: , fnd_global.conc_program_id
361: , fnd_global.conc_login_id
362: , fnd_global.prog_appl_id
363: , fnd_global.conc_request_id
364: , DECODE ( INSTR ( evnt_id

Line 361: , fnd_global.conc_login_id

357: , pat_last_update_date
358: , fnd_global.conc_login_id
359: , 1
360: , fnd_global.conc_program_id
361: , fnd_global.conc_login_id
362: , fnd_global.prog_appl_id
363: , fnd_global.conc_request_id
364: , DECODE ( INSTR ( evnt_id
365: , ',NULL'

Line 362: , fnd_global.prog_appl_id

358: , fnd_global.conc_login_id
359: , 1
360: , fnd_global.conc_program_id
361: , fnd_global.conc_login_id
362: , fnd_global.prog_appl_id
363: , fnd_global.conc_request_id
364: , DECODE ( INSTR ( evnt_id
365: , ',NULL'
366: , 1

Line 363: , fnd_global.conc_request_id

359: , 1
360: , fnd_global.conc_program_id
361: , fnd_global.conc_login_id
362: , fnd_global.prog_appl_id
363: , fnd_global.conc_request_id
364: , DECODE ( INSTR ( evnt_id
365: , ',NULL'
366: , 1
367: , 1

Line 954: , fnd_global.user_id

950: , NULL
951: , user_id
952: , guid
953: , NULL
954: , fnd_global.user_id
955: , pat_last_update_date
956: , fnd_global.user_id
957: , SYSDATE
958: , fnd_global.conc_login_id

Line 956: , fnd_global.user_id

952: , guid
953: , NULL
954: , fnd_global.user_id
955: , pat_last_update_date
956: , fnd_global.user_id
957: , SYSDATE
958: , fnd_global.conc_login_id
959: , 1
960: , fnd_global.conc_program_id

Line 958: , fnd_global.conc_login_id

954: , fnd_global.user_id
955: , pat_last_update_date
956: , fnd_global.user_id
957: , SYSDATE
958: , fnd_global.conc_login_id
959: , 1
960: , fnd_global.conc_program_id
961: , fnd_global.conc_login_id
962: , fnd_global.prog_appl_id

Line 960: , fnd_global.conc_program_id

956: , fnd_global.user_id
957: , SYSDATE
958: , fnd_global.conc_login_id
959: , 1
960: , fnd_global.conc_program_id
961: , fnd_global.conc_login_id
962: , fnd_global.prog_appl_id
963: , fnd_global.conc_request_id
964: , DECODE ( loginevent

Line 961: , fnd_global.conc_login_id

957: , SYSDATE
958: , fnd_global.conc_login_id
959: , 1
960: , fnd_global.conc_program_id
961: , fnd_global.conc_login_id
962: , fnd_global.prog_appl_id
963: , fnd_global.conc_request_id
964: , DECODE ( loginevent
965: , 'true', 8

Line 962: , fnd_global.prog_appl_id

958: , fnd_global.conc_login_id
959: , 1
960: , fnd_global.conc_program_id
961: , fnd_global.conc_login_id
962: , fnd_global.prog_appl_id
963: , fnd_global.conc_request_id
964: , DECODE ( loginevent
965: , 'true', 8
966: , DECODE ( INSTR ( evnt_id

Line 963: , fnd_global.conc_request_id

959: , 1
960: , fnd_global.conc_program_id
961: , fnd_global.conc_login_id
962: , fnd_global.prog_appl_id
963: , fnd_global.conc_request_id
964: , DECODE ( loginevent
965: , 'true', 8
966: , DECODE ( INSTR ( evnt_id
967: , 'NULL'

Line 1223: fnd_global.user_id,

1219: USER_GUID,
1220: PARTY_RELATIONSHIP_ID,
1221: NULL,
1222: 1,
1223: fnd_global.user_id,
1224: SYSDATE,
1225: fnd_global.user_id,
1226: last_update_date
1227: FROM ibw_page_views pv

Line 1225: fnd_global.user_id,

1221: NULL,
1222: 1,
1223: fnd_global.user_id,
1224: SYSDATE,
1225: fnd_global.user_id,
1226: last_update_date
1227: FROM ibw_page_views pv
1228: WHERE exists (SELECT tmp.rec_id
1229: FROM ibw_page_views_tmp tmp

Line 1518: , fnd_global.user_id

1514: , browser_os_info
1515: , user_id
1516: , user_guid
1517: , party_relationship_id
1518: , fnd_global.user_id
1519: , SYSDATE
1520: , fnd_global.user_id
1521: , SYSDATE
1522: , fnd_global.conc_login_id

Line 1520: , fnd_global.user_id

1516: , user_guid
1517: , party_relationship_id
1518: , fnd_global.user_id
1519: , SYSDATE
1520: , fnd_global.user_id
1521: , SYSDATE
1522: , fnd_global.conc_login_id
1523: , 1
1524: , fnd_global.conc_program_id

Line 1522: , fnd_global.conc_login_id

1518: , fnd_global.user_id
1519: , SYSDATE
1520: , fnd_global.user_id
1521: , SYSDATE
1522: , fnd_global.conc_login_id
1523: , 1
1524: , fnd_global.conc_program_id
1525: , fnd_global.conc_login_id
1526: , fnd_global.prog_appl_id

Line 1524: , fnd_global.conc_program_id

1520: , fnd_global.user_id
1521: , SYSDATE
1522: , fnd_global.conc_login_id
1523: , 1
1524: , fnd_global.conc_program_id
1525: , fnd_global.conc_login_id
1526: , fnd_global.prog_appl_id
1527: , fnd_global.conc_request_id
1528: FROM ibw_page_views_tmp

Line 1525: , fnd_global.conc_login_id

1521: , SYSDATE
1522: , fnd_global.conc_login_id
1523: , 1
1524: , fnd_global.conc_program_id
1525: , fnd_global.conc_login_id
1526: , fnd_global.prog_appl_id
1527: , fnd_global.conc_request_id
1528: FROM ibw_page_views_tmp
1529: WHERE page_id NOT IN ( -2, -3, -1 )

Line 1526: , fnd_global.prog_appl_id

1522: , fnd_global.conc_login_id
1523: , 1
1524: , fnd_global.conc_program_id
1525: , fnd_global.conc_login_id
1526: , fnd_global.prog_appl_id
1527: , fnd_global.conc_request_id
1528: FROM ibw_page_views_tmp
1529: WHERE page_id NOT IN ( -2, -3, -1 )
1530: AND page_id IS NOT NULL

Line 1527: , fnd_global.conc_request_id

1523: , 1
1524: , fnd_global.conc_program_id
1525: , fnd_global.conc_login_id
1526: , fnd_global.prog_appl_id
1527: , fnd_global.conc_request_id
1528: FROM ibw_page_views_tmp
1529: WHERE page_id NOT IN ( -2, -3, -1 )
1530: AND page_id IS NOT NULL
1531: AND process_flag is NULL

Line 1689: , sv.last_updated_by = fnd_global.user_id

1685: , sv.total_payment_inquiries = tmp.total_payment_inquiries
1686: , sv.total_invoice_inquiries = tmp.total_invoice_inquiries
1687: , sv.total_opt_outs = tmp.total_opt_outs
1688: , sv.last_update_date = SYSDATE
1689: , sv.last_updated_by = fnd_global.user_id
1690: , sv.repeat_visit_flag = tmp.repeat_visit_flag
1691: , sv.referral_category_id = tmp.referral_category_id
1692: , sv.user_id = tmp.user_id, sv.party_id = tmp.party_id
1693: , sv.visitant_id = tmp.visitant_id

Line 1712: , fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, 1 );

1708: , tmp.total_web_registrations, tmp.total_order_inquiries
1709: , tmp.total_payment_inquiries, tmp.total_invoice_inquiries
1710: , tmp.total_opt_outs, tmp.user_id, tmp.visitant_id
1711: , tmp.campaign_source_code_id, tmp.repeat_visit_flag
1712: , fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, 1 );
1713:
1714:
1715:
1716:

Line 2191: l_user_id NUMBER := FND_GLOBAL.USER_ID();

2187: --------------------------------------------------------------------------------------------------
2188:
2189: PROCEDURE CONTEXT_LOAD
2190: IS
2191: l_user_id NUMBER := FND_GLOBAL.USER_ID();
2192: l_business_context VARCHAR2(30);
2193: x_return_status VARCHAR2(30);
2194: l_last_update_login NUMBER;
2195: l_program_id NUMBER;