DBA Data[Home] [Help]

APPS.QPR_CREATE_DEMO_DATA dependencies on QPR_TRANSF_GROUPS_S

Line 128211: values (qpr_transf_groups_s.nextval,'MEASDIM',

128207: Insert into qpr_transf_groups_b ("TRANSF_GROUP_ID","TRANSF_TYPE_CODE",
128208: "CREATION_DATE","CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128209: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
128210: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128211: values (qpr_transf_groups_s.nextval,'MEASDIM',
128212: sysdate,2,sysdate,2,2,null,null,null,null);
128213:
128214: INSERT
128215: INTO qpr_transf_groups_tl("TRANSF_GROUP_ID", "LANGUAGE", "SOURCE_LANG",

Line 128219: select qpr_transf_groups_s.currval, l.language_code , 'US',

128215: INTO qpr_transf_groups_tl("TRANSF_GROUP_ID", "LANGUAGE", "SOURCE_LANG",
128216: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY",
128217: "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID",
128218: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128219: select qpr_transf_groups_s.currval, l.language_code , 'US',
128220: 'Demo Volume Band Transformation', 'Demo Volume Band Transformation',
128221: sysdate, 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
128222: from fnd_languages l where l.installed_flag in ('B', 'I');
128223:

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 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 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 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 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 128493: values (qpr_transf_groups_s.nextval,'DIMDIM',sysdate,2,

128489: Insert into qpr_transf_groups_b ("TRANSF_GROUP_ID","TRANSF_TYPE_CODE",
128490: "CREATION_DATE","CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128491: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
128492: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128493: values (qpr_transf_groups_s.nextval,'DIMDIM',sysdate,2,
128494: sysdate,2,2,null,null,null,null);
128495:
128496: INSERT
128497: INTO qpr_transf_groups_tl("TRANSF_GROUP_ID", "LANGUAGE", "SOURCE_LANG",

Line 128501: select qpr_transf_groups_s.currval, l.language_code, 'US',

128497: INTO qpr_transf_groups_tl("TRANSF_GROUP_ID", "LANGUAGE", "SOURCE_LANG",
128498: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY",
128499: "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID",
128500: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128501: select qpr_transf_groups_s.currval, l.language_code, 'US',
128502: 'Demo-Waterfall-Level2-P1', 'Rules for creating level 2 member. Sequence 1',
128503: sysdate, 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
128504: from fnd_languages l where l.installed_flag in ('B', 'I');
128505:

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 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 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 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 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 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 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 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 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 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 129001: values (qpr_transf_groups_s.nextval,'DIMDIM',

128997: Insert into qpr_transf_groups_b ("TRANSF_GROUP_ID","TRANSF_TYPE_CODE",
128998: "CREATION_DATE","CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128999: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
129000: "PROGRAM_APPLICATION_ID","REQUEST_ID")
129001: values (qpr_transf_groups_s.nextval,'DIMDIM',
129002: sysdate,2,sysdate,2,2,null,null,null,null);
129003:
129004: INSERT
129005: INTO qpr_transf_groups_tl("TRANSF_GROUP_ID", "LANGUAGE", "SOURCE_LANG",

Line 129009: select qpr_transf_groups_s.currval, l.language_code, 'US',

129005: INTO qpr_transf_groups_tl("TRANSF_GROUP_ID", "LANGUAGE", "SOURCE_LANG",
129006: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY",
129007: "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID",
129008: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129009: select qpr_transf_groups_s.currval, l.language_code, 'US',
129010: 'Demo-Waterfall-Level2-P2', 'Rules for creating level 2 member. Sequence 2',
129011: sysdate, 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
129012: from fnd_languages l where l.installed_flag in ('B', 'I');
129013:

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 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 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 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 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 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 129325: values (qpr_transf_groups_s.nextval,'DIMDIM',

129321: Insert into qpr_transf_groups_b ("TRANSF_GROUP_ID","TRANSF_TYPE_CODE",
129322: "CREATION_DATE","CREATED_BY","LAST_UPDATE_DATE",
129323: "LAST_UPDATED_BY","LAST_UPDATE_LOGIN","PROGRAM_ID",
129324: "PROGRAM_LOGIN_ID","PROGRAM_APPLICATION_ID","REQUEST_ID")
129325: values (qpr_transf_groups_s.nextval,'DIMDIM',
129326: sysdate,2,sysdate,2,2,null,null,null,null);
129327:
129328: INSERT
129329: INTO qpr_transf_groups_tl("TRANSF_GROUP_ID", "LANGUAGE", "SOURCE_LANG",

Line 129333: select qpr_transf_groups_s.currval, l.language_code, 'US',

129329: INTO qpr_transf_groups_tl("TRANSF_GROUP_ID", "LANGUAGE", "SOURCE_LANG",
129330: "NAME", "DESCRIPTION", "CREATION_DATE", "CREATED_BY",
129331: "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID",
129332: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129333: select qpr_transf_groups_s.currval, l.language_code, 'US',
129334: 'Demo-Waterfall-Level3', 'Rules for creating level 3 member',
129335: sysdate, 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
129336: from fnd_languages l where l.installed_flag in ('B', 'I');
129337: /* inserting headers */

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 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 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: