APPS.CTO_AUTO_PROCURE_PK dependencies on PO_HEADERS_ALL

Line 247: x_org_id OUT NOCOPY po_headers_all.org_id%type,

243: procedure insert_blanket_header(
244: p_doc_header_id IN Number,
245: p_batch_id IN OUT NOCOPY Number,
246: x_int_header_id Out NOCOPY Number,
247: x_org_id OUT NOCOPY po_headers_all.org_id%type,
248: x_return_status OUT NOCOPY varchar2,
249: x_msg_count OUT NOCOPY Number,
250: x_msg_data OUT NOCOPY varchar2);
251:

Line 2986: x_org_id Po_headers_all.org_id%type;

2982: x_start_date Date;
2983: x_end_date Date;
2984: l_doc_exists Boolean;
2985: x_index Number;
2986: x_org_id Po_headers_all.org_id%type;
2987: l_model_item_id Number;
2988: l_config_exists Varchar2(1);
2989: l_po_valid_org Number;
2990: l_buy_found Varchar(1);

Line 3301: po_headers_all poh

3297: from mtl_system_items
3298: where inventory_item_id = p_config_item_id
3299: and organization_id = (select fsp.inventory_organization_id
3300: from financials_system_params_all fsp,
3301: po_headers_all poh
3302: where poh.po_header_id = l_doc_header_id
3303: and fsp.org_id = poh.org_id);
3304: Exception when no_data_found then
3305: l_config_exists := 'N';

Line 3480: Po_headers_all poh

3476:
3477: Select 'X'
3478: into line_exists
3479: From po_lines_all pol,
3480: Po_headers_all poh
3481: Where
3482: poh.type_lookup_code = 'BLANKET'
3483: AND poh.approved_flag = 'Y'
3484: AND nvl(poh.closed_code,'OPEN') NOT IN('FINALLY CLOSED','CLOSED')

Line 3581: Po_headers_all poh,

3577: muom.uom_code
3578: into l_unit_price,
3579: l_po_uom
3580: From po_lines_all pol,
3581: Po_headers_all poh,
3582: mtl_units_of_measure muom
3583: Where
3584: poh.type_lookup_code = 'BLANKET'
3585: AND poh.approved_flag = 'Y'

Line 3667: x_org_id OUT NOCOPY po_headers_all.org_id%type,

3663: procedure insert_blanket_header(
3664: p_doc_header_id IN Number,
3665: p_batch_id IN OUT NOCOPY Number,
3666: x_int_header_id Out NOCOPY Number,
3667: x_org_id OUT NOCOPY po_headers_all.org_id%type,
3668: x_return_status OUT NOCOPY varchar2,
3669: x_msg_count OUT NOCOPY Number,
3670: x_msg_data OUT NOCOPY varchar2) is
3671: begin

Line 3751: From Po_headers_all poh

3747: poh.reply_date,
3748: poh.ussgl_transaction_code,
3749: 'Y',
3750: global_agreement_flag /* BUG#2726167 populate global_agreement_flag */
3751: From Po_headers_all poh
3752: where poh.po_header_id = p_doc_header_id;
3753:
3754: select org_id
3755: into x_org_id

Line 3756: from po_headers_all

3752: where poh.po_header_id = p_doc_header_id;
3753:
3754: select org_id
3755: into x_org_id
3756: from po_headers_all
3757: where po_header_id = p_doc_header_id;
3758:
3759:
3760: IF PG_DEBUG <> 0 THEN

Line 3891: po_headers_all poh

3887: pol.tax_code_id,
3888: decode(poh.start_date,null,p_start_date,poh.start_date),
3889: decode(poh.end_date,null,p_end_date,poh.end_date)
3890: from po_lines_all pol,
3891: po_headers_all poh
3892: where pol.po_line_id =p_doc_line_id
3893: and poh.po_header_id = pol.po_header_id;
3894:
3895: IF PG_DEBUG <> 0 THEN