DBA Data[Home] [Help]

APPS.QPR_CREATE_DEMO_DATA dependencies on QPR_TRANSF_HEADERS_S

Line 128234: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval,

128230: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128231: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128232: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128233: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128234: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval,
128235: 'SALESDATA', NULL, 'N', NULL, '1', 'VLB', NULL, 1, '101',
128236: 'Low', 2, sysdate, 2, sysdate, 2, NULL, NULL, NULL, NULL);
128237:
128238:

Line 128243: select qpr_transf_headers_s.currval,

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,
128244: l.language_code, 'US','Low Volume', NULL, SYSDATE, 2, SYSDATE, 2,2, NULL, NULL, NULL, NULL from fnd_languages l where l.installed_flag in ('B', 'I');
128245:
128246:
128247: --- inserting rules ----

Line 128259: QPR_TRANSF_HEADERS_S.CURRVAL, '0', '25', NULL, NULL, 'N',NULL, NULL, NULL, NULL,

128255: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128256: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128257: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128258: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128259: QPR_TRANSF_HEADERS_S.CURRVAL, '0', '25', NULL, NULL, 'N',NULL, NULL, NULL, NULL,
128260: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
128261: NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128262:
128263: INSERT

Line 128282: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval,

128278: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128279: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128280: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128281: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128282: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval,
128283: 'SALESDATA', NULL, 'N', NULL, '1', 'VLB', NULL, 1, '102',
128284: 'Low-Medium', 2, sysdate, 2, sysdate, 2, NULL, NULL, NULL,
128285: NULL);
128286:

Line 128292: select qpr_transf_headers_s.currval, l.language_code, 'US',

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',
128293: 'Low-Medium Volume',
128294: NULL, sysdate, 2,sysdate, 2, 2, NULL, NULL, NULL, NULL
128295: from fnd_languages l where l.language_code in ('B', 'I');
128296:

Line 128309: QPR_TRANSF_HEADERS_S.CURRVAL, '26', '50', NULL, NULL, 'N', NULL, NULL, NULL,

128305: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128306: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128307: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128308: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128309: QPR_TRANSF_HEADERS_S.CURRVAL, '26', '50', NULL, NULL, 'N', NULL, NULL, NULL,
128310: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
128311: NULL, NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128312:
128313: INSERT

Line 128333: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval,

128329: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128330: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128331: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128332: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128333: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval,
128334: 'SALESDATA', NULL, 'N', NULL, '1', 'VLB', NULL, 1, '103',
128335: 'Medium', 2, sysdate, 2, sysdate, 2, NULL, NULL, NULL, NULL);
128336:
128337: INSERT

Line 128342: select qpr_transf_headers_s.currval, l.language_code, 'US',

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',
128343: 'Medium Volume Band',
128344: NULL, sysdate, 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
128345: from fnd_languages l where l.installed_flag in ('B', 'I');
128346:

Line 128359: QPR_TRANSF_HEADERS_S.CURRVAL, '51', '75', NULL, NULL, 'N', NULL, NULL, NULL,

128355: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128356: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128357: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128358: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128359: QPR_TRANSF_HEADERS_S.CURRVAL, '51', '75', NULL, NULL, 'N', NULL, NULL, NULL,
128360: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
128361: NULL, NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128362:
128363: INSERT

Line 128383: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval,

128379: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128380: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128381: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128382: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128383: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval,
128384: 'SALESDATA', NULL, 'N', NULL, '1', 'VLB', NULL, 1, '104',
128385: 'Medium-High', 2, sysdate, 2, sysdate, 2, NULL, NULL, NULL,
128386: NULL);
128387:

Line 128393: select qpr_transf_headers_s.currval, l.language_code, 'US',

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',
128394: 'Medium High Volume Band',
128395: NULL, sysdate,2, sysdate, 2, 2, NULL, NULL, NULL, NULL
128396: from fnd_languages l where l.installed_flag in ('B', 'I');
128397:

Line 128410: QPR_TRANSF_HEADERS_S.CURRVAL, '76', '100', NULL, NULL, 'N', NULL, NULL, NULL,

128406: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128407: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128408: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128409: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128410: QPR_TRANSF_HEADERS_S.CURRVAL, '76', '100', NULL, NULL, 'N', NULL, NULL, NULL,
128411: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
128412: NULL, NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128413:
128414: INSERT

Line 128433: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval,

128429: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128430: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128431: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128432: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128433: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval,
128434: 'SALESDATA', NULL, 'N', NULL, '1', 'VLB', NULL, 1, '105',
128435: 'High', 2, sysdate, 2, sysdate, 2, NULL, NULL, NULL, NULL);
128436:
128437: INSERT

Line 128442: select qpr_transf_headers_s.currval, l.language_code, 'US',

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',
128443: 'High Volume Band',
128444: NULL, sysdate, 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
128445: from fnd_languages l where l.installed_flag in ('B', 'I');
128446:

Line 128461: QPR_TRANSF_HEADERS_S.CURRVAL, '101', NULL, NULL, NULL, 'N', NULL, NULL, NULL,

128457: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128458: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128459: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128460: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128461: QPR_TRANSF_HEADERS_S.CURRVAL, '101', NULL, NULL, NULL, 'N', NULL, NULL, NULL,
128462: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
128463: NULL, NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128464:
128465: INSERT

Line 128516: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

128512: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128513: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128514: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128515: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128516: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
128517: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '101',
128518: 'Standard Price Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
128519: NULL, NULL, NULL);
128520:

Line 128524: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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
128526: from fnd_languages l where l.installed_flag in ('B', 'I');
128527:
128528: --- inserting rules ---

Line 128540: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',

128536: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128537: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128538: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128539: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128540: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',
128541: 'N', 'Y', 'Y', 'N', NULL, NULL, NULL, 'LINE', 'LINE', 'N', NULL, NULL, NULL,
128542: NULL, NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128543:
128544: INSERT INTO QPR_TRANSF_RULES_TL ("TRANSF_RULE_ID", "LANGUAGE", "SOURCE_LANG",

Line 128561: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

128557: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128558: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128559: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128560: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128561: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
128562: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '102',
128563: 'Standard Volume Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
128564: NULL, NULL, NULL);
128565:

Line 128569: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
128571: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128572: from fnd_languages l where l.installed_flag in ('B', 'I');
128573:

Line 128587: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'PBH', 'PBH',

128583: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128584: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128585: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128586: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128587: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'PBH', 'PBH',
128588: 'N', 'Y', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
128589: NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128590:
128591: INSERT INTO QPR_TRANSF_RULES_TL ("TRANSF_RULE_ID", "LANGUAGE", "SOURCE_LANG",

Line 128608: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

128604: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128605: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128606: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128607: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128608: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
128609: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '103',
128610: 'Standard Promo Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
128611: NULL, NULL, NULL);
128612:

Line 128617: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
128618: l.language_code, 'US','Standard Promo', NULL,
128619: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128620: from fnd_languages l where l.installed_flag in ('B', 'I');
128621:

Line 128634: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',

128630: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128631: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128632: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128633: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128634: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',
128635: 'N', 'Y', 'Y', 'N', NULL, NULL, NULL, 'LINEGROUP', 'LINEGROUP', 'N', NULL, NULL,
128636: NULL, NULL, NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128637:
128638: INSERT INTO QPR_TRANSF_RULES_TL ("TRANSF_RULE_ID", "LANGUAGE", "SOURCE_LANG",

Line 128655: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

128651: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128652: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128653: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128654: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128655: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
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:

Line 128664: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
128665: l.language_code, 'US','Standard Order Value',
128666: NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128667: from fnd_languages l where l.installed_flag in ('B', 'I');
128668:

Line 128681: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',

128677: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128678: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128679: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128680: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128681: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',
128682: 'N', 'Y', 'Y', 'N', NULL, NULL, NULL, 'ORDER', 'ORDER', 'N', NULL, NULL, NULL,
128683: NULL, NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128684:
128685: INSERT INTO QPR_TRANSF_RULES_TL ("TRANSF_RULE_ID", "LANGUAGE", "SOURCE_LANG",

Line 128703: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

128699: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128700: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128701: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128702: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128703: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
128704: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '105',
128705: 'Standard Lumpsum Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
128706: NULL, NULL, NULL);
128707:

Line 128712: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
128713: l.language_code, 'US','Standard Lumpsum', NULL,
128714: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128715: from fnd_languages l where l.installed_flag in ('B', 'I');
128716: ----- isnerting rules ----

Line 128728: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',

128724: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128725: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128726: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128727: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128728: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',
128729: 'N', 'Y', 'Y', 'N', 'LUMPSUM', 'LUMPSUM', NULL, NULL, NULL, NULL, NULL, NULL,
128730: NULL, NULL, NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128731:
128732: INSERT INTO QPR_TRANSF_RULES_TL ("TRANSF_RULE_ID", "LANGUAGE", "SOURCE_LANG",

Line 128749: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

128745: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128746: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128747: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128748: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128749: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
128750: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '107',
128751: 'Standard F'||'&'||'S Charges', 2,
128752: sysdate, 2, sysdate, 2, NULL, NULL,
128753: NULL, NULL);

Line 128759: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
128760: l.language_code, 'US','Standard F'||'&'||'S', NULL,
128761: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128762: from fnd_languages l where l.installed_flag in ('B', 'I');
128763:

Line 128776: QPR_TRANSF_HEADERS_S.CURRVAL, NULL,

128772: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128773: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128774: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128775: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128776: QPR_TRANSF_HEADERS_S.CURRVAL, NULL,
128777: NULL, NULL, NULL, 'Y', 'N', 'FREIGHT_CHARGE',
128778: 'FREIGHT_CHARGE', 'N', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
128779: NULL, NULL, NULL, NULL, NULL, SYSDATE,
128780: 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);

Line 128799: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

128795: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128796: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128797: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128798: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128799: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
128800: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '108',
128801: 'User Price Adjustment', 2, sysdate, 2, sysdate, 2, NULL, NULL,
128802: NULL, NULL);
128803:

Line 128808: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
128809: l.language_code, 'US','User Price', NULL, SYSDATE, 2,
128810: SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128811: from fnd_languages l where l.installed_flag in ('B', 'I');
128812:

Line 128826: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',

128822: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128823: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128824: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128825: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128826: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',
128827: 'N', 'N', 'N', 'N', NULL, NULL, NULL, 'LINE', 'LINE', 'N', NULL, NULL, NULL,
128828: NULL, NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128829:
128830: INSERT INTO QPR_TRANSF_RULES_TL ("TRANSF_RULE_ID", "LANGUAGE", "SOURCE_LANG",

Line 128846: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

128842: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128843: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128844: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128845: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128846: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
128847: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '109',
128848: 'User Volume Adjustment', 2, sysdate, 2, sysdate, 2, NULL, NULL,
128849: NULL, NULL);
128850:

Line 128855: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
128856: l.language_code, 'US','User Volume', NULL,
128857: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128858: from fnd_languages l where l.installed_flag in ('B', 'I');
128859:

Line 128873: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'PBH', 'PBH',

128869: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128870: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128871: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128872: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128873: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'PBH', 'PBH',
128874: 'N', 'N', 'N', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
128875: NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128876:
128877: INSERT INTO QPR_TRANSF_RULES_TL ("TRANSF_RULE_ID", "LANGUAGE", "SOURCE_LANG",

Line 128894: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

128890: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128891: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128892: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128893: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128894: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
128895: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '110',
128896: 'User Promo Adjustment', 2, sysdate, 2, sysdate, 2, NULL, NULL,
128897: NULL, NULL);
128898:

Line 128903: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
128904: l.language_code, 'US','User Promo', NULL, SYSDATE, 2,
128905: SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128906: from fnd_languages l where l.installed_flag in ('B', 'I');
128907:

Line 128921: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',

128917: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128918: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128919: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128920: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128921: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',
128922: 'N', 'N', 'N', 'N', NULL, NULL, NULL, 'LINEGROUP', 'LINEGROUP', 'N', NULL, NULL,
128923: NULL, NULL, NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128924:
128925: INSERT INTO QPR_TRANSF_RULES_TL ("TRANSF_RULE_ID", "LANGUAGE", "SOURCE_LANG",

Line 128942: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

128938: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
128939: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
128940: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128941: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128942: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
128943: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '111',
128944: 'User Lumpsum Adjustment', 2, sysdate, 2, sysdate, 2, NULL, NULL,
128945: NULL, NULL);
128946:

Line 128951: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
128952: l.language_code, 'US','User Lumpsum', NULL,
128953: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128954: from fnd_languages l where l.installed_flag in ('B', 'I');
128955:

Line 128968: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',

128964: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
128965: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
128966: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128967: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
128968: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, NULL, NULL, 'Y', 'N', 'DIS', 'DIS',
128969: 'N', 'N', 'N', 'N', 'LUMPSUM', 'LUMPSUM', 'N', NULL, NULL, NULL, NULL, NULL,
128970: NULL, NULL, NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
128971:
128972: INSERT INTO QPR_TRANSF_RULES_TL ("TRANSF_RULE_ID", "LANGUAGE", "SOURCE_LANG",

Line 129024: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

129020: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129021: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
129022: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129023: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129024: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
129025: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '114',
129026: 'Contract Price Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
129027: NULL, NULL, NULL);
129028:

Line 129033: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
129034: l.language_code, 'US','Contract Price', NULL,
129035: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129036: from fnd_languages l where l.installed_flag in ('B', 'I');
129037:

Line 129050: ,QPR_TRANSF_HEADERS_S.CURRVAL ,NULL ,NULL ,NULL ,NULL ,'Y' ,'N' ,'DIS' ,'DIS'

129046: ,"ATTRIBUTE5_NUMBER_FLAG" ,"LIMIT_DIM_CODE" ,"LIMIT_DIM_LEVEL"
129047: ,"LIMIT_DIM_LEVEL_VALUE" ,"CREATION_DATE" ,"CREATED_BY" ,"LAST_UPDATE_DATE"
129048: ,"LAST_UPDATED_BY" ,"LAST_UPDATE_LOGIN" ,"PROGRAM_ID" ,"PROGRAM_LOGIN_ID"
129049: ,"PROGRAM_APPLICATION_ID" ,"REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL
129050: ,QPR_TRANSF_HEADERS_S.CURRVAL ,NULL ,NULL ,NULL ,NULL ,'Y' ,'N' ,'DIS' ,'DIS'
129051: ,'N' ,'Y' ,'Y' ,'N' ,NULL ,NULL ,NULL ,'LINE' ,'LINE' ,'N' ,'BSO' ,'BSO' ,'N'
129052: ,NULL ,NULL ,NULL ,SYSDATE ,2 ,SYSDATE ,2 ,2 ,NULL ,NULL ,NULL ,NULL);
129053:
129054: INSERT INTO QPR_TRANSF_RULES_TL ("TRANSF_RULE_ID", "LANGUAGE", "SOURCE_LANG",

Line 129071: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

129067: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129068: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
129069: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129070: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129071: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
129072: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '115',
129073: 'Contract Volume Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
129074: NULL, NULL, NULL);
129075:

Line 129080: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
129081: l.language_code, 'US','Contract Volume', NULL,
129082: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129083: from fnd_languages l where l.installed_flag in ('B', 'I');
129084:

