APPS.QPR_CREATE_DEMO_DATA dependencies on QPR_SCOPES

Line 127855: Insert into qpr_scopes

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);
127854:
127855: Insert into qpr_scopes
127856: ("SCOPE_ID","PARENT_ENTITY_TYPE","PARENT_ID",
127857: "DIM_CODE","HIERARCHY_ID","LEVEL_ID",
127858: "OPERATOR","SCOPE_VALUE","SCOPE_VALUE_DESC",
127859: "CREATED_BY","CREATION_DATE","LAST_UPDATED_BY",

Line 127863: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,

127859: "CREATED_BY","CREATION_DATE","LAST_UPDATED_BY",
127860: "LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","PROGRAM_ID",
127861: "PROGRAM_LOGIN_ID","PROGRAM_APPLICATION_ID","REQUEST_ID")
127862: values
127863: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,
127864: 'CUS',7,22,'=','103','Strategics - Commercial',1318,
127865: sysdate,1318,sysdate,4941553,null,null,null,null);
127866:
127867: end if;

Line 127957: Insert into qpr_scopes

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:
127957: Insert into qpr_scopes
127958: ("SCOPE_ID","PARENT_ENTITY_TYPE","PARENT_ID",
127959: "DIM_CODE","HIERARCHY_ID","LEVEL_ID",
127960: "OPERATOR","SCOPE_VALUE","SCOPE_VALUE_DESC",
127961: "CREATED_BY","CREATION_DATE","LAST_UPDATED_BY",

Line 127965: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,

127961: "CREATED_BY","CREATION_DATE","LAST_UPDATED_BY",
127962: "LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","PROGRAM_ID",
127963: "PROGRAM_LOGIN_ID","PROGRAM_APPLICATION_ID","REQUEST_ID")
127964: values
127965: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,
127966: 'CUS',7,22,'=','101','Strategics - Retail',1318,
127967: sysdate,1318,sysdate,4941553,null,null,null,null);
127968:
127969: end if;

Line 128062: Insert into qpr_scopes

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:
128062: Insert into qpr_scopes
128063: ("SCOPE_ID","PARENT_ENTITY_TYPE","PARENT_ID",
128064: "DIM_CODE","HIERARCHY_ID","LEVEL_ID",
128065: "OPERATOR","SCOPE_VALUE","SCOPE_VALUE_DESC",
128066: "CREATED_BY","CREATION_DATE","LAST_UPDATED_BY",

Line 128070: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,

128066: "CREATED_BY","CREATION_DATE","LAST_UPDATED_BY",
128067: "LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","PROGRAM_ID",
128068: "PROGRAM_LOGIN_ID","PROGRAM_APPLICATION_ID","REQUEST_ID")
128069: values
128070: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,
128071: 'PRD',4,9,'=','101','Computers',1318,
128072: sysdate,1318,sysdate,4959698,null,null,null,null);
128073:
128074: end if;

Line 128166: Insert into qpr_scopes

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:
128166: Insert into qpr_scopes
128167: ("SCOPE_ID","PARENT_ENTITY_TYPE","PARENT_ID",
128168: "DIM_CODE","HIERARCHY_ID","LEVEL_ID",
128169: "OPERATOR","SCOPE_VALUE","SCOPE_VALUE_DESC",
128170: "CREATED_BY","CREATION_DATE","LAST_UPDATED_BY",

Line 128174: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,

128170: "CREATED_BY","CREATION_DATE","LAST_UPDATED_BY",
128171: "LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","PROGRAM_ID",
128172: "PROGRAM_LOGIN_ID","PROGRAM_APPLICATION_ID","REQUEST_ID")
128173: values
128174: (qpr_scopes_s.nextval,'PRICINGSEGMENT',qpr_pr_segments_s.currval,
128175: 'PRD',4,9,'=','102','Printers',1318,
128176: sysdate,1318,sysdate,4959698,null,null,null,null);
128177:
128178: end if; -- Pr Seg Check