DBA Data[Home] [Help]

APPS.QPR_CREATE_DEMO_DATA dependencies on QPR_TRANSF_HEADERS_TL

Line 128239: INSERT INTO QPR_TRANSF_HEADERS_TL ("TRANSF_HEADER_ID","LANGUAGE", "SOURCE_LANG",

128235: 'SALESDATA', NULL, 'N', NULL, '1', 'VLB', NULL, 1, '101',
128236: 'Low', 2, sysdate, 2, sysdate, 2, NULL, NULL, NULL, NULL);
128237:
128238:
128239: INSERT INTO QPR_TRANSF_HEADERS_TL ("TRANSF_HEADER_ID","LANGUAGE", "SOURCE_LANG",
128240: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128241: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128242: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128243: select qpr_transf_headers_s.currval,

Line 128288: INTO qpr_transf_headers_tl("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",

128284: 'Low-Medium', 2, sysdate, 2, sysdate, 2, NULL, NULL, NULL,
128285: NULL);
128286:
128287: INSERT
128288: INTO qpr_transf_headers_tl("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
128289: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY",
128290: "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID",
128291: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128292: select qpr_transf_headers_s.currval, l.language_code, 'US',

Line 128338: INTO qpr_transf_headers_tl("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",

128334: 'SALESDATA', NULL, 'N', NULL, '1', 'VLB', NULL, 1, '103',
128335: 'Medium', 2, sysdate, 2, sysdate, 2, NULL, NULL, NULL, NULL);
128336:
128337: INSERT
128338: INTO qpr_transf_headers_tl("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
128339: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY",
128340: "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID",
128341: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128342: select qpr_transf_headers_s.currval, l.language_code, 'US',

Line 128389: INTO qpr_transf_headers_tl("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",

128385: 'Medium-High', 2, sysdate, 2, sysdate, 2, NULL, NULL, NULL,
128386: NULL);
128387:
128388: INSERT
128389: INTO qpr_transf_headers_tl("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
128390: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY",
128391: "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID",
128392: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128393: select qpr_transf_headers_s.currval, l.language_code, 'US',

Line 128438: INTO qpr_transf_headers_tl("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",

128434: 'SALESDATA', NULL, 'N', NULL, '1', 'VLB', NULL, 1, '105',
128435: 'High', 2, sysdate, 2, sysdate, 2, NULL, NULL, NULL, NULL);
128436:
128437: INSERT
128438: INTO qpr_transf_headers_tl("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
128439: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY",
128440: "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID",
128441: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128442: select qpr_transf_headers_s.currval, l.language_code, 'US',

Line 128521: INSERT INTO QPR_TRANSF_HEADERS_TL ("TRANSF_HEADER_ID","LANGUAGE", "SOURCE_LANG",

128517: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '101',
128518: 'Standard Price Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
128519: NULL, NULL, NULL);
128520:
128521: INSERT INTO QPR_TRANSF_HEADERS_TL ("TRANSF_HEADER_ID","LANGUAGE", "SOURCE_LANG",
128522: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128523: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128524: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,
128525: l.language_code, 'US','Standard Price', NULL,SYSDATE, 2,SYSDATE,2, 2, NULL,NULL,NULL,NULL

Line 128566: INSERT INTO QPR_TRANSF_HEADERS_TL ("TRANSF_HEADER_ID","LANGUAGE", "SOURCE_LANG",

128562: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '102',
128563: 'Standard Volume Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
128564: NULL, NULL, NULL);
128565:
128566: INSERT INTO QPR_TRANSF_HEADERS_TL ("TRANSF_HEADER_ID","LANGUAGE", "SOURCE_LANG",
128567: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128568: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128569: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,
128570: l.language_code, 'US','Standard Volume', NULL,

Line 128613: INSERT INTO QPR_TRANSF_HEADERS_TL

128609: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '103',
128610: 'Standard Promo Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
128611: NULL, NULL, NULL);
128612:
128613: INSERT INTO QPR_TRANSF_HEADERS_TL
128614: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
128615: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128616: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128617: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 128660: INSERT INTO QPR_TRANSF_HEADERS_TL

128656: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '104',
128657: 'Standard Order Value Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
128658: NULL, NULL, NULL);
128659:
128660: INSERT INTO QPR_TRANSF_HEADERS_TL
128661: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
128662: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128663: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128664: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 128708: INSERT INTO QPR_TRANSF_HEADERS_TL

128704: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '105',
128705: 'Standard Lumpsum Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
128706: NULL, NULL, NULL);
128707:
128708: INSERT INTO QPR_TRANSF_HEADERS_TL
128709: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
128710: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128711: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128712: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 128755: INSERT INTO QPR_TRANSF_HEADERS_TL

128751: 'Standard F'||'&'||'S Charges', 2,
128752: sysdate, 2, sysdate, 2, NULL, NULL,
128753: NULL, NULL);
128754:
128755: INSERT INTO QPR_TRANSF_HEADERS_TL
128756: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
128757: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128758: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128759: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 128804: INSERT INTO QPR_TRANSF_HEADERS_TL

128800: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '108',
128801: 'User Price Adjustment', 2, sysdate, 2, sysdate, 2, NULL, NULL,
128802: NULL, NULL);
128803:
128804: INSERT INTO QPR_TRANSF_HEADERS_TL
128805: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
128806: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128807: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128808: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 128851: INSERT INTO QPR_TRANSF_HEADERS_TL

128847: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '109',
128848: 'User Volume Adjustment', 2, sysdate, 2, sysdate, 2, NULL, NULL,
128849: NULL, NULL);
128850:
128851: INSERT INTO QPR_TRANSF_HEADERS_TL
128852: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
128853: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128854: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128855: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 128899: INSERT INTO QPR_TRANSF_HEADERS_TL

128895: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '110',
128896: 'User Promo Adjustment', 2, sysdate, 2, sysdate, 2, NULL, NULL,
128897: NULL, NULL);
128898:
128899: INSERT INTO QPR_TRANSF_HEADERS_TL
128900: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
128901: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128902: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128903: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 128947: INSERT INTO QPR_TRANSF_HEADERS_TL

128943: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '111',
128944: 'User Lumpsum Adjustment', 2, sysdate, 2, sysdate, 2, NULL, NULL,
128945: NULL, NULL);
128946:
128947: INSERT INTO QPR_TRANSF_HEADERS_TL
128948: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
128949: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128950: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128951: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 129029: INSERT INTO QPR_TRANSF_HEADERS_TL

129025: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '114',
129026: 'Contract Price Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
129027: NULL, NULL, NULL);
129028:
129029: INSERT INTO QPR_TRANSF_HEADERS_TL
129030: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
129031: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
129032: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129033: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 129076: INSERT INTO QPR_TRANSF_HEADERS_TL

129072: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '115',
129073: 'Contract Volume Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
129074: NULL, NULL, NULL);
129075:
129076: INSERT INTO QPR_TRANSF_HEADERS_TL
129077: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
129078: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
129079: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129080: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 129124: INSERT INTO QPR_TRANSF_HEADERS_TL

129120: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '116',
129121: 'Contract Promo Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
129122: NULL, NULL, NULL);
129123:
129124: INSERT INTO QPR_TRANSF_HEADERS_TL
129125: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
129126: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
129127: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129128: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 129173: INSERT INTO QPR_TRANSF_HEADERS_TL

129169: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '117',
129170: 'Contract Order Value Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
129171: NULL, NULL, NULL);
129172:
129173: INSERT INTO QPR_TRANSF_HEADERS_TL
129174: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
129175: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
129176: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129177: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 129218: INSERT INTO QPR_TRANSF_HEADERS_TL

129214: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '118',
129215: 'Contract Lumpsum Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
129216: NULL, NULL, NULL);
129217:
129218: INSERT INTO QPR_TRANSF_HEADERS_TL
129219: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
129220: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
129221: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129222: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 129267: INSERT INTO QPR_TRANSF_HEADERS_TL

129263: 'Contract F'||'&'||'S Charges',
129264: 2, sysdate, 2, sysdate, 2, NULL, NULL,
129265: NULL, NULL);
129266:
129267: INSERT INTO QPR_TRANSF_HEADERS_TL
129268: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
129269: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
129270: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129271: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 129352: INSERT INTO QPR_TRANSF_HEADERS_TL

129348: 'ADJUSTMENT', 'N', 2, NULL, NULL, NULL, 3, '101',
129349: 'Standard Adjustments', 2, sysdate, 2, sysdate, 2, NULL, NULL,
129350: NULL, NULL);
129351:
129352: INSERT INTO QPR_TRANSF_HEADERS_TL
129353: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
129354: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
129355: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129356: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 129401: INSERT INTO QPR_TRANSF_HEADERS_TL

129397: 'ADJUSTMENT', 'N', 2, NULL, NULL, NULL, 3, '102',
129398: 'User Adjustments', 2, sysdate, 2, sysdate, 2, NULL, NULL,
129399: NULL, NULL);
129400:
129401: INSERT INTO QPR_TRANSF_HEADERS_TL
129402: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
129403: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
129404: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129405: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

Line 129450: INSERT INTO QPR_TRANSF_HEADERS_TL

129446: 'ADJUSTMENT', 'N', 2, NULL, NULL, NULL, 3, '103',
129447: 'Contract Adjustments', 2, sysdate, 2, sysdate, 2, NULL, NULL,
129448: NULL, NULL);
129449:
129450: INSERT INTO QPR_TRANSF_HEADERS_TL
129451: ("TRANSF_HEADER_ID", "LANGUAGE", "SOURCE_LANG",
129452: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
129453: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129454: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,