eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QPR_CREATE_DEMO_DATA dependencies on FND_LANGUAGES

Line 127803: from fnd_languages l where l.installed_flag in ('B','I');

127799: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127800: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127801: select qpr_policies_s.currval,l.language_code,'US','OOW - Policies',null,
127802: sysdate,1318,sysdate,1012169,4274338,null,null,null,null
127803: from fnd_languages l where l.installed_flag in ('B','I');
127804:
127805: Insert into qpr_policy_lines
127806: ("POLICY_LINE_ID","POLICY_ID","POLICY_TYPE_CODE",
127807: "POLICY_MEASURE_TYPE_CODE","INSTANCE_ID","VLB_LEVEL_VALUE",

Line 127849: from fnd_languages l where l.installed_flag in ('B','I');

127845: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127846: select qpr_pr_segments_s.currval,l.language_code,'US',
127847: 'Strategics - Commercial','Strategics - Commercial',
127848: sysdate,1318,sysdate,1318,4941072,1,1,1,1
127849: from fnd_languages l where l.installed_flag in ('B','I');
127850:
127851: select qpr_pr_segments_s.currval into psg_level1_value from dual;
127852:
127853: insert_psg_dim_value(psg_level1_value, 'Strategics - Commercial', l_instance_id);

Line 127905: from fnd_languages l where l.installed_flag in ('B','I');

127901: select
127902: qpr_policies_s.currval,l.language_code,'US','Hi - Tech Controlled',
127903: 'Pricing Policy for Strategics Retail Customers',
127904: sysdate,1012171,sysdate,1318,4952122,null,null,null,null
127905: from fnd_languages l where l.installed_flag in ('B','I');
127906:
127907: Insert into qpr_policy_lines
127908: ("POLICY_LINE_ID","POLICY_ID","POLICY_TYPE_CODE",
127909: "POLICY_MEASURE_TYPE_CODE","INSTANCE_ID","VLB_LEVEL_VALUE",

Line 127952: from fnd_languages l where l.installed_flag in ('B','I');

127948: select
127949: qpr_pr_segments_s.currval,l.language_code,'US','Strategics - Retail',
127950: 'Strategics - Retail',
127951: sysdate,1318,sysdate,1318,4941036,1,1,1,1
127952: from fnd_languages l where l.installed_flag in ('B','I');
127953:
127954: select qpr_pr_segments_s.currval into psg_level1_value from dual;
127955: insert_psg_dim_value(psg_level1_value, 'Strategics - Retail', l_instance_id);
127956:

Line 128009: from fnd_languages l where l.installed_flag in ('B','I');

128005: select
128006: qpr_policies_s.currval,l.language_code,'US','Pocket Margin - Computers',
128007: 'Pocket Margin - Computers',
128008: sysdate,1318,sysdate,1318,4959698,null,null,null,null
128009: from fnd_languages l where l.installed_flag in ('B','I');
128010:
128011: Insert into qpr_policy_lines
128012: ("POLICY_LINE_ID","POLICY_ID","POLICY_TYPE_CODE",
128013: "POLICY_MEASURE_TYPE_CODE","INSTANCE_ID","VLB_LEVEL_VALUE",

Line 128057: from fnd_languages l where l.installed_flag in ('B','I');

128053: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128054: select
128055: qpr_pr_segments_s.currval,l.language_code,'US','Computers',null,
128056: sysdate,1318,sysdate,1318,4959698,1,1,1,1
128057: from fnd_languages l where l.installed_flag in ('B','I');
128058:
128059: select qpr_pr_segments_s.currval into psg_level1_value from dual;
128060: insert_psg_dim_value(psg_level1_value, 'Computers', l_instance_id);
128061:

Line 128114: from fnd_languages l where l.installed_flag in ('B','I');

128110: select
128111: qpr_policies_s.currval,l.language_code,'US','Pocket Margin - Printers',
128112: 'Pocket Margin - Printers',
128113: sysdate,1318,sysdate,1318,4959698,null,null,null,null
128114: from fnd_languages l where l.installed_flag in ('B','I');
128115:
128116: Insert into qpr_policy_lines
128117: ("POLICY_LINE_ID","POLICY_ID","POLICY_TYPE_CODE",
128118: "POLICY_MEASURE_TYPE_CODE","INSTANCE_ID","VLB_LEVEL_VALUE",

Line 128161: from fnd_languages l where l.installed_flag in ('B','I');

128157: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128158: select
128159: qpr_pr_segments_s.currval,l.language_code,'US','Printers',null,
128160: sysdate,1318,sysdate,1318,4959698,1,1,1,1
128161: from fnd_languages l where l.installed_flag in ('B','I');
128162:
128163: select qpr_pr_segments_s.currval into psg_level1_value from dual;
128164: insert_psg_dim_value(psg_level1_value, 'Printers', l_instance_id);
128165:

Line 128222: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
128224: --- inserting headers ----
128225: --- LOW VOLUME - 101 -----
128226: INSERT

Line 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');

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 ----
128248: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",

Line 128270: from fnd_languages l where l.installed_flag in ('B', 'I');

128266: "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID",
128267: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128268: select qpr_transf_rules_s.currval, l.language_code, 'US', 'Low Volume', NULL,
128269: sysdate, 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
128270: from fnd_languages l where l.installed_flag in ('B', 'I');
128271:
128272: ---- LOW_MEDIUM 102 ----
128273:
128274: INSERT

Line 128295: from fnd_languages l where l.language_code in ('B', 'I');

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:
128297: -- inserting rules ---
128298: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",
128299: "LEVEL_VALUE_FROM", "LEVEL_VALUE_TO", "LEVEL_DESC_FROM", "LEVEL_DESC_TO",

Line 128321: from fnd_languages l where l.installed_flag in ('B', 'I');

128317: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128318: select qpr_transf_rules_s.currval, l.language_code, 'US',
128319: 'Low-Medium', NULL,
128320: sysdate, 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
128321: from fnd_languages l where l.installed_flag in ('B', 'I');
128322:
128323: --- MEDIUM - 103 ---
128324:
128325: INSERT

Line 128345: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
128347: --inserting rules ---
128348: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",
128349: "LEVEL_VALUE_FROM", "LEVEL_VALUE_TO", "LEVEL_DESC_FROM", "LEVEL_DESC_TO",

Line 128371: from fnd_languages l where l.installed_flag in ('B', 'I');

128367: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128368: select qpr_transf_rules_s.currval, l.language_code, 'US',
128369: 'Medium', NULL,
128370: sysdate, 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
128371: from fnd_languages l where l.installed_flag in ('B', 'I');
128372:
128373: -- MED_HIG - 104 ---
128374:
128375: INSERT

Line 128396: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
128398: ---inserting rules ---
128399: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",
128400: "LEVEL_VALUE_FROM", "LEVEL_VALUE_TO", "LEVEL_DESC_FROM", "LEVEL_DESC_TO",

Line 128422: from fnd_languages l where l.installed_flag in ('B', 'I');

128418: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128419: select qpr_transf_rules_s.currval, l.language_code, 'US',
128420: 'Medium HIgh', NULL,
128421: sysdate, 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
128422: from fnd_languages l where l.installed_flag in ('B', 'I');
128423:
128424: --- HIGH 105 ---
128425: INSERT
128426: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 128445: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
128447: -- inserting rules ---
128448:
128449:

Line 128473: from fnd_languages l where l.installed_flag in ('B', 'I');

128469: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
128470: select qpr_transf_rules_s.currval, l.language_code, 'US',
128471: 'High', NULL, sysdate,
128472: 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
128473: from fnd_languages l where l.installed_flag in ('B', 'I');
128474:
128475: end if;
128476:
128477: l_exist_transf := 0;

Line 128504: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
128506: /***** inserting headers *******/
128507: /******** Standard price *******/
128508: INSERT

Line 128526: from fnd_languages l where l.installed_flag in ('B', 'I');

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 ---
128529: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",
128530: "LEVEL_VALUE_FROM", "LEVEL_VALUE_TO", "LEVEL_DESC_FROM", "LEVEL_DESC_TO",

Line 128550: from fnd_languages l where l.installed_flag in ('B', 'I');

128546: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128547: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
128548: l.language_code, 'US','Standard Price', NULL,
128549: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128550: from fnd_languages l where l.installed_flag in ('B', 'I');
128551:
128552: /******* Standard Volume ***********/
128553: INSERT
128554: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 128572: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
128574: --- inserting rules ---
128575:
128576: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",

Line 128597: from fnd_languages l where l.installed_flag in ('B', 'I');

128593: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128594: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
128595: l.language_code, 'US','Standard Volume', NULL,
128596: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128597: from fnd_languages l where l.installed_flag in ('B', 'I');
128598:
128599: /*******Standard Promo ************/
128600: INSERT
128601: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 128620: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
128622: ---- inserting rules ----
128623: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",
128624: "LEVEL_VALUE_FROM", "LEVEL_VALUE_TO", "LEVEL_DESC_FROM", "LEVEL_DESC_TO",

Line 128644: from fnd_languages l where l.installed_flag in ('B', 'I');

128640: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128641: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
128642: l.language_code, 'US','Standard Promo', NULL,
128643: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128644: from fnd_languages l where l.installed_flag in ('B', 'I');
128645:
128646: /**standard Order Value **********/
128647: INSERT
128648: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 128667: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
128669: --- inserting rules -----
128670: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",
128671: "LEVEL_VALUE_FROM", "LEVEL_VALUE_TO", "LEVEL_DESC_FROM", "LEVEL_DESC_TO",

Line 128691: from fnd_languages l where l.installed_flag in ('B', 'I');

128687: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128688: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
128689: l.language_code, 'US','Standard Order Value', NULL,
128690: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128691: from fnd_languages l where l.installed_flag in ('B', 'I');
128692:
128693: /****STandard Lumpsum **************/
128694:
128695: INSERT

Line 128715: from fnd_languages l where l.installed_flag in ('B', 'I');

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 ----
128717: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",
128718: "LEVEL_VALUE_FROM", "LEVEL_VALUE_TO", "LEVEL_DESC_FROM", "LEVEL_DESC_TO",
128719: "LEVEL_VALUE_LIKE_FLAG", "LEVEL_VALUE_NUMBER_FLAG", "ATTRIBUTE1_FROM",

Line 128738: from fnd_languages l where l.installed_flag in ('B', 'I');

128734: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128735: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
128736: l.language_code, 'US','Standard Lumpsum', NULL,
128737: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128738: from fnd_languages l where l.installed_flag in ('B', 'I');
128739:
128740: /******STANdard F and S ***************/
128741: INSERT
128742: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 128762: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
128764: ----- isnerting rules ----
128765: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",
128766: "LEVEL_VALUE_FROM", "LEVEL_VALUE_TO", "LEVEL_DESC_FROM", "LEVEL_DESC_TO",

Line 128788: from fnd_languages l where l.installed_flag in ('B', 'I');

128784: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128785: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
128786: l.language_code, 'US','Standard F'||'&'||'S', NULL,
128787: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128788: from fnd_languages l where l.installed_flag in ('B', 'I');
128789:
128790: /*******USER Price ********************/
128791: INSERT
128792: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 128811: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
128813: ---- inserting rules ----
128814:
128815: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",

Line 128836: from fnd_languages l where l.installed_flag in ('B', 'I');

128832: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128833: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
128834: l.language_code, 'US','User Price', NULL, SYSDATE, 2,
128835: SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128836: from fnd_languages l where l.installed_flag in ('B', 'I');
128837: /*******User Volume ***********/
128838: INSERT
128839: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
128840: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",

Line 128858: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
128860: --- inserting rules ---
128861:
128862: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",

Line 128883: from fnd_languages l where l.installed_flag in ('B', 'I');

128879: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128880: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
128881: l.language_code, 'US','User Volume', NULL,
128882: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128883: from fnd_languages l where l.installed_flag in ('B', 'I');
128884:
128885: /*****User Promo ***********/
128886: INSERT
128887: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 128906: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
128908: ------ inserting rules ---
128909:
128910: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",

Line 128931: from fnd_languages l where l.installed_flag in ('B', 'I');

128927: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128928: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
128929: l.language_code, 'US','User Promo', NULL, SYSDATE, 2,
128930: SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128931: from fnd_languages l where l.installed_flag in ('B', 'I');
128932:
128933: /***User Lumpsum **********/
128934: INSERT
128935: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 128954: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
128956: ---- inserting rules ---
128957: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",
128958: "LEVEL_VALUE_FROM", "LEVEL_VALUE_TO", "LEVEL_DESC_FROM", "LEVEL_DESC_TO",

Line 128978: from fnd_languages l where l.installed_flag in ('B', 'I');

128974: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
128975: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
128976: l.language_code, 'US','User Lumpsum', NULL, SYSDATE, 2,
128977: SYSDATE, 2, 2, NULL, NULL, NULL, NULL
128978: from fnd_languages l where l.installed_flag in ('B', 'I');
128979:
128980: end if;
128981: /****************************************************************************/
128982:

Line 129012: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
129014: /****************** inserting headers ****************/
129015: /* Contract PRICE ************/
129016: INSERT

Line 129036: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
129038: --inserting rules -----
129039: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID" ,"TRANSF_HEADER_ID"
129040: ,"LEVEL_VALUE_FROM" ,"LEVEL_VALUE_TO" ,"LEVEL_DESC_FROM" ,"LEVEL_DESC_TO"

Line 129060: from fnd_languages l where l.installed_flag in ('B', 'I');

129056: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129057: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
129058: l.language_code, 'US','Contract Price', NULL,
129059: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129060: from fnd_languages l where l.installed_flag in ('B', 'I');
129061:
129062: /******** COntract Volume ************/
129063: INSERT
129064: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 129083: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
129085: --- inserting rules -------
129086:
129087: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID" ,"TRANSF_HEADER_ID"

Line 129108: from fnd_languages l where l.installed_flag in ('B', 'I');

129104: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129105: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
129106: l.language_code, 'US','Contract Volume', NULL,
129107: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129108: from fnd_languages l where l.installed_flag in ('B', 'I');
129109:
129110: /*Contract Promo *************************/
129111: INSERT
129112: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 129131: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
129133: ---- inserting rules --
129134:
129135: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID" ,"TRANSF_HEADER_ID"

Line 129157: from fnd_languages l where l.installed_flag in ('B', 'I');

129153: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129154: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
129155: l.language_code, 'US','Contract Promo', NULL,
129156: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129157: from fnd_languages l where l.installed_flag in ('B', 'I');
129158:
129159: /* Contract Order Value *****************/
129160: INSERT
129161: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 129180: from fnd_languages l where l.installed_flag in ('B', 'I');

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 ----
129182: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID" ,"TRANSF_HEADER_ID"
129183: ,"LEVEL_VALUE_FROM" ,"LEVEL_VALUE_TO" ,"LEVEL_DESC_FROM" ,"LEVEL_DESC_TO"
129184: ,"LEVEL_VALUE_LIKE_FLAG" ,"LEVEL_VALUE_NUMBER_FLAG" ,"ATTRIBUTE1_FROM"

Line 129203: from fnd_languages l where l.installed_flag in ('B', 'I');

129199: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129200: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
129201: l.language_code, 'US','Contract Order Value', NULL,
129202: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129203: from fnd_languages l where l.installed_flag in ('B', 'I');
129204: /***** Contract Lumpsum **********/
129205: INSERT
129206: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",
129207: "FROM_DIM_MEAS_CODE", "FROM_DIM_HIER_CODE", "LIMIT_DIM_FLAG",

Line 129225: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
129227: -- inserting rules ---
129228:
129229: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID" ,"TRANSF_HEADER_ID"

Line 129250: from fnd_languages l where l.installed_flag in ('B', 'I');

129246: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129247: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
129248: l.language_code, 'US','Contract Lumpsum',
129249: NULL, SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129250: from fnd_languages l where l.installed_flag in ('B', 'I');
129251:
129252: /* Contract FS ******************/
129253: INSERT
129254: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 129274: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
129276: --- inserting rules ----
129277:
129278: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID" ,"TRANSF_HEADER_ID"

Line 129302: from fnd_languages l where l.installed_flag in ('B', 'I');

129298: "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID", "PROGRAM_LOGIN_ID",
129299: "PROGRAM_APPLICATION_ID", "REQUEST_ID") select qpr_transf_rules_s.currval,
129300: l.language_code, 'US','Contract F'||'&'||'S', NULL,
129301: SYSDATE, 2, SYSDATE, 2, 2, NULL, NULL, NULL, NULL
129302: from fnd_languages l where l.installed_flag in ('B', 'I');
129303:
129304:
129305: end if;
129306: /****************************************************************************/

Line 129336: from fnd_languages l where l.installed_flag in ('B', 'I');

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 */
129338: /*************** STANDARD ADJ *************************/
129339: INSERT
129340: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 129359: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
129361: --- inserting rules ----
129362: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",
129363: "LEVEL_VALUE_FROM", "LEVEL_VALUE_TO", "LEVEL_DESC_FROM", "LEVEL_DESC_TO",

Line 129385: from fnd_languages l where l.installed_flag in ('B', 'I');

129381: "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID",
129382: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129383: select qpr_transf_rules_s.currval, l.language_code, 'US', 'Standard', NULL,
129384: sysdate, 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
129385: from fnd_languages l where l.installed_flag in ('B', 'I');
129386:
129387: /**************** USER ADJ ******************/
129388: INSERT
129389: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 129408: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
129410: --- inserting rules ----
129411: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",
129412: "LEVEL_VALUE_FROM", "LEVEL_VALUE_TO", "LEVEL_DESC_FROM", "LEVEL_DESC_TO",

Line 129434: from fnd_languages l where l.installed_flag in ('B', 'I');

129430: "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID",
129431: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129432: select qpr_transf_rules_s.currval, l.language_code, 'US', 'User', NULL,
129433: sysdate, 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
129434: from fnd_languages l where l.installed_flag in ('B', 'I');
129435:
129436: /********* CONTRACTS ADJ ******************/
129437: INSERT
129438: INTO qpr_transf_headers_b("TRANSF_HEADER_ID", "TRANSF_GROUP_ID",

Line 129457: from fnd_languages l where l.installed_flag in ('B', 'I');

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:
129459: --- inserting rules ----
129460: INSERT INTO QPR_TRANSF_RULES_B ("TRANSF_RULE_ID", "TRANSF_HEADER_ID",
129461: "LEVEL_VALUE_FROM", "LEVEL_VALUE_TO", "LEVEL_DESC_FROM", "LEVEL_DESC_TO",

Line 129483: from fnd_languages l where l.installed_flag in ('B', 'I');

129479: "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "PROGRAM_ID",
129480: "PROGRAM_LOGIN_ID", "PROGRAM_APPLICATION_ID", "REQUEST_ID")
129481: select qpr_transf_rules_s.currval, l.language_code, 'US', 'Contract', NULL,
129482: sysdate, 2, sysdate, 2, 2, NULL, NULL, NULL, NULL
129483: from fnd_languages l where l.installed_flag in ('B', 'I');
129484:
129485: /********************************************************************/
129486:
129487: end if;