APPS.PO_RCO_VALIDATION_PVT dependencies on DUAL

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

3785:
3786: --If ALL changes are valid, we will insert change records, and insert cancel records(if any)
3787: IF(l_change_result = fnd_api.g_ret_sts_success) THEN
3788: x_retmsg := 'SRCH004';
3789: SELECT po_chg_request_seq.nextval INTO p_change_request_group_id FROM dual;
3790:
3791: insert_reqchange(l_req_change_table, p_change_request_group_id);
3792: x_retmsg := 'SRCH005';
3793:

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

3864: l_req_user_id := fnd_global.user_id;
3865:
3866:
3867: IF(p_grp_id IS NULL) THEN
3868: SELECT po_chg_request_seq.nextval INTO p_change_request_group_id FROM dual;
3869: DELETE FROM po_change_requests
3870: WHERE document_header_id = p_req_hdr_id
3871: AND initiator = 'REQUESTER'
3872: AND request_status = 'SYSTEMSAVE';

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

3876: x_retmsg := '001';
3877: FOR i IN 1..p_cancel_table.req_line_id.count
3878: LOOP
3879:
3880: SELECT po_chg_request_seq.nextval INTO l_chn_req_id FROM dual;
3881: SELECT
3882: prha.segment1,
3883: prla.line_num,
3884: prla.line_location_id,

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

5231: po_debug.debug_var(l_log_head, l_progress, 'p_grp_id=', p_grp_id);
5232: END IF;
5233:
5234: IF(p_grp_id IS NULL) THEN
5235: SELECT po_chg_request_seq.nextval INTO p_change_request_group_id FROM dual;
5236: DELETE FROM po_change_requests
5237: WHERE document_header_id = p_req_hdr_id
5238: AND initiator = 'REQUESTER'
5239: AND request_status = 'SYSTEMSAVE';

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

5257:
5258: FOR i IN 1..p_cancel_table.req_line_id.count
5259: LOOP
5260:
5261: SELECT po_chg_request_seq.nextval INTO l_chn_req_id FROM dual;
5262: SELECT
5263: prha.segment1,
5264: prla.line_num,
5265: prha.preparer_id,

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

5601:
5602: --If ALL changes are valid, we will insert change records, and insert cancel records(if any)
5603: --if(l_change_result = FND_API.G_RET_STS_SUCCESS) then
5604: x_retmsg := 'SRCH004';
5605: SELECT po_chg_request_seq.nextval INTO p_change_request_group_id FROM dual;
5606:
5607:
5608:
5609: IF g_debug_stmt THEN