eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on FND_GLOBAL

Line 500: SELECT 1, 1, 'CONTENT_ZONE', 1, NULL, fnd_global.user_id, sysdate,

496: INSERT INTO icx_cat_store_contents
497: (store_id, content_id, content_type, sequence, display_always_flag,
498: created_by, creation_date, last_updated_by, last_update_date,
499: last_update_login)
500: SELECT 1, 1, 'CONTENT_ZONE', 1, NULL, fnd_global.user_id, sysdate,
501: fnd_global.user_id, sysdate, fnd_global.login_id
502: FROM dual;
503: l_err_loc := 100;
504:

Line 501: fnd_global.user_id, sysdate, fnd_global.login_id

497: (store_id, content_id, content_type, sequence, display_always_flag,
498: created_by, creation_date, last_updated_by, last_update_date,
499: last_update_login)
500: SELECT 1, 1, 'CONTENT_ZONE', 1, NULL, fnd_global.user_id, sysdate,
501: fnd_global.user_id, sysdate, fnd_global.login_id
502: FROM dual;
503: l_err_loc := 100;
504:
505: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 539: SELECT 2, 10000000, 'SMART_FORM', 1, 'N', fnd_global.user_id, sysdate,

535: INSERT INTO icx_cat_store_contents
536: (store_id, content_id, content_type, sequence, display_always_flag,
537: created_by, creation_date, last_updated_by, last_update_date,
538: last_update_login)
539: SELECT 2, 10000000, 'SMART_FORM', 1, 'N', fnd_global.user_id, sysdate,
540: fnd_global.user_id, sysdate, fnd_global.login_id
541: FROM dual;
542: l_err_loc := 100;
543:

Line 540: fnd_global.user_id, sysdate, fnd_global.login_id

536: (store_id, content_id, content_type, sequence, display_always_flag,
537: created_by, creation_date, last_updated_by, last_update_date,
538: last_update_login)
539: SELECT 2, 10000000, 'SMART_FORM', 1, 'N', fnd_global.user_id, sysdate,
540: fnd_global.user_id, sysdate, fnd_global.login_id
541: FROM dual;
542: l_err_loc := 100;
543:
544: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 627: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,

623: (zone_id, language, source_lang, name, description,
624: created_by, creation_date, last_updated_by, last_update_date,
625: last_update_login)
626: SELECT 2, language, source_lang, item_source_name, description,
627: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
628: fnd_global.login_id
629: FROM icx_por_item_sources_tl
630: WHERE item_source_id = 10000001;
631: l_err_loc := 200;

Line 628: fnd_global.login_id

624: created_by, creation_date, last_updated_by, last_update_date,
625: last_update_login)
626: SELECT 2, language, source_lang, item_source_name, description,
627: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
628: fnd_global.login_id
629: FROM icx_por_item_sources_tl
630: WHERE item_source_id = 10000001;
631: l_err_loc := 200;
632:

Line 805: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,

801: image, created_by, creation_date, last_updated_by, last_update_date,
802: last_update_login)
803: SELECT p_new_id, language, source_lang, store_name,
804: short_description, long_description, image_location,
805: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
806: fnd_global.login_id
807: FROM icx_cat_stores_tl
808: WHERE store_id = p_old_id;
809: l_err_loc := 300;

Line 806: fnd_global.login_id

802: last_update_login)
803: SELECT p_new_id, language, source_lang, store_name,
804: short_description, long_description, image_location,
805: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
806: fnd_global.login_id
807: FROM icx_cat_stores_tl
808: WHERE store_id = p_old_id;
809: l_err_loc := 300;
810:

Line 2741: SELECT l_r12_store_ids(i), stores.sequence_number, 'Y', fnd_global.user_id,

2737: FORALL i IN 1..l_old_store_ids.COUNT
2738: INSERT INTO icx_cat_shop_stores_b
2739: (store_id, sequence, local_content_first_flag, created_by, creation_date,
2740: last_updated_by, last_update_date, last_update_login)
2741: SELECT l_r12_store_ids(i), stores.sequence_number, 'Y', fnd_global.user_id,
2742: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
2743: FROM icx_cat_stores_b stores
2744: WHERE stores.store_id = l_old_store_ids(i);
2745:

Line 2742: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

2738: INSERT INTO icx_cat_shop_stores_b
2739: (store_id, sequence, local_content_first_flag, created_by, creation_date,
2740: last_updated_by, last_update_date, last_update_login)
2741: SELECT l_r12_store_ids(i), stores.sequence_number, 'Y', fnd_global.user_id,
2742: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
2743: FROM icx_cat_stores_b stores
2744: WHERE stores.store_id = l_old_store_ids(i);
2745:
2746: l_err_loc := 300;

Line 2755: stores_tl.long_description, stores_tl.image_location, fnd_global.user_id,

2751: image, created_by, creation_date, last_updated_by, last_update_date,
2752: last_update_login)
2753: SELECT l_r12_store_ids(i), stores_tl.language, stores_tl.source_lang,
2754: stores_tl.store_name, stores_tl.short_description,
2755: stores_tl.long_description, stores_tl.image_location, fnd_global.user_id,
2756: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
2757: FROM icx_cat_stores_tl stores_tl
2758: WHERE stores_tl.store_id = l_old_store_ids(i);
2759:

Line 2756: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

2752: last_update_login)
2753: SELECT l_r12_store_ids(i), stores_tl.language, stores_tl.source_lang,
2754: stores_tl.store_name, stores_tl.short_description,
2755: stores_tl.long_description, stores_tl.image_location, fnd_global.user_id,
2756: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
2757: FROM icx_cat_stores_tl stores_tl
2758: WHERE stores_tl.store_id = l_old_store_ids(i);
2759:
2760: l_err_loc := 400;

Line 2830: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,

2826: created_by, creation_date, last_updated_by, last_update_date,
2827: last_update_login)
2828: SELECT p_r12_store_id, p_zone_ids(i), 'CONTENT_ZONE',
2829: sc.sequence_number, sc.display_always_flag,
2830: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
2831: fnd_global.login_id
2832: FROM icx_cat_store_catalogs sc
2833: WHERE p_old_store_id IS NOT NULL
2834: AND sc.store_id = p_old_store_id

Line 2831: fnd_global.login_id

2827: last_update_login)
2828: SELECT p_r12_store_id, p_zone_ids(i), 'CONTENT_ZONE',
2829: sc.sequence_number, sc.display_always_flag,
2830: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
2831: fnd_global.login_id
2832: FROM icx_cat_store_catalogs sc
2833: WHERE p_old_store_id IS NOT NULL
2834: AND sc.store_id = p_old_store_id
2835: AND sc.item_source_id = p_old_source_id;

Line 2905: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,

2901: created_by, creation_date, last_updated_by, last_update_date,
2902: last_update_login)
2903: SELECT p_r12_store_ids(i), p_zone_ids(i), 'CONTENT_ZONE',
2904: sc.sequence_number, sc.display_always_flag,
2905: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
2906: fnd_global.login_id
2907: FROM icx_cat_store_catalogs sc
2908: WHERE p_old_store_ids(i) IS NOT NULL
2909: AND sc.store_id = p_old_store_ids(i)

Line 2906: fnd_global.login_id

2902: last_update_login)
2903: SELECT p_r12_store_ids(i), p_zone_ids(i), 'CONTENT_ZONE',
2904: sc.sequence_number, sc.display_always_flag,
2905: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
2906: fnd_global.login_id
2907: FROM icx_cat_store_catalogs sc
2908: WHERE p_old_store_ids(i) IS NOT NULL
2909: AND sc.store_id = p_old_store_ids(i)
2910: AND sc.item_source_id = p_old_source_ids(i);

Line 2984: sc.display_always_flag, fnd_global.user_id, sysdate,

2980: created_by, creation_date, last_updated_by, last_update_date,
2981: last_update_login)
2982: SELECT p_r12_store_ids(i), p_smart_form_ids(i), 'SMART_FORM',
2983: DECODE(default_template_flag, 'Y', 1, NULL),
2984: sc.display_always_flag, fnd_global.user_id, sysdate,
2985: fnd_global.user_id, sysdate, fnd_global.login_id
2986: FROM icx_cat_store_catalogs sc
2987: WHERE sc.store_id = p_old_store_ids(i)
2988: AND sc.item_source_id = p_smart_form_ids(i);

Line 2985: fnd_global.user_id, sysdate, fnd_global.login_id

2981: last_update_login)
2982: SELECT p_r12_store_ids(i), p_smart_form_ids(i), 'SMART_FORM',
2983: DECODE(default_template_flag, 'Y', 1, NULL),
2984: sc.display_always_flag, fnd_global.user_id, sysdate,
2985: fnd_global.user_id, sysdate, fnd_global.login_id
2986: FROM icx_cat_store_catalogs sc
2987: WHERE sc.store_id = p_old_store_ids(i)
2988: AND sc.item_source_id = p_smart_form_ids(i);
2989:

Line 3237: 'N', fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,

3233: SELECT p_new_zone_ids(i), 'LOCAL', sources.url, p_security_flags(i),
3234: p_category_flag, p_supplier_flags(i),
3235: DECODE(g_site_approved_pricing, 'Y', 'N',
3236: nvl(sources.include_internal_source_flag, 'Y')),
3237: 'N', fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3238: fnd_global.login_id
3239: FROM icx_por_item_sources sources
3240: WHERE sources.item_source_id = p_catalog_ids(i);
3241:

Line 3238: fnd_global.login_id

3234: p_category_flag, p_supplier_flags(i),
3235: DECODE(g_site_approved_pricing, 'Y', 'N',
3236: nvl(sources.include_internal_source_flag, 'Y')),
3237: 'N', fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3238: fnd_global.login_id
3239: FROM icx_por_item_sources sources
3240: WHERE sources.item_source_id = p_catalog_ids(i);
3241:
3242: l_err_loc := 100;

Line 3251: sources_tl.ctx_keywords, sources.image_url, fnd_global.user_id,

3247: created_by, creation_date, last_updated_by, last_update_date,
3248: last_update_login)
3249: SELECT p_new_zone_ids(i), sources_tl.language, sources_tl.source_lang,
3250: sources_tl.item_source_name, sources_tl.description,
3251: sources_tl.ctx_keywords, sources.image_url, fnd_global.user_id,
3252: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3253: FROM icx_por_item_sources sources, icx_por_item_sources_tl sources_tl
3254: WHERE sources.item_source_id = p_catalog_ids(i)
3255: AND sources_tl.item_source_id = sources.item_source_id;

Line 3252: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

3248: last_update_login)
3249: SELECT p_new_zone_ids(i), sources_tl.language, sources_tl.source_lang,
3250: sources_tl.item_source_name, sources_tl.description,
3251: sources_tl.ctx_keywords, sources.image_url, fnd_global.user_id,
3252: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3253: FROM icx_por_item_sources sources, icx_por_item_sources_tl sources_tl
3254: WHERE sources.item_source_id = p_catalog_ids(i)
3255: AND sources_tl.item_source_id = sources.item_source_id;
3256:

Line 3264: SELECT p_new_zone_ids(i), 'SUPPLIER', supplier_id, fnd_global.user_id,

3260: FORALL i IN 1..p_catalog_ids.COUNT
3261: INSERT INTO icx_cat_zone_secure_attributes
3262: (zone_id, securing_attribute, supplier_id, created_by, creation_date,
3263: last_updated_by, last_update_date, last_update_login)
3264: SELECT p_new_zone_ids(i), 'SUPPLIER', supplier_id, fnd_global.user_id,
3265: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3266: FROM icx_cat_item_src_details
3267: WHERE item_source_id = p_catalog_ids(i);
3268:

Line 3265: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

3261: INSERT INTO icx_cat_zone_secure_attributes
3262: (zone_id, securing_attribute, supplier_id, created_by, creation_date,
3263: last_updated_by, last_update_date, last_update_login)
3264: SELECT p_new_zone_ids(i), 'SUPPLIER', supplier_id, fnd_global.user_id,
3265: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3266: FROM icx_cat_item_src_details
3267: WHERE item_source_id = p_catalog_ids(i);
3268:
3269: l_err_loc := 300;

Line 3347: zones.items_without_shop_catg_flag, fnd_global.user_id,

3343: SELECT p_new_zone_ids(i), 'LOCAL', zones.url, 'RESP_SECURED',
3344: p_category_flag, 'INCLUDE_ALL',
3345: DECODE(g_site_approved_pricing, 'Y', 'N',
3346: zones.items_without_supplier_flag),
3347: zones.items_without_shop_catg_flag, fnd_global.user_id,
3348: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3349: FROM icx_cat_content_zones_b zones
3350: WHERE zones.zone_id = 1;
3351:

Line 3348: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

