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 QPR_PR_SEGMENTS_TL

Line 127821: from qpr_pr_segments_tl

127817:
127818: l_exist_pr_seg := 0;
127819: begin
127820: select pr_segment_id into l_exist_pr_seg
127821: from qpr_pr_segments_tl
127822: where name = 'Strategics - Commercial'
127823: and rownum < 2;
127824: exception
127825: when others then null;

Line 127840: Insert into qpr_pr_segments_tl

127836: values
127837: (qpr_pr_segments_s.nextval,l_instance_id,qpr_policies_s.currval,'HIGH',1,
127838: sysdate,1319,sysdate,1318,4943151,null,null,null,null);
127839:
127840: Insert into qpr_pr_segments_tl
127841: ("PR_SEGMENT_ID","LANGUAGE","SOURCE_LANG",
127842: "NAME","DESCRIPTION","CREATION_DATE",
127843: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127844: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",

Line 127923: from qpr_pr_segments_tl

127919:
127920: l_exist_pr_seg := 0;
127921: begin
127922: select pr_segment_id into l_exist_pr_seg
127923: from qpr_pr_segments_tl
127924: where name = 'Strategics - Retail'
127925: and rownum < 2;
127926: exception
127927: when others then null;

Line 127942: Insert into qpr_pr_segments_tl

127938: values
127939: (qpr_pr_segments_s.nextval,l_instance_id,qpr_policies_s.currval,'HIGH',1,
127940: sysdate,1329,sysdate,1318,4959806,null,null,null,null);
127941:
127942: Insert into qpr_pr_segments_tl
127943: ("PR_SEGMENT_ID","LANGUAGE","SOURCE_LANG",
127944: "NAME","DESCRIPTION","CREATION_DATE",
127945: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127946: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",

Line 128028: from qpr_pr_segments_tl

128024:
128025: l_exist_pr_seg := 0;
128026: begin
128027: select pr_segment_id into l_exist_pr_seg
128028: from qpr_pr_segments_tl
128029: where name = 'Computers'
128030: and rownum < 2;
128031: exception
128032: when others then null;

Line 128048: Insert into qpr_pr_segments_tl

128044: values
128045: (qpr_pr_segments_s.nextval,l_instance_id,qpr_policies_s.currval,'HIGH',1,
128046: sysdate,1321,sysdate,1318,4959719,null,null,null,null);
128047:
128048: Insert into qpr_pr_segments_tl
128049: ("PR_SEGMENT_ID","LANGUAGE","SOURCE_LANG",
128050: "NAME","DESCRIPTION","CREATION_DATE",
128051: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128052: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",

Line 128133: from qpr_pr_segments_tl

128129:
128130: l_exist_pr_seg := 0;
128131: begin
128132: select pr_segment_id into l_exist_pr_seg
128133: from qpr_pr_segments_tl
128134: where name = 'Printers'
128135: and rownum < 2;
128136: exception
128137: when others then null;

Line 128152: Insert into qpr_pr_segments_tl

128148: values
128149: (qpr_pr_segments_s.nextval,l_instance_id,qpr_policies_s.currval,'HIGH',1,
128150: sysdate,1321,sysdate,1318,4959719,null,null,null,null);
128151:
128152: Insert into qpr_pr_segments_tl
128153: ("PR_SEGMENT_ID","LANGUAGE","SOURCE_LANG",
128154: "NAME","DESCRIPTION","CREATION_DATE",
128155: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128156: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",