DBA Data[Home] [Help]

APPS.QP_BULK_UTIL dependencies on FND_GLOBAL

Line 424: ,FND_GLOBAL.USER_ID

420: **/
421: SELECT
422: P_HEADER_REC.list_header_id(I)
423: ,SYSDATE
424: ,FND_GLOBAL.USER_ID
425: ,SYSDATE
426: ,FND_GLOBAL.USER_ID
427: ,FND_GLOBAL.CONC_LOGIN_ID
428: ,660

Line 426: ,FND_GLOBAL.USER_ID

422: P_HEADER_REC.list_header_id(I)
423: ,SYSDATE
424: ,FND_GLOBAL.USER_ID
425: ,SYSDATE
426: ,FND_GLOBAL.USER_ID
427: ,FND_GLOBAL.CONC_LOGIN_ID
428: ,660
429: ,NUll
430: ,NULL

Line 427: ,FND_GLOBAL.CONC_LOGIN_ID

423: ,SYSDATE
424: ,FND_GLOBAL.USER_ID
425: ,SYSDATE
426: ,FND_GLOBAL.USER_ID
427: ,FND_GLOBAL.CONC_LOGIN_ID
428: ,660
429: ,NUll
430: ,NULL
431: ,P_HEADER_REC.Request_Id(I)

Line 505: ,FND_GLOBAL.USER_ID

501: ,DESCRIPTION
502: ,VERSION_NO)
503: select P_HEADER_REC.LIST_HEADER_ID(I)
504: ,SYSDATE
505: ,FND_GLOBAL.USER_ID
506: ,SYSDATE
507: ,FND_GLOBAL.USER_ID
508: ,FND_GLOBAL.CONC_LOGIN_ID
509: ,L.LANGUAGE_CODE

Line 507: ,FND_GLOBAL.USER_ID

503: select P_HEADER_REC.LIST_HEADER_ID(I)
504: ,SYSDATE
505: ,FND_GLOBAL.USER_ID
506: ,SYSDATE
507: ,FND_GLOBAL.USER_ID
508: ,FND_GLOBAL.CONC_LOGIN_ID
509: ,L.LANGUAGE_CODE
510: ,nvl(P_HEADER_REC.SOURCE_LANG(I),userenv('LANG'))
511: ,P_HEADER_REC.NAME(I)

Line 508: ,FND_GLOBAL.CONC_LOGIN_ID

504: ,SYSDATE
505: ,FND_GLOBAL.USER_ID
506: ,SYSDATE
507: ,FND_GLOBAL.USER_ID
508: ,FND_GLOBAL.CONC_LOGIN_ID
509: ,L.LANGUAGE_CODE
510: ,nvl(P_HEADER_REC.SOURCE_LANG(I),userenv('LANG'))
511: ,P_HEADER_REC.NAME(I)
512: ,P_HEADER_REC.DESCRIPTION(I)

Line 659: ,FND_GLOBAL.USER_ID

655: --changes made for bug no 6028305
656: SELECT
657: P_LINE_REC.LIST_LINE_ID(I)
658: ,sysdate
659: ,FND_GLOBAL.USER_ID
660: ,sysdate
661: ,FND_GLOBAL.USER_ID
662: ,FND_GLOBAL.CONC_LOGIN_ID
663: ,NULL

Line 661: ,FND_GLOBAL.USER_ID

657: P_LINE_REC.LIST_LINE_ID(I)
658: ,sysdate
659: ,FND_GLOBAL.USER_ID
660: ,sysdate
661: ,FND_GLOBAL.USER_ID
662: ,FND_GLOBAL.CONC_LOGIN_ID
663: ,NULL
664: ,NULL
665: ,NULL

Line 662: ,FND_GLOBAL.CONC_LOGIN_ID

658: ,sysdate
659: ,FND_GLOBAL.USER_ID
660: ,sysdate
661: ,FND_GLOBAL.USER_ID
662: ,FND_GLOBAL.CONC_LOGIN_ID
663: ,NULL
664: ,NULL
665: ,NULL
666: ,P_LINE_REC.REQUEST_ID(I)

Line 785: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID

781: loop
782: --qp_bulk_loader_pub.write_log('count'|| i);
783: UPDATE qp_list_lines
784: SET LAST_UPDATE_DATE =sysdate
785: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
786: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
787: ,PROGRAM_APPLICATION_ID =NULL
788: ,PROGRAM_ID =NULL
789: ,PROGRAM_UPDATE_DATE =NULL

Line 786: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID

782: --qp_bulk_loader_pub.write_log('count'|| i);
783: UPDATE qp_list_lines
784: SET LAST_UPDATE_DATE =sysdate
785: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
786: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
787: ,PROGRAM_APPLICATION_ID =NULL
788: ,PROGRAM_ID =NULL
789: ,PROGRAM_UPDATE_DATE =NULL
790: ,REQUEST_ID =P_LINE_REC.REQUEST_ID(I)

Line 965: ,FND_GLOBAL.USER_ID

961: )
962: VALUES
963: (P_QUALIFIER_REC.QUALIFIER_ID(I)
964: ,SYSDATE
965: ,FND_GLOBAL.USER_ID
966: ,SYSDATE
967: ,FND_GLOBAL.USER_ID
968: ,P_QUALIFIER_REC.request_id(I)
969: ,660

Line 967: ,FND_GLOBAL.USER_ID

963: (P_QUALIFIER_REC.QUALIFIER_ID(I)
964: ,SYSDATE
965: ,FND_GLOBAL.USER_ID
966: ,SYSDATE
967: ,FND_GLOBAL.USER_ID
968: ,P_QUALIFIER_REC.request_id(I)
969: ,660
970: ,NULL
971: ,NULL

Line 972: ,FND_GLOBAL.CONC_LOGIN_ID

968: ,P_QUALIFIER_REC.request_id(I)
969: ,660
970: ,NULL
971: ,NULL
972: ,FND_GLOBAL.CONC_LOGIN_ID
973: ,P_QUALIFIER_REC.QUALIFIER_GROUPING_NO(I)
974: ,P_QUALIFIER_REC.QUALIFIER_CONTEXT(I)
975: ,P_QUALIFIER_REC.QUALIFIER_ATTRIBUTE(I)
976: ,P_QUALIFIER_REC.QUALIFIER_ATTR_VALUE(I)

Line 1095: ,FND_GLOBAL.USER_ID

1091: -- Bug No 6028305
1092: SELECT
1093: QP_PRICING_ATTRIBUTES_S.nextval
1094: ,sysdate
1095: ,FND_GLOBAL.USER_ID
1096: ,sysdate
1097: ,FND_GLOBAL.USER_ID
1098: ,FND_GLOBAL.CONC_LOGIN_ID
1099: ,null

Line 1097: ,FND_GLOBAL.USER_ID

1093: QP_PRICING_ATTRIBUTES_S.nextval
1094: ,sysdate
1095: ,FND_GLOBAL.USER_ID
1096: ,sysdate
1097: ,FND_GLOBAL.USER_ID
1098: ,FND_GLOBAL.CONC_LOGIN_ID
1099: ,null
1100: ,null
1101: ,null

Line 1098: ,FND_GLOBAL.CONC_LOGIN_ID

1094: ,sysdate
1095: ,FND_GLOBAL.USER_ID
1096: ,sysdate
1097: ,FND_GLOBAL.USER_ID
1098: ,FND_GLOBAL.CONC_LOGIN_ID
1099: ,null
1100: ,null
1101: ,null
1102: ,P_PRICING_ATTR_REC.REQUEST_ID(I)

Line 1176: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID

1172: P_HEADER_REC.list_header_id.FIRST..P_HEADER_REC.list_header_id.LAST
1173:
1174: UPDATE qp_list_headers_b
1175: SET LAST_UPDATE_DATE =SYSDATE
1176: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1177: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
1178: ,PROGRAM_APPLICATION_ID =661
1179: ,PROGRAM_ID =NUll
1180: ,PROGRAM_UPDATE_DATE =NULL

Line 1177: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID

1173:
1174: UPDATE qp_list_headers_b
1175: SET LAST_UPDATE_DATE =SYSDATE
1176: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1177: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
1178: ,PROGRAM_APPLICATION_ID =661
1179: ,PROGRAM_ID =NUll
1180: ,PROGRAM_UPDATE_DATE =NULL
1181: ,REQUEST_ID =P_HEADER_REC.Request_Id(I)

Line 1241: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID

1237: P_HEADER_REC.list_header_id.FIRST..P_HEADER_REC.list_header_id.LAST
1238:
1239: UPDATE QP_LIST_HEADERS_TL
1240: SET LAST_UPDATE_DATE =SYSDATE
1241: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1242: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
1243: ,LANGUAGE =nvl(P_HEADER_REC.LANGUAGE(I),LANGUAGE)
1244: ,SOURCE_LANG =nvl(P_HEADER_REC.SOURCE_LANG(I),SOURCE_LANG)
1245: ,NAME =P_HEADER_REC.NAME(I)

Line 1242: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID

1238:
1239: UPDATE QP_LIST_HEADERS_TL
1240: SET LAST_UPDATE_DATE =SYSDATE
1241: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1242: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
1243: ,LANGUAGE =nvl(P_HEADER_REC.LANGUAGE(I),LANGUAGE)
1244: ,SOURCE_LANG =nvl(P_HEADER_REC.SOURCE_LANG(I),SOURCE_LANG)
1245: ,NAME =P_HEADER_REC.NAME(I)
1246: ,DESCRIPTION =P_HEADER_REC.DESCRIPTION(I)

Line 1284: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID

1280: P_LINE_REC.orig_sys_line_ref.FIRST..P_LINE_REC.orig_sys_line_ref.LAST
1281:
1282: UPDATE qp_list_lines
1283: SET LAST_UPDATE_DATE =sysdate
1284: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1285: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
1286: ,PROGRAM_APPLICATION_ID =NULL
1287: ,PROGRAM_ID =NULL
1288: ,PROGRAM_UPDATE_DATE =NULL

Line 1285: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID

1281:
1282: UPDATE qp_list_lines
1283: SET LAST_UPDATE_DATE =sysdate
1284: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1285: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
1286: ,PROGRAM_APPLICATION_ID =NULL
1287: ,PROGRAM_ID =NULL
1288: ,PROGRAM_UPDATE_DATE =NULL
1289: ,REQUEST_ID =P_LINE_REC.REQUEST_ID(I)

Line 1408: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID

1404: P_QUALIFIER_REC.orig_sys_qualifier_ref.FIRST..P_QUALIFIER_REC.orig_sys_qualifier_ref.LAST
1405:
1406: UPDATE qp_qualifiers
1407: SET LAST_UPDATE_DATE =SYSDATE
1408: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1409: ,REQUEST_ID =P_QUALIFIER_REC.request_id(I)
1410: ,PROGRAM_APPLICATION_ID =660
1411: ,PROGRAM_ID =NULL
1412: ,PROGRAM_UPDATE_DATE =NULL

Line 1413: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID

1409: ,REQUEST_ID =P_QUALIFIER_REC.request_id(I)
1410: ,PROGRAM_APPLICATION_ID =660
1411: ,PROGRAM_ID =NULL
1412: ,PROGRAM_UPDATE_DATE =NULL
1413: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
1414: ,QUALIFIER_GROUPING_NO =P_QUALIFIER_REC.QUALIFIER_GROUPING_NO(I)
1415: ,QUALIFIER_CONTEXT =P_QUALIFIER_REC.QUALIFIER_CONTEXT(I)
1416: ,QUALIFIER_ATTRIBUTE =P_QUALIFIER_REC.QUALIFIER_ATTRIBUTE(I)
1417: ,QUALIFIER_ATTR_VALUE =P_QUALIFIER_REC.QUALIFIER_ATTR_VALUE(I)

Line 1483: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID

1479: ..P_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.LAST
1480:
1481: UPDATE qp_pricing_attributes
1482: SET LAST_UPDATE_DATE =sysdate
1483: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1484: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
1485: ,PROGRAM_APPLICATION_ID =null
1486: ,PROGRAM_ID =null
1487: ,PROGRAM_UPDATE_DATE =null

Line 1484: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID

1480:
1481: UPDATE qp_pricing_attributes
1482: SET LAST_UPDATE_DATE =sysdate
1483: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1484: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
1485: ,PROGRAM_APPLICATION_ID =null
1486: ,PROGRAM_ID =null
1487: ,PROGRAM_UPDATE_DATE =null
1488: ,REQUEST_ID =P_PRICING_ATTR_REC.REQUEST_ID(I)

Line 1575: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

1571: program_id, program_update_date, entity_type, table_name, column_name,
1572: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1573: orig_sys_pricing_attr_ref,error_message)
1574: SELECT
1575: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1576: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1577: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', NULL,
1578: orig_sys_header_ref,null,null, null,l_msg_txt
1579: FROM QP_INTERFACE_LIST_HEADERS

Line 1576: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,

1572: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1573: orig_sys_pricing_attr_ref,error_message)
1574: SELECT
1575: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1576: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1577: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', NULL,
1578: orig_sys_header_ref,null,null, null,l_msg_txt
1579: FROM QP_INTERFACE_LIST_HEADERS
1580: WHERE request_id = p_request_id

Line 1621: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

1617: program_id, program_update_date, entity_type, table_name, column_name,
1618: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1619: orig_sys_pricing_attr_ref, error_message)
1620: SELECT
1621: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1622: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1623: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
1624: orig_sys_header_ref,null,orig_sys_qualifier_ref,null, l_msg_txt
1625: FROM QP_INTERFACE_QUALIFIERS qpiq

Line 1622: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,

1618: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1619: orig_sys_pricing_attr_ref, error_message)
1620: SELECT
1621: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1622: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1623: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
1624: orig_sys_header_ref,null,orig_sys_qualifier_ref,null, l_msg_txt
1625: FROM QP_INTERFACE_QUALIFIERS qpiq
1626: WHERE request_id = p_request_id

Line 1693: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

1689: program_id, program_update_date, entity_type, table_name, column_name,
1690: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1691: orig_sys_pricing_attr_ref,error_message)
1692: SELECT
1693: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1694: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1695: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
1696: orig_sys_header_ref,orig_sys_line_ref,null,null, l_msg_txt
1697: FROM QP_INTERFACE_LIST_LINES qpil

Line 1694: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,

1690: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1691: orig_sys_pricing_attr_ref,error_message)
1692: SELECT
1693: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1694: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1695: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
1696: orig_sys_header_ref,orig_sys_line_ref,null,null, l_msg_txt
1697: FROM QP_INTERFACE_LIST_LINES qpil
1698: WHERE request_id = p_request_id

Line 1809: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

1805: program_id, program_update_date, entity_type, table_name, column_name,
1806: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1807: orig_sys_pricing_attr_ref,error_message)
1808: SELECT
1809: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1810: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1811: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,
1812: orig_sys_header_ref,orig_sys_line_ref,null,orig_sys_pricing_attr_ref, l_msg_txt
1813: FROM QP_INTERFACE_PRICING_ATTRIBS qpip

Line 1810: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,

1806: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1807: orig_sys_pricing_attr_ref,error_message)
1808: SELECT
1809: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1810: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1811: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,
1812: orig_sys_header_ref,orig_sys_line_ref,null,orig_sys_pricing_attr_ref, l_msg_txt
1813: FROM QP_INTERFACE_PRICING_ATTRIBS qpip
1814: WHERE request_id = p_request_id

Line 1848: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

1844: program_id, program_update_date, entity_type, table_name, column_name,
1845: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1846: orig_sys_pricing_attr_ref,error_message)
1847: SELECT
1848: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1849: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1850: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,
1851: orig_sys_header_ref,orig_sys_line_ref,null,orig_sys_pricing_attr_ref, l_msg_txt
1852: FROM QP_INTERFACE_PRICING_ATTRIBS qpip

Line 1849: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,

1845: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
1846: orig_sys_pricing_attr_ref,error_message)
1847: SELECT
1848: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1849: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1850: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,
1851: orig_sys_header_ref,orig_sys_line_ref,null,orig_sys_pricing_attr_ref, l_msg_txt
1852: FROM QP_INTERFACE_PRICING_ATTRIBS qpip
1853: WHERE request_id = p_request_id