APPS.PO_RCO_VALIDATION_PVT dependencies on DUAL

Line 3870: SELECT po_chg_request_seq.nextval INTO p_change_request_group_id FROM dual;

3866:
3867: --If ALL changes are valid, we will insert change records, and insert cancel records(if any)
3868: IF(l_change_result = fnd_api.g_ret_sts_success) THEN
3869: x_retmsg := 'SRCH004';
3870: SELECT po_chg_request_seq.nextval INTO p_change_request_group_id FROM dual;
3871:
3872: insert_reqchange(l_req_change_table, p_change_request_group_id);
3873: x_retmsg := 'SRCH005';
3874:

Line 3949: SELECT po_chg_request_seq.nextval INTO p_change_request_group_id FROM dual;

3945: l_req_user_id := fnd_global.user_id;
3946:
3947:
3948: IF(p_grp_id IS NULL) THEN
3949: SELECT po_chg_request_seq.nextval INTO p_change_request_group_id FROM dual;
3950: DELETE FROM po_change_requests
3951: WHERE document_header_id = p_req_hdr_id
3952: AND initiator = 'REQUESTER'
3953: AND request_status = 'SYSTEMSAVE';

Line 3961: SELECT po_chg_request_seq.nextval INTO l_chn_req_id FROM dual;

3957: x_retmsg := '001';
3958: FOR i IN 1..p_cancel_table.req_line_id.count
3959: LOOP
3960:
3961: SELECT po_chg_request_seq.nextval INTO l_chn_req_id FROM dual;
3962: SELECT
3963: prha.segment1,
3964: prla.line_num,
3965: prla.line_location_id,

Line 5393: SELECT po_chg_request_seq.nextval INTO p_change_request_group_id FROM dual;

5389: po_debug.debug_var(l_log_head, l_progress, 'p_grp_id=', p_grp_id);
5390: END IF;
5391:
5392: IF(p_grp_id IS NULL) THEN
5393: SELECT po_chg_request_seq.nextval INTO p_change_request_group_id FROM dual;
5394: DELETE FROM po_change_requests
5395: WHERE document_header_id = p_req_hdr_id
5396: AND initiator = 'REQUESTER'
5397: AND request_status = 'SYSTEMSAVE';

Line 5419: SELECT po_chg_request_seq.nextval INTO l_chn_req_id FROM dual;

5415:
5416: FOR i IN 1..p_cancel_table.req_line_id.count
5417: LOOP
5418:
5419: SELECT po_chg_request_seq.nextval INTO l_chn_req_id FROM dual;
5420: SELECT
5421: prha.segment1,
5422: prla.line_num,
5423: prha.preparer_id,

Line 5763: SELECT po_chg_request_seq.nextval INTO p_change_request_group_id FROM dual;

5759:
5760: --If ALL changes are valid, we will insert change records, and insert cancel records(if any)
5761: --if(l_change_result = FND_API.G_RET_STS_SUCCESS) then
5762: x_retmsg := 'SRCH004';
5763: SELECT po_chg_request_seq.nextval INTO p_change_request_group_id FROM dual;
5764:
5765:
5766:
5767: IF g_debug_stmt THEN