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 2601: x_org_id Po_headers_all.org_id%type;

2597: x_start_date Date;
2598: x_end_date Date;
2599: l_doc_exists Boolean;
2600: x_index Number;
2601: x_org_id Po_headers_all.org_id%type;
2602: l_model_item_id Number;
2603: l_config_exists Varchar2(1);
2604: l_po_valid_org Number;
2605: l_buy_found Varchar(1);

Line 2916: po_headers_all poh

2912: from mtl_system_items
2913: where inventory_item_id = p_config_item_id
2914: and organization_id = (select fsp.inventory_organization_id
2915: from financials_system_params_all fsp,
2916: po_headers_all poh
2917: where poh.po_header_id = l_doc_header_id
2918: and fsp.org_id = poh.org_id);
2919: Exception when no_data_found then
2920: l_config_exists := 'N';

Line 3095: Po_headers_all poh

3091:
3092: Select 'X'
3093: into line_exists
3094: From po_lines_all pol,
3095: Po_headers_all poh
3096: Where
3097: poh.type_lookup_code = 'BLANKET'
3098: AND poh.approved_flag = 'Y'
3099: AND nvl(poh.closed_code,'OPEN') NOT IN('FINALLY CLOSED','CLOSED')

Line 3196: Po_headers_all poh,

3192: muom.uom_code
3193: into l_unit_price,
3194: l_po_uom
3195: From po_lines_all pol,
3196: Po_headers_all poh,
3197: mtl_units_of_measure muom
3198: Where
3199: poh.type_lookup_code = 'BLANKET'
3200: AND poh.approved_flag = 'Y'

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

3278: procedure insert_blanket_header(
3279: p_doc_header_id IN Number,
3280: p_batch_id IN OUT NOCOPY Number,
3281: x_int_header_id Out NOCOPY Number,
3282: x_org_id OUT NOCOPY po_headers_all.org_id%type,
3283: x_return_status OUT NOCOPY varchar2,
3284: x_msg_count OUT NOCOPY Number,
3285: x_msg_data OUT NOCOPY varchar2) is
3286: begin

Line 3363: From Po_headers_all poh

3359: poh.reply_date,
3360: poh.ussgl_transaction_code,
3361: 'Y',
3362: global_agreement_flag /* BUG#2726167 populate global_agreement_flag */
3363: From Po_headers_all poh
3364: where poh.po_header_id = p_doc_header_id;
3365:
3366: select org_id
3367: into x_org_id

Line 3368: from po_headers_all

3364: where poh.po_header_id = p_doc_header_id;
3365:
3366: select org_id
3367: into x_org_id
3368: from po_headers_all
3369: where po_header_id = p_doc_header_id;
3370:
3371:
3372: IF PG_DEBUG <> 0 THEN

Line 3487: po_headers_all poh

3483: pol.tax_code_id,
3484: decode(poh.start_date,null,p_start_date,poh.start_date),
3485: decode(poh.end_date,null,p_end_date,poh.end_date)
3486: from po_lines_all pol,
3487: po_headers_all poh
3488: where pol.po_line_id =p_doc_line_id
3489: and poh.po_header_id = pol.po_header_id;
3490:
3491: IF PG_DEBUG <> 0 THEN