eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_AUTO_PROCURE_PK dependencies on PO_HEADERS

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 1417: p_from_currency po_headers.currency_code%TYPE;

1413: --rolled up price again because the component prices are already converted.
1414: FUNCTION convert_currency ( p_int_header_id NUMBER,
1415: p_price NUMBER ) return NUMBER AS
1416:
1417: p_from_currency po_headers.currency_code%TYPE;
1418: p_to_currency po_headers.currency_code%TYPE;
1419: p_rate_date date;
1420: p_rate_type po_headers.rate_type%TYPE;
1421: p_rate po_headers.rate%TYPE;

Line 1418: p_to_currency po_headers.currency_code%TYPE;

1414: FUNCTION convert_currency ( p_int_header_id NUMBER,
1415: p_price NUMBER ) return NUMBER AS
1416:
1417: p_from_currency po_headers.currency_code%TYPE;
1418: p_to_currency po_headers.currency_code%TYPE;
1419: p_rate_date date;
1420: p_rate_type po_headers.rate_type%TYPE;
1421: p_rate po_headers.rate%TYPE;
1422: p_org_id po_headers.org_id%TYPE;

Line 1420: p_rate_type po_headers.rate_type%TYPE;

1416:
1417: p_from_currency po_headers.currency_code%TYPE;
1418: p_to_currency po_headers.currency_code%TYPE;
1419: p_rate_date date;
1420: p_rate_type po_headers.rate_type%TYPE;
1421: p_rate po_headers.rate%TYPE;
1422: p_org_id po_headers.org_id%TYPE;
1423:
1424: l_new_unit_price po_lines.unit_price%TYPE;

Line 1421: p_rate po_headers.rate%TYPE;

1417: p_from_currency po_headers.currency_code%TYPE;
1418: p_to_currency po_headers.currency_code%TYPE;
1419: p_rate_date date;
1420: p_rate_type po_headers.rate_type%TYPE;
1421: p_rate po_headers.rate%TYPE;
1422: p_org_id po_headers.org_id%TYPE;
1423:
1424: l_new_unit_price po_lines.unit_price%TYPE;
1425: --l_extended_precision NUMBER;

Line 1422: p_org_id po_headers.org_id%TYPE;

1418: p_to_currency po_headers.currency_code%TYPE;
1419: p_rate_date date;
1420: p_rate_type po_headers.rate_type%TYPE;
1421: p_rate po_headers.rate%TYPE;
1422: p_org_id po_headers.org_id%TYPE;
1423:
1424: l_new_unit_price po_lines.unit_price%TYPE;
1425: --l_extended_precision NUMBER;
1426: lStmtNo NUMBER;

Line 1457: -- , po_headers_interface phi

1453: -- p_to_currency,
1454: -- p_rate_date
1455: -- FROM hr_organization_information hoi
1456: -- , gl_sets_of_books GLB
1457: -- , po_headers_interface phi
1458: -- WHERE phi.interface_header_id = p_int_header_id
1459: -- AND hoi.organization_id = phi.org_id
1460: -- AND org_information_context = 'Operating Unit Information'
1461: -- AND TO_NUMBER(hoi.org_information3) = glb.set_of_books_id;

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 3675: select po_headers_interface_s.nextval

3671: begin
3672:
3673: g_pg_level := g_pg_level + 3;
3674:
3675: select po_headers_interface_s.nextval
3676: into x_int_header_id
3677: from dual;
3678:
3679: If nvl(p_batch_id,-1) = -1 Then

Line 3688: Insert into Po_headers_interface(

3684: oe_debug_pub.add(lpad(' ',g_pg_level) || 'insert_blanket_header: ' || 'Interface header id ='||to_char(x_int_header_id),1);
3685: END IF;
3686:
3687:
3688: Insert into Po_headers_interface(
3689: interface_header_id,
3690: batch_id,
3691: process_code,
3692: action,

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