3344: p_category_flag, 'INCLUDE_ALL',
3345: DECODE(g_site_approved_pricing, 'Y', 'N',
3346: zones.items_without_supplier_flag),
3347: zones.items_without_shop_catg_flag, fnd_global.user_id,
3348: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3349: FROM icx_cat_content_zones_b zones
3350: WHERE zones.zone_id = 1;
3351:
3352: l_err_loc := 100;

Line 3361: zones_tl.keywords, zones_tl.image, fnd_global.user_id,

3357: created_by, creation_date, last_updated_by, last_update_date,
3358: last_update_login)
3359: SELECT p_new_zone_ids(i), zones_tl.language, zones_tl.source_lang,
3360: zones_tl.name, zones_tl.description,
3361: zones_tl.keywords, zones_tl.image, fnd_global.user_id,
3362: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3363: FROM icx_cat_content_zones_tl zones_tl
3364: WHERE zones_tl.zone_id = 1;
3365:

Line 3362: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

3358: last_update_login)
3359: SELECT p_new_zone_ids(i), zones_tl.language, zones_tl.source_lang,
3360: zones_tl.name, zones_tl.description,
3361: zones_tl.keywords, zones_tl.image, fnd_global.user_id,
3362: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3363: FROM icx_cat_content_zones_tl zones_tl
3364: WHERE zones_tl.zone_id = 1;
3365:
3366: l_err_loc := 200;

Line 3462: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,

3458: INSERT INTO icx_cat_zone_secure_attributes
3459: (zone_id, securing_attribute, ip_category_id, created_by, creation_date,
3460: last_updated_by, last_update_date, last_update_login)
3461: SELECT l_zones_to_insert(i), 'CATEGORY', l_categories_to_insert(i),
3462: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3463: fnd_global.login_id
3464: FROM dual;
3465:
3466: -- for statement-level logging, print out values inserted

Line 3463: fnd_global.login_id

3459: (zone_id, securing_attribute, ip_category_id, created_by, creation_date,
3460: last_updated_by, last_update_date, last_update_login)
3461: SELECT l_zones_to_insert(i), 'CATEGORY', l_categories_to_insert(i),
3462: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3463: fnd_global.login_id
3464: FROM dual;
3465:
3466: -- for statement-level logging, print out values inserted
3467: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3615: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,

3611: DECODE(type, 'EXTERNAL', 'PUNCHOUT',
3612: 'DISTSRCH', 'TRANSPARENT_PUNCHOUT',
3613: 'INFO', 'INFORMATIONAL'),
3614: sources.url, p_security_flags(i),
3615: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3616: fnd_global.login_id
3617: FROM icx_por_item_sources sources
3618: WHERE sources.item_source_id = p_item_source_ids(i);
3619:

Line 3616: fnd_global.login_id

3612: 'DISTSRCH', 'TRANSPARENT_PUNCHOUT',
3613: 'INFO', 'INFORMATIONAL'),
3614: sources.url, p_security_flags(i),
3615: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3616: fnd_global.login_id
3617: FROM icx_por_item_sources sources
3618: WHERE sources.item_source_id = p_item_source_ids(i);
3619:
3620: l_err_loc := 100;

Line 3630: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,

3626: last_update_login)
3627: SELECT p_new_zone_ids(i), sources_tl.language, sources_tl.source_lang,
3628: sources_tl.item_source_name, sources_tl.description,
3629: sources_tl.ctx_keywords, sources.image_url,
3630: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3631: fnd_global.login_id
3632: FROM icx_por_item_sources sources, icx_por_item_sources_tl sources_tl
3633: WHERE sources.item_source_id = p_item_source_ids(i)
3634: AND sources_tl.item_source_id = sources.item_source_id;

Line 3631: fnd_global.login_id

3627: SELECT p_new_zone_ids(i), sources_tl.language, sources_tl.source_lang,
3628: sources_tl.item_source_name, sources_tl.description,
3629: sources_tl.ctx_keywords, sources.image_url,
3630: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3631: fnd_global.login_id
3632: FROM icx_por_item_sources sources, icx_por_item_sources_tl sources_tl
3633: WHERE sources.item_source_id = p_item_source_ids(i)
3634: AND sources_tl.item_source_id = sources.item_source_id;
3635:

Line 3658: negotiated_by_preparer_flag, fnd_global.user_id, sysdate,

