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_POLICIES_TL

Line 127777: from qpr_policies_tl

127773: l_exist_policy := 0;
127774: if (l_instance_type = 1000) then
127775: begin
127776: select policy_id into l_exist_policy
127777: from qpr_policies_tl
127778: where name = 'OOW - Policies'
127779: and rownum < 2;
127780: exception
127781: when others then null;

Line 127795: Insert into qpr_policies_tl

127791: values
127792: (qpr_policies_s.nextval,'Y',
127793: sysdate,1318,sysdate,1012169,4274338,null,null,null,null);
127794:
127795: Insert into qpr_policies_tl
127796: ("POLICY_ID","LANGUAGE","SOURCE_LANG",
127797: "NAME","DESCRIPTION","CREATION_DATE",
127798: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127799: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",

Line 127875: from qpr_policies_tl

127871:
127872: l_exist_policy := 0;
127873: begin
127874: select policy_id into l_exist_policy
127875: from qpr_policies_tl
127876: where name = 'Hi - Tech Controlled'
127877: and rownum < 2;
127878: exception
127879: when others then null;

Line 127895: Insert into qpr_policies_tl

127891: values
127892: (qpr_policies_s.nextval,'Y',
127893: sysdate,1012171,sysdate,1318,4952122,null,null,null,null);
127894:
127895: Insert into qpr_policies_tl
127896: ("POLICY_ID","LANGUAGE","SOURCE_LANG",
127897: "NAME","DESCRIPTION","CREATION_DATE",
127898: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
127899: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",

Line 127978: from qpr_policies_tl

127974:
127975: l_exist_policy := 0;
127976: begin
127977: select policy_id into l_exist_policy
127978: from qpr_policies_tl
127979: where name = 'Pocket Margin - Computers'
127980: and rownum < 2;
127981: exception
127982: when others then null;

Line 127999: Insert into qpr_policies_tl

127995: values
127996: (qpr_policies_s.nextval,'Y',
127997: sysdate,1318,sysdate,1318,4959698,null,null,null,null);
127998:
127999: Insert into qpr_policies_tl
128000: ("POLICY_ID","LANGUAGE","SOURCE_LANG",
128001: "NAME","DESCRIPTION","CREATION_DATE",
128002: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128003: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",

Line 128081: from qpr_policies_tl

128077:
128078: l_exist_policy := 0;
128079: begin
128080: select policy_id into l_exist_policy
128081: from qpr_policies_tl
128082: where name = 'Pocket Margin - Printers'
128083: and rownum < 2;
128084: exception
128085: when others then null;

Line 128104: Insert into qpr_policies_tl

128100: values
128101: (qpr_policies_s.nextval,'Y',
128102: sysdate,1318,sysdate,1318,4959698,null,null,null,null);
128103:
128104: Insert into qpr_policies_tl
128105: ("POLICY_ID","LANGUAGE","SOURCE_LANG",
128106: "NAME","DESCRIPTION","CREATION_DATE",
128107: "CREATED_BY","LAST_UPDATE_DATE","LAST_UPDATED_BY",
128108: "LAST_UPDATE_LOGIN","PROGRAM_ID","PROGRAM_LOGIN_ID",