DBA Data[Home] [Help]

APPS.QP_BULK_UTIL dependencies on FND_GLOBAL

Line 425: ,FND_GLOBAL.USER_ID

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

Line 427: ,FND_GLOBAL.USER_ID

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

Line 428: ,FND_GLOBAL.CONC_LOGIN_ID

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

Line 506: ,FND_GLOBAL.USER_ID

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

Line 508: ,FND_GLOBAL.USER_ID

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

Line 509: ,FND_GLOBAL.CONC_LOGIN_ID

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

Line 660: ,FND_GLOBAL.USER_ID

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

Line 662: ,FND_GLOBAL.USER_ID

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

Line 663: ,FND_GLOBAL.CONC_LOGIN_ID

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

Line 786: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID

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

Line 787: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID

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

Line 966: ,FND_GLOBAL.USER_ID

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

Line 968: ,FND_GLOBAL.USER_ID

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

Line 973: ,FND_GLOBAL.CONC_LOGIN_ID

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

Line 1096: ,FND_GLOBAL.USER_ID

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

Line 1098: ,FND_GLOBAL.USER_ID

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

Line 1099: ,FND_GLOBAL.CONC_LOGIN_ID

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

Line 1177: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID

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

Line 1178: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID

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

Line 1242: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID

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

Line 1243: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID

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

Line 1285: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID

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

Line 1286: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID

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

Line 1409: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID

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

Line 1414: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID

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

Line 1484: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID

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

Line 1485: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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