3654: user_name, company_name, company_number, supplier_name,
3655: supplier_number, key_1, vendor_id, vendor_site_id, encoding,
3656: party_site_id, operator_id, authenticated_key, user_info_flag,
3657: lock_item_flag, icx_session_servlet_flag, operation_allowed,
3658: negotiated_by_preparer_flag, fnd_global.user_id, sysdate,
3659: fnd_global.user_id, sysdate, fnd_global.login_id
3660: FROM icx_por_item_sources
3661: WHERE item_source_id = p_item_source_ids(i)
3662: AND type IN ('EXTERNAL', 'DISTSRCH');

Line 3659: fnd_global.user_id, sysdate, fnd_global.login_id

3655: supplier_number, key_1, vendor_id, vendor_site_id, encoding,
3656: party_site_id, operator_id, authenticated_key, user_info_flag,
3657: lock_item_flag, icx_session_servlet_flag, operation_allowed,
3658: negotiated_by_preparer_flag, fnd_global.user_id, sysdate,
3659: fnd_global.user_id, sysdate, fnd_global.login_id
3660: FROM icx_por_item_sources
3661: WHERE item_source_id = p_item_source_ids(i)
3662: AND type IN ('EXTERNAL', 'DISTSRCH');
3663:

Line 3671: SELECT p_new_zone_ids(i), d.name, d.value, fnd_global.user_id,

3667: FORALL i IN 1..p_new_zone_ids.COUNT
3668: INSERT INTO icx_cat_zone_attributes
3669: (zone_id, attribute_name, attribute_value, created_by, creation_date,
3670: last_updated_by, last_update_date, last_update_login)
3671: SELECT p_new_zone_ids(i), d.name, d.value, fnd_global.user_id,
3672: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3673: FROM icx_por_item_sources s, icx_cat_item_src_details d
3674: WHERE s.item_source_id = p_item_source_ids(i)
3675: AND s.type = 'DISTSRCH'

Line 3672: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

3668: INSERT INTO icx_cat_zone_attributes
3669: (zone_id, attribute_name, attribute_value, created_by, creation_date,
3670: last_updated_by, last_update_date, last_update_login)
3671: SELECT p_new_zone_ids(i), d.name, d.value, fnd_global.user_id,
3672: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3673: FROM icx_por_item_sources s, icx_cat_item_src_details d
3674: WHERE s.item_source_id = p_item_source_ids(i)
3675: AND s.type = 'DISTSRCH'
3676: AND s.item_source_id = d.item_source_id;

Line 3882: SELECT p_new_zone_ids(i), oa.org_id, 'OPERATING_UNIT', fnd_global.user_id,

3878: FORALL i IN 1..p_new_zone_ids.COUNT
3879: INSERT INTO icx_cat_secure_contents
3880: (content_id, org_id, secure_by, created_by, creation_date, last_updated_by,
3881: last_update_date, last_update_login)
3882: SELECT p_new_zone_ids(i), oa.org_id, 'OPERATING_UNIT', fnd_global.user_id,
3883: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3884: FROM icx_cat_store_org_assignments oa
3885: WHERE p_old_store_ids(i) IS NOT NULL
3886: AND oa.store_id = p_old_store_ids(i)

Line 3883: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

3879: INSERT INTO icx_cat_secure_contents
3880: (content_id, org_id, secure_by, created_by, creation_date, last_updated_by,
3881: last_update_date, last_update_login)
3882: SELECT p_new_zone_ids(i), oa.org_id, 'OPERATING_UNIT', fnd_global.user_id,
3883: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3884: FROM icx_cat_store_org_assignments oa
3885: WHERE p_old_store_ids(i) IS NOT NULL
3886: AND oa.store_id = p_old_store_ids(i)
3887: AND p_security_flags(i) = 'OU_SECURED';

Line 3952: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,

3948: INSERT INTO icx_cat_secure_contents
3949: (content_id, responsibility_id, secure_by, created_by, creation_date,
3950: last_updated_by, last_update_date, last_update_login)
3951: SELECT p_new_zone_ids(i), p_resp_ids(i), 'RESPONSIBILITY',
3952: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3953: fnd_global.login_id
3954: FROM dual;
3955:
3956: -- note how many pairs secured

Line 3953: fnd_global.login_id

3949: (content_id, responsibility_id, secure_by, created_by, creation_date,
3950: last_updated_by, last_update_date, last_update_login)
3951: SELECT p_new_zone_ids(i), p_resp_ids(i), 'RESPONSIBILITY',
3952: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3953: fnd_global.login_id
3954: FROM dual;
3955:
3956: -- note how many pairs secured
3957: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN