APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on PO_HEADERS_ALL

Line 2836: PO_HEADERS_ALL POH

2832: SELECT l_key,
2833: TLP.attribute_values_tlp_id
2834: FROM PO_ATTRIBUTE_VALUES_TLP TLP,
2835: PO_LINES_ALL POL,
2836: PO_HEADERS_ALL POH
2837: WHERE TLP.po_line_id = p_po_line_id_list(i)
2838: AND p_po_line_id_list(i) <> g_NOT_REQUIRED_ID
2839: AND POL.po_line_id = TLP.po_line_id
2840: AND POH.po_header_id = POL.po_header_id

Line 3445: l_default_lang PO_HEADERS_ALL.created_language%TYPE;

3441: IS
3442: d_mod CONSTANT VARCHAR2(100) := D_create_default_attr_tlp;
3443: l_progress VARCHAR2(4);
3444:
3445: l_default_lang PO_HEADERS_ALL.created_language%TYPE;
3446: l_description PO_ATTRIBUTE_VALUES_TLP.description%TYPE;
3447: l_long_description PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE;
3448: BEGIN
3449: l_progress := '010';

Line 3470: FROM PO_HEADERS_ALL POH,

3466: -- SQL Why : To create a default Attr TLP row for the default language
3467: -- SQL Join: po_line_id, po_header_id
3468: SELECT POH.created_language
3469: INTO l_default_lang
3470: FROM PO_HEADERS_ALL POH,
3471: PO_LINES_ALL POL
3472: WHERE POH.po_header_id = POL.po_header_id
3473: AND POL.po_line_id = p_po_line_id;
3474: ELSE

Line 3609: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

3605: IS
3606: d_mod CONSTANT VARCHAR2(100) := D_create_default_attributes;
3607: l_progress VARCHAR2(4);
3608:
3609: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3610: -- Bug 7039409: Declared new variables
3611: l_manufacturer_part_num PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE;
3612: l_manufacturer PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE;
3613: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;

Line 3637: FROM PO_HEADERS_ALL POH,

3633: -- SQL Why : To check if it BLANKET or QUOTATION or not
3634: -- SQL Join: po_line_id
3635: SELECT POH.type_lookup_code
3636: INTO l_type_lookup_code
3637: FROM PO_HEADERS_ALL POH,
3638: PO_LINES_ALL POL
3639: WHERE POL.po_line_id = p_po_line_id
3640: AND POH.po_header_id = POL.po_header_id;
3641: ELSE

Line 3754: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

3750: d_mod CONSTANT VARCHAR2(100) := D_create_default_attributes_MI;
3751: l_progress VARCHAR2(4);
3752: l_manufacturer_part_num PO_ATTRIBUTE_VALUES.MANUFACTURER_PART_NUM%TYPE;
3753: l_proc_lead_time PO_ATTRIBUTE_VALUES.LEAD_TIME%TYPE;
3754: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3755: BEGIN
3756: l_progress := '010';
3757:
3758: IF PO_LOG.d_proc THEN

Line 4117: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

4113: IS
4114: d_mod CONSTANT VARCHAR2(100) := D_update_attributes||'_MI';
4115: l_progress VARCHAR2(4);
4116:
4117: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
4118: l_orig_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
4119: l_orig_item_description PO_ATTRIBUTE_VALUES_TLP.description%TYPE;
4120: l_manufacturer_part_num PO_ATTRIBUTE_VALUES.MANUFACTURER_PART_NUM%TYPE;
4121: l_orig_long_desc PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE;

Line 4460: PO_HEADERS_ALL POH

4456: SELECT POLD.po_line_id, TLP.attribute_values_tlp_id
4457: BULK COLLECT INTO l_po_line_id_list, l_tlp_id_list
4458: FROM PO_LINES_DRAFT_ALL POLD,
4459: PO_ATTRIBUTE_VALUES_TLP TLP,
4460: PO_HEADERS_ALL POH
4461: WHERE POLD.draft_id = p_draft_id
4462: AND NVL(POLD.change_accepted_flag, 'Y') = 'Y'
4463: AND POLD.po_line_id = TLP.po_line_id
4464: AND POH.po_header_id = POLD.po_header_id

Line 4779: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

4775: IS
4776: d_mod CONSTANT VARCHAR2(100) := D_update_attributes;
4777: l_progress VARCHAR2(4);
4778:
4779: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
4780: l_orig_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
4781: l_orig_item_description PO_ATTRIBUTE_VALUES_TLP.description%TYPE;
4782: BEGIN
4783: l_progress := '010';

Line 4804: FROM PO_HEADERS_ALL POH,

4800: -- SQL Why : To check if it BLANKET or QUOTATION or not
4801: -- SQL Join: po_line_id
4802: SELECT POH.type_lookup_code
4803: INTO l_type_lookup_code
4804: FROM PO_HEADERS_ALL POH,
4805: PO_LINES_ALL POL
4806: WHERE POL.po_line_id = p_po_line_id
4807: AND POH.po_header_id = POL.po_header_id;
4808: ELSE