Line 129098: ,QPR_TRANSF_HEADERS_S.CURRVAL ,NULL ,NULL ,NULL ,NULL ,'Y' ,'N' ,'PBH' ,'PBH'

129094: ,"ATTRIBUTE5_NUMBER_FLAG" ,"LIMIT_DIM_CODE" ,"LIMIT_DIM_LEVEL"
129095: ,"LIMIT_DIM_LEVEL_VALUE" ,"CREATION_DATE" ,"CREATED_BY" ,"LAST_UPDATE_DATE"
129096: ,"LAST_UPDATED_BY" ,"LAST_UPDATE_LOGIN" ,"PROGRAM_ID" ,"PROGRAM_LOGIN_ID"
129097: ,"PROGRAM_APPLICATION_ID" ,"REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL
129098: ,QPR_TRANSF_HEADERS_S.CURRVAL ,NULL ,NULL ,NULL ,NULL ,'Y' ,'N' ,'PBH' ,'PBH'
129099: ,'N' ,'Y' ,'Y' ,'N' ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,'BSO' ,'BSO' ,'N' ,NULL
129100: ,NULL ,NULL ,SYSDATE ,2 ,SYSDATE ,2 ,2 ,NULL ,NULL ,NULL ,NULL);
129101:
129102: INSERT INTO QPR_TRANSF_RULES_TL ("TRANSF_RULE_ID", "LANGUAGE", "SOURCE_LANG",

Line 129119: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

129115: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129116: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
129117: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129118: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129119: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
129120: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '116',
129121: 'Contract Promo Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
129122: NULL, NULL, NULL);
129123:

Line 129128: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
129129: l.language_code, 'US','Contract Promo', NULL,
129130: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129131: from fnd_languages l where l.installed_flag in ('B', 'I');
129132:

Line 129146: ,QPR_TRANSF_HEADERS_S.CURRVAL ,NULL ,NULL ,NULL ,NULL ,'Y' ,'N' ,'DIS' ,'DIS'

129142: ,"ATTRIBUTE5_NUMBER_FLAG" ,"LIMIT_DIM_CODE" ,"LIMIT_DIM_LEVEL"
129143: ,"LIMIT_DIM_LEVEL_VALUE" ,"CREATION_DATE" ,"CREATED_BY" ,"LAST_UPDATE_DATE"
129144: ,"LAST_UPDATED_BY" ,"LAST_UPDATE_LOGIN" ,"PROGRAM_ID" ,"PROGRAM_LOGIN_ID"
129145: ,"PROGRAM_APPLICATION_ID" ,"REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL
129146: ,QPR_TRANSF_HEADERS_S.CURRVAL ,NULL ,NULL ,NULL ,NULL ,'Y' ,'N' ,'DIS' ,'DIS'
129147: ,'N' ,'Y' ,'Y' ,'N' ,NULL ,NULL ,NULL ,'LINEGROUP' ,'LINEGROUP' ,'N' ,'BSO'
129148: ,'BSO' ,'N' ,NULL ,NULL ,NULL ,
129149: SYSDATE ,2 ,SYSDATE ,2 ,2 ,NULL ,NULL ,NULL ,NULL);
129150:

Line 129168: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

129164: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129165: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
129166: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129167: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129168: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
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:

Line 129177: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
129178: l.language_code, 'US','Contract Order Value',
129179: NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129180: from fnd_languages l where l.installed_flag in ('B', 'I');
129181: --- inserting rules ----

Line 129193: ,QPR_TRANSF_HEADERS_S.CURRVAL ,NULL ,NULL ,NULL ,NULL ,'Y' ,'N' ,'DIS' ,'DIS'

129189: ,"ATTRIBUTE5_NUMBER_FLAG" ,"LIMIT_DIM_CODE" ,"LIMIT_DIM_LEVEL"
129190: ,"LIMIT_DIM_LEVEL_VALUE" ,"CREATION_DATE" ,"CREATED_BY" ,"LAST_UPDATE_DATE"
129191: ,"LAST_UPDATED_BY" ,"LAST_UPDATE_LOGIN" ,"PROGRAM_ID" ,"PROGRAM_LOGIN_ID"
129192: ,"PROGRAM_APPLICATION_ID" ,"REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL
129193: ,QPR_TRANSF_HEADERS_S.CURRVAL ,NULL ,NULL ,NULL ,NULL ,'Y' ,'N' ,'DIS' ,'DIS'
129194: ,'N' ,'Y' ,'Y' ,'N' ,NULL ,NULL ,NULL ,'ORDER' ,'ORDER' ,'N' ,'BSO' ,'BSO' ,'N'
129195: ,NULL ,NULL ,NULL ,SYSDATE ,2 ,SYSDATE ,2 ,2 ,NULL ,NULL ,NULL ,NULL);
129196:
129197: INSERT INTO QPR_TRANSF_RULES_TL ("TRANSF_RULE_ID", "LANGUAGE", "SOURCE_LANG",

Line 129213: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

129209: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129210: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
129211: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129212: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129213: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
129214: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '118',
129215: 'Contract Lumpsum Adjustment', 2, sysdate, 2, sysdate, 2, NULL,
129216: NULL, NULL, NULL);
129217:

Line 129222: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
129223: l.language_code, 'US','Contract Lumpsum', NULL,
129224: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129225: from fnd_languages l where l.installed_flag in ('B', 'I');
129226:

Line 129240: ,QPR_TRANSF_HEADERS_S.CURRVAL ,NULL ,NULL ,NULL ,NULL ,'Y' ,'N' ,'DIS' ,'DIS'

129236: ,"ATTRIBUTE5_NUMBER_FLAG" ,"LIMIT_DIM_CODE" ,"LIMIT_DIM_LEVEL"
129237: ,"LIMIT_DIM_LEVEL_VALUE" ,"CREATION_DATE" ,"CREATED_BY" ,"LAST_UPDATE_DATE"
129238: ,"LAST_UPDATED_BY" ,"LAST_UPDATE_LOGIN" ,"PROGRAM_ID" ,"PROGRAM_LOGIN_ID"
129239: ,"PROGRAM_APPLICATION_ID" ,"REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL
129240: ,QPR_TRANSF_HEADERS_S.CURRVAL ,NULL ,NULL ,NULL ,NULL ,'Y' ,'N' ,'DIS' ,'DIS'
129241: ,'N' ,'Y' ,'Y' ,'N' ,'LUMPSUM' ,'LUMPSUM' ,'N' ,NULL ,NULL ,NULL ,'BSO' ,'BSO'
129242: ,'N' ,NULL ,NULL ,NULL ,SYSDATE ,2 ,SYSDATE ,2 ,2 ,NULL ,NULL ,NULL ,NULL);
129243:
129244: INSERT INTO QPR_TRANSF_RULES_TL ("TRANSF_RULE_ID", "LANGUAGE", "SOURCE_LANG",

Line 129261: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

129257: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129258: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
129259: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129260: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129261: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
129262: 'ADJUSTMENT', 'N', 1, NULL, NULL, NULL, 2, '120',
129263: 'Contract F'||'&'||'S Charges',
129264: 2, sysdate, 2, sysdate, 2, NULL, NULL,
129265: NULL, NULL);

Line 129271: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
129272: l.language_code, 'US','Contract F'||'&'||'S',
129273: NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129274: from fnd_languages l where l.installed_flag in ('B', 'I');
129275:

Line 129289: ,QPR_TRANSF_HEADERS_S.CURRVAL ,NULL ,

129285: ,"ATTRIBUTE5_NUMBER_FLAG" ,"LIMIT_DIM_CODE" ,"LIMIT_DIM_LEVEL"
129286: ,"LIMIT_DIM_LEVEL_VALUE" ,"CREATION_DATE" ,"CREATED_BY" ,"LAST_UPDATE_DATE"
129287: ,"LAST_UPDATED_BY" ,"LAST_UPDATE_LOGIN" ,"PROGRAM_ID" ,"PROGRAM_LOGIN_ID"
129288: ,"PROGRAM_APPLICATION_ID" ,"REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL
129289: ,QPR_TRANSF_HEADERS_S.CURRVAL ,NULL ,
129290: NULL ,NULL ,NULL ,'Y' ,'N' ,'FREIGHT_CHARGE'
129291: ,'FREIGHT_CHARGE' ,'N' ,'Y' ,'Y' ,'N' ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL ,'BSO'
129292: ,'BSO' ,'N' ,NULL ,NULL ,NULL ,SYSDATE ,
129293: 2 ,SYSDATE ,2 ,2 ,NULL ,NULL ,NULL ,NULL);

Line 129347: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

129343: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129344: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
129345: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129346: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129347: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
129348: 'ADJUSTMENT', 'N', 2, NULL, NULL, NULL, 3, '101',
129349: 'Standard Adjustments', 2, sysdate, 2, sysdate, 2, NULL, NULL,
129350: NULL, NULL);
129351:

Line 129356: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
129357: l.language_code, 'US','Standard Adjustments',
129358: NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129359: from fnd_languages l where l.installed_flag in ('B', 'I');
129360:

Line 129373: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, 'Standard%','Standard%','Y','N',

129369: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
129370: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
129371: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129372: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
129373: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, 'Standard%','Standard%','Y','N',
129374: NULL, NULL, NULL,
129375: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
129376: NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
129377:

Line 129396: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

129392: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129393: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
129394: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129395: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129396: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
129397: 'ADJUSTMENT', 'N', 2, NULL, NULL, NULL, 3, '102',
129398: 'User Adjustments', 2, sysdate, 2, sysdate, 2, NULL, NULL,
129399: NULL, NULL);
129400:

Line 129405: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
129406: l.language_code, 'US','User Adjustments', NULL,
129407: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129408: from fnd_languages l where l.installed_flag in ('B', 'I');
129409:

Line 129422: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, 'User%','User%','Y','N',

129418: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
129419: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
129420: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129421: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
129422: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, 'User%','User%','Y','N',
129423: NULL, NULL, NULL,
129424: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
129425: NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
129426:

Line 129445: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',

129441: "TO_LEVEL_ID", "TO_VALUE", "TO_VALUE_DESC", "CREATED_BY",
129442: "CREATION_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_DATE",
129443: "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129444: "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129445: VALUES(qpr_transf_headers_s.nextval, qpr_transf_groups_s.currval, 'ADJ',
129446: 'ADJUSTMENT', 'N', 2, NULL, NULL, NULL, 3, '103',
129447: 'Contract Adjustments', 2, sysdate, 2, sysdate, 2, NULL, NULL,
129448: NULL, NULL);
129449:

Line 129454: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_headers_s.currval,

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,
129455: l.language_code, 'US','Contract Adjustments',
129456: NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129457: from fnd_languages l where l.installed_flag in ('B', 'I');
129458:

Line 129471: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, 'Contract%','Contract%','Y','N',

129467: "ATTRIBUTE5_NUMBER_FLAG", "LIMIT_DIM_CODE", "LIMIT_DIM_LEVEL",
129468: "LIMIT_DIM_LEVEL_VALUE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE",
129469: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129470: "PROGRAM_APPLICATION_ID", "REQUEST_ID") VALUES (QPR_TRANSF_RULES_S.NEXTVAL,
129471: QPR_TRANSF_HEADERS_S.CURRVAL, NULL, NULL, 'Contract%','Contract%','Y','N',
129472: NULL, NULL, NULL,
129473: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
129474: NULL, NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL);
129475: