APPS.ICX_CAT_R12_UPGRADE_PVT dependencies on DUAL

Line 1023: FROM DUAL;

1019: BEGIN
1020: l_err_loc := 100;
1021: SELECT po_headers_interface_s.NEXTVAL
1022: INTO l_interface_header_id
1023: FROM DUAL;
1024:
1025: l_err_loc := 110;
1026: RETURN l_interface_header_id;
1027: EXCEPTION

Line 1046: FROM DUAL;

1042: BEGIN
1043: l_err_loc := 100;
1044: SELECT po_lines_interface_s.NEXTVAL
1045: INTO l_interface_line_id
1046: FROM DUAL;
1047:
1048: l_err_loc := 110;
1049: RETURN l_interface_line_id;
1050: EXCEPTION

Line 1069: FROM DUAL;

1065: BEGIN
1066: l_err_loc := 100;
1067: SELECT por_favorite_list_lines_s.NEXTVAL
1068: INTO l_favorite_list_line_id
1069: FROM DUAL;
1070:
1071: l_err_loc := 110;
1072: RETURN l_favorite_list_line_id;
1073: EXCEPTION

Line 1397: FROM DUAL

1393: gIHCpaReferenceTbl(i), gIHCreatedLanguageTbl(i), gIHCommentsTbl(i),
1394: supp.vendor_name, site.vendor_site_code
1395: FROM (
1396: SELECT gIHVendorIdTbl(i) vendor_id, gIHVendorSiteIdTbl(i) vendor_site_id
1397: FROM DUAL
1398: ) doc,
1399: po_vendors supp, po_vendor_sites_all site
1400: WHERE supp.vendor_id (+) = doc.vendor_id
1401: AND site.vendor_site_id (+) = doc.vendor_site_id;

Line 7637: FROM dual

7633: l_err_loc := 100;
7634: BEGIN
7635: SELECT 1
7636: INTO l_is_attr_already_upgraded
7637: FROM dual
7638: WHERE EXISTS (SELECT 'attribute records'
7639: FROM icx_cat_attributes_tl
7640: WHERE attribute_id > 100);
7641: EXCEPTION

Line 8053: FROM dual

8049: (application_id, profile_option_id, level_id, level_value, last_update_date,
8050: last_updated_by, creation_date, created_by, last_update_login, profile_option_value)
8051: SELECT l_application_id, l_profile_option_id, 10001, 0, sysdate, fnd_global.user_id,
8052: sysdate, fnd_global.user_id, fnd_global.login_id, 'Relevance'
8053: FROM dual
8054: WHERE NOT EXISTS (SELECT 1
8055: FROM fnd_profile_option_values
8056: WHERE application_id = l_application_id
8057: AND profile_option_id = l_profile_option_id

Line 8074: FROM dual

8070: (application_id, profile_option_id, level_id, level_value, last_update_date,
8071: last_updated_by, creation_date, created_by, last_update_login, profile_option_value)
8072: SELECT l_application_id, l_profile_option_id, 10001, 0, sysdate, fnd_global.user_id,
8073: sysdate, fnd_global.user_id, fnd_global.login_id, 'DESC'
8074: FROM dual
8075: WHERE NOT EXISTS (SELECT 1
8076: FROM fnd_profile_option_values
8077: WHERE application_id = l_application_id
8078: AND profile_option_id = l_profile_option_id

Line 8292: FROM DUAL

8288: ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
8289: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
8290: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
8291: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
8292: FROM DUAL
8293: WHERE NOT EXISTS (SELECT 'x' FROM icx_cat_r12_upgrade_jobs
8294: WHERE job_type = ICX_CAT_UTIL_PVT.g_job_type
8295: AND job_number = ICX_CAT_UTIL_PVT.g_job_number );
8296: