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_DEAL_APPROVALS_PVT dependencies on QPR_PN_RESPONSE_APPROVALS

Line 96: delete from qpr_pn_response_approvals

92: procedure clear_existing_approvals(p_response_header_id in number,
93: p_user_id in number)
94: is
95: begin
96: delete from qpr_pn_response_approvals
97: where response_header_id = p_response_header_id
98: and archive_flag = 'N'
99: and approver_id <> p_user_id;
100: end clear_existing_approvals;

Line 148: from qpr_pn_response_approvals

144: rule_id,
145: notification_date,
146: response_date,
147: comments
148: from qpr_pn_response_approvals
149: where response_header_id = c_response_header_id;
150: begin
151:
152: if x_approvals_tab.count = 0

Line 184: from qpr_pn_response_approvals

180:
181: cursor get_active_records(c_resp_id number)
182: is
183: select approver_name, approval_status
184: from qpr_pn_response_approvals
185: where response_header_id = c_resp_id
186: and archive_flag = 'N';
187:
188: begin

Line 191: from qpr_pn_response_approvals

187:
188: begin
189:
190: select count(*) into l_count
191: from qpr_pn_response_approvals
192: where response_header_id = p_response_header_id
193: and archive_flag = 'N'
194: and approval_status in ('NOTIFIED', 'APPROVE');
195:

Line 238: from qpr_pn_response_approvals

234: if p_action_code = 'APPROVE' or p_action_code= 'REJECT'
235: then
236: l_status := null;
237: select approval_status into l_status
238: from qpr_pn_response_approvals
239: where response_header_id = p_response_header_id
240: and approver_id = p_user_id
241: and archive_flag = 'N'
242: and approval_status = 'NOTIFIED';

Line 438: from qpr_pn_response_approvals

434: begin
435:
436: select distinct approver_name
437: into l_user_name
438: from qpr_pn_response_approvals
439: where response_header_id = p_response_header_id
440: and approver_id = p_user_id;
441:
442: l_approver_record.name := l_user_name;

Line 676: select qpr_pn_response_approvals_s.nextval into l_approval_transaction_id from dual;

672: for i in p_approvals_tab.first .. p_approvals_tab.last
673: loop
674:
675: l_approver_record := p_approvals_tab(i);
676: select qpr_pn_response_approvals_s.nextval into l_approval_transaction_id from dual;
677: insert into qpr_pn_response_approvals (
678: "APPROVAL_TRANSACTION_ID",
679: "RESPONSE_HEADER_ID",
680: "APPROVAL_SEQUENCE",

Line 677: insert into qpr_pn_response_approvals (

673: loop
674:
675: l_approver_record := p_approvals_tab(i);
676: select qpr_pn_response_approvals_s.nextval into l_approval_transaction_id from dual;
677: insert into qpr_pn_response_approvals (
678: "APPROVAL_TRANSACTION_ID",
679: "RESPONSE_HEADER_ID",
680: "APPROVAL_SEQUENCE",
681: "APPROVER_ID",

Line 745: from qpr_pn_response_approvals

741: COMMENTS,
742: ARCHIVE_FLAG,
743: ITEM_CLASS,
744: ITEM_ID
745: from qpr_pn_response_approvals
746: where response_header_id = c_Response_header_id
747: and approver_id = c_user_id
748: and archive_flag = 'N';
749:

Line 802: from qpr_pn_response_approvals

798: COMMENTS,
799: ARCHIVE_FLAG,
800: ITEM_CLASS,
801: ITEM_ID
802: from qpr_pn_response_approvals
803: where response_header_id = c_Response_header_id
804: and archive_flag = 'N'
805: order by approval_transaction_id;
806:

Line 922: update qpr_pn_response_approvals

918:
919: for i in l_approvals_tab.first .. l_approvals_tab.last
920: loop
921:
922: update qpr_pn_response_approvals
923: set approval_status = l_approvals_tab(i).approval_status
924: where response_header_id = p_response_header_id
925: and approver_id = l_approvals_tab(i).approver_id
926: and rule_id = l_approvals_tab(i).rule_id

Line 932: update qpr_pn_response_approvals

928: and item_id = l_approvals_tab(i).item_id
929: and archive_flag = 'N';
930: end loop;
931:
932: update qpr_pn_response_approvals
933: set notification_date = sysdate
934: where response_header_id = p_response_header_id
935: and approval_status like 'NOTIFIED%'
936: and notification_date is null

Line 943: update qpr_pn_response_approvals

939: end if;
940:
941: if p_action = 'APPROVE' or p_action = 'REJECT'
942: then
943: update qpr_pn_response_approvals
944: set approval_status = p_action
945: where response_header_id = p_response_header_id
946: and approver_id = p_user_id
947: and nvl(approval_status, 'NULL') in ('NOTIFIED', 'NULL')

Line 1038: from qpr_pn_response_approvals

1034: l_increment number;
1035: cursor get_requestor_cancel(p_respone_header_id number)
1036: is
1037: select approver_name
1038: from qpr_pn_response_approvals
1039: where approval_status = 'NOTIFIED'
1040: and archive_flag = 'N'
1041: and response_header_id = p_response_header_id;
1042:

Line 1046: from qpr_pn_response_approvals

1042:
1043: cursor get_requestor(p_respone_header_id number)
1044: is
1045: select approver_name
1046: from qpr_pn_response_approvals
1047: where approval_status = 'SUBMIT'
1048: and archive_flag = 'Y'
1049: and response_header_id = p_response_header_id
1050: order by last_update_date desc;

Line 1268: from qpr_pn_response_approvals

1264:
1265: --alosh: get user id
1266: select distinct approver_id
1267: into l_user_id
1268: from qpr_pn_response_approvals
1269: where response_header_id = p_response_header_id
1270: and approver_name = p_user_name
1271: and archive_flag = 'N';
1272:

Line 1310: from qpr_pn_response_approvals

1306: COMMENTS,
1307: ARCHIVE_FLAG,
1308: ITEM_CLASS,
1309: ITEM_ID
1310: from qpr_pn_response_approvals
1311: where response_header_id = c_Response_header_id
1312: order by archive_flag,approval_transaction_id;
1313:
1314: l_approvals_complete varchar2(1);

Line 1403: from qpr_pn_response_approvals

1399: if p_action_code = 'APPROVE' or p_action_code = 'REJECT'
1400: then
1401:
1402: select distinct approver_name into l_user_name
1403: from qpr_pn_response_approvals
1404: where response_header_id = p_response_header_id
1405: and approver_id = p_user_id;
1406:
1407: qpr_wkfl_util.complete_toapp_nfn_process(

Line 1430: delete from qpr_pn_response_approvals

1426: is
1427:
1428: begin
1429:
1430: delete from qpr_pn_response_approvals
1431: where approval_transaction_id = (
1432: select max(approval_transaction_id)
1433: from qpr_pn_response_approvals
1434: where response_header_id = p_response_header_id

Line 1433: from qpr_pn_response_approvals

1429:
1430: delete from qpr_pn_response_approvals
1431: where approval_transaction_id = (
1432: select max(approval_transaction_id)
1433: from qpr_pn_response_approvals
1434: where response_header_id = p_response_header_id
1435: and approver_id = p_user_id
1436: and approval_status = p_action_code
1437: and archive_flag = 'Y');