APPS.PO_AUTOCREATE_DOC dependencies on PO_WF_CANDIDATE_REQ_LINES_TEMP

Line 2743: INSERT INTO po_wf_candidate_req_lines_temp

2739: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2740: END IF;
2741:
2742: begin
2743: INSERT INTO po_wf_candidate_req_lines_temp
2744: (group_id,
2745: requisition_header_id,
2746: requisition_line_id,
2747: suggested_buyer_id,

Line 2785: 'into po_wf_candidate_req_lines_temp';

2781: l_job_id); --
2782: exception
2783: when others then
2784: x_progress := '15: insert_cand_req_lines_into_tbl: IN EXCEPTION when inserting' ||
2785: 'into po_wf_candidate_req_lines_temp';
2786: IF (g_po_wf_debug = 'Y') THEN
2787: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2788: END IF;
2789: raise;

Line 2958: from po_wf_candidate_req_lines_temp prlt,

2954: --
2955: ,prl.line_type_id,
2956: prl.purchase_basis
2957: --
2958: from po_wf_candidate_req_lines_temp prlt,
2959: po_requisition_lines prl,
2960: hr_locations_all hrl
2961: where prlt.process_code = 'PENDING'
2962: and prlt.group_id = x_group_id

Line 3003: from po_wf_candidate_req_lines_temp prlt,

2999: ,prl.line_type_id,
3000: prl.purchase_basis
3001: --
3002:
3003: from po_wf_candidate_req_lines_temp prlt,
3004: po_requisition_lines prl,
3005: hr_locations_all hrl
3006: where prlt.process_code = 'PENDING'
3007: and prlt.group_id = x_group_id

Line 3445: update po_wf_candidate_req_lines_temp

3441: /* Update the process code of the current line in the temp table so
3442: * it doesn't get picked up again by the cursor for processing.
3443: */
3444:
3445: update po_wf_candidate_req_lines_temp
3446: set process_code = 'PROCESSED'
3447: where rowid=c2_rowid;
3448: -- Bug# 1721991, where current of c2;
3449:

Line 5506: delete from po_wf_candidate_req_lines_temp

5502:
5503:
5504: /* Delete all rows belonging to this group_id */
5505:
5506: delete from po_wf_candidate_req_lines_temp
5507: where group_id = x_group_id;
5508:
5509: /* Calling process should do the commit, so comment out here.
5510: * COMMIT;

Line 5686: from po_wf_candidate_req_lines_temp prlt,

5682: prl.suggested_vendor_contact,
5683: prl.vendor_contact_id,
5684: prl.destination_organization_id,
5685: prl.destination_type_code
5686: from po_wf_candidate_req_lines_temp prlt,
5687: po_requisition_lines prl
5688: where prlt.process_code = 'PENDING'
5689: and prlt.group_id = x_group_id
5690: and prlt.requisition_header_id = prl.requisition_header_id

Line 5748: update po_wf_candidate_req_lines_temp

5744: c_dest_org_id,
5745: c_dest_type_code;
5746: exit when c1%NOTFOUND;
5747:
5748: update po_wf_candidate_req_lines_temp
5749: set process_code = 'PROCESSED'
5750: where rowid=c_rowid;
5751: --Bug# 1721991, where current of c1;
5752:

Line 7526: DELETE FROM po_wf_candidate_req_lines_temp

7522: aname => 'REQ_LINE_ID');
7523:
7524: l_progress := '010';
7525: -- Delete all expense lines from the temporary table
7526: DELETE FROM po_wf_candidate_req_lines_temp
7527: WHERE requisition_line_id = (
7528: SELECT requisition_line_id
7529: FROM po_requisition_lines
7530: WHERE labor_req_line_id = l_req_line_id);