[Home] [Help]
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",
127808: "LIMIT_VALUE_TYPE_CODE","REF_LIMIT_VALUE","EFFECTIVE_DATE_FROM",
127809: "EFFECTIVE_DATE_TO","VLB_LEVEL_VALUE_DESC","CREATION_DATE",
127810: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127811: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127812: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127813: values
127814: (qpr_policy_lines_s.nextval,qpr_policies_s.currval,'FIELD_USER',
127815: 'ONINVOICE',null,null,'PERCENT',40,to_date('01-01-00','DD-MM-RR'),null,null,
127816: sysdate,1323,sysdate,1318,4943173,null,null,null,null);
127817:
127818: l_exist_pr_seg := 0;
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",
127910: "LIMIT_VALUE_TYPE_CODE","REF_LIMIT_VALUE","EFFECTIVE_DATE_FROM",
127911: "EFFECTIVE_DATE_TO","VLB_LEVEL_VALUE_DESC","CREATION_DATE",
127912: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127913: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
127914: "PROGRAM_APPLICATION_ID","REQUEST_ID")
127915: values
127916: (qpr_policy_lines_s.nextval,qpr_policies_s.currval,'FIELD_USER',
127917: 'ONINVOICE',null,null,'PERCENT',30,to_date('05-02-08','DD-MM-RR'),null,null,
127918: sysdate,1342,sysdate,1318,4956135,null,null,null,null);
127919:
127920: l_exist_pr_seg := 0;
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",
128014: "LIMIT_VALUE_TYPE_CODE","REF_LIMIT_VALUE","EFFECTIVE_DATE_FROM",
128015: "EFFECTIVE_DATE_TO","VLB_LEVEL_VALUE_DESC","CREATION_DATE",
128016: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128017: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
128018: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128019: values
128020: (qpr_policy_lines_s.nextval,qpr_policies_s.currval,'FIELD_USER',
128021: 'COST',null,null,'PERCENT',32,to_date('06-05-08','DD-MM-RR'),null,null,
128022: sysdate,1319,sysdate,1353,4959933,null,null,null,null);
128023:
128024:
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",
128119: "LIMIT_VALUE_TYPE_CODE","REF_LIMIT_VALUE","EFFECTIVE_DATE_FROM",
128120: "EFFECTIVE_DATE_TO","VLB_LEVEL_VALUE_DESC","CREATION_DATE",
128121: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128122: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",
128123: "PROGRAM_APPLICATION_ID","REQUEST_ID")
128124: values
128125: (qpr_policy_lines_s.nextval,qpr_policies_s.currval,'FIELD_USER',
128126: 'COST',null,null,'PERCENT',25,to_date('06-05-08','DD-MM-RR'),null,null,
128127: sysdate,1318,sysdate,1318,4959698,null,null,null,null);
128128:
128129: