APPS.PO_AUTOCREATE_DOC dependencies on PO_WF_CANDIDATE_REQ_LINES_TEMP

Line 2986: INSERT INTO po_wf_candidate_req_lines_temp

2982: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2983: END IF;
2984:
2985: begin
2986: INSERT INTO po_wf_candidate_req_lines_temp
2987: (group_id,
2988: requisition_header_id,
2989: requisition_line_id,
2990: suggested_buyer_id,

Line 3028: 'into po_wf_candidate_req_lines_temp';

3024: l_job_id); --
3025: exception
3026: when others then
3027: x_progress := '15: insert_cand_req_lines_into_tbl: IN EXCEPTION when inserting' ||
3028: 'into po_wf_candidate_req_lines_temp';
3029: IF (g_po_wf_debug = 'Y') THEN
3030: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3031: END IF;
3032: raise;

Line 3203: from po_wf_candidate_req_lines_temp prlt,

3199: --
3200: ,prl.line_type_id,
3201: prl.purchase_basis
3202: --
3203: from po_wf_candidate_req_lines_temp prlt,
3204: po_requisition_lines prl,
3205: hr_locations_all hrl
3206: where prlt.process_code = 'PENDING'
3207: and prlt.group_id = x_group_id

Line 3249: from po_wf_candidate_req_lines_temp prlt,

3245: ,prl.line_type_id,
3246: prl.purchase_basis
3247: --
3248:
3249: from po_wf_candidate_req_lines_temp prlt,
3250: po_requisition_lines prl,
3251: hr_locations_all hrl
3252: where prlt.process_code = 'PENDING'
3253: and prlt.group_id = x_group_id

Line 3753: update po_wf_candidate_req_lines_temp

3749: /* Update the process code of the current line in the temp table so
3750: * it doesn't get picked up again by the cursor for processing.
3751: */
3752:
3753: update po_wf_candidate_req_lines_temp
3754: set process_code = 'PROCESSED'
3755: where rowid=c2_rowid;
3756: -- Bug# 1721991, where current of c2;
3757:

Line 5887: delete from po_wf_candidate_req_lines_temp

5883:
5884:
5885: /* Delete all rows belonging to this group_id */
5886:
5887: delete from po_wf_candidate_req_lines_temp
5888: where group_id = x_group_id;
5889:
5890: /* Calling process should do the commit, so comment out here.
5891: * COMMIT;

Line 6067: from po_wf_candidate_req_lines_temp prlt,

6063: prl.suggested_vendor_contact,
6064: prl.vendor_contact_id,
6065: prl.destination_organization_id,
6066: prl.destination_type_code
6067: from po_wf_candidate_req_lines_temp prlt,
6068: po_requisition_lines prl
6069: where prlt.process_code = 'PENDING'
6070: and prlt.group_id = x_group_id
6071: and prlt.requisition_header_id = prl.requisition_header_id

Line 6130: update po_wf_candidate_req_lines_temp

6126: c_dest_org_id,
6127: c_dest_type_code;
6128: exit when c1%NOTFOUND;
6129:
6130: update po_wf_candidate_req_lines_temp
6131: set process_code = 'PROCESSED'
6132: where rowid=c_rowid;
6133: --Bug# 1721991, where current of c1;
6134:

Line 7979: DELETE FROM po_wf_candidate_req_lines_temp

7975: aname => 'REQ_LINE_ID');
7976:
7977: l_progress := '010';
7978: -- Delete all expense lines from the temporary table
7979: DELETE FROM po_wf_candidate_req_lines_temp
7980: WHERE requisition_line_id = (
7981: SELECT requisition_line_id
7982: FROM po_requisition_lines
7983: WHERE labor_req_line_id = l_req_line_id);