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.PO_ATTRIBUTE_VALUES_PVT dependencies on PO_LINES

Line 91: FROM PO_LINES_ALL POL,

87: )
88: IS
89: SELECT PAII.interface_line_number,
90: PAV.*
91: FROM PO_LINES_ALL POL,
92: PO_ATTRIBUTE_VALUES PAV,
93: PON_AUC_ITEMS_INTERFACE PAII
94: WHERE POL.po_header_id = p_po_header_id
95: AND POL.po_line_id = pav.po_line_id

Line 110: FROM PO_LINES_ALL POL,

106: )
107: IS
108: SELECT PAII.interface_line_number,
109: PAVT.*
110: FROM PO_LINES_ALL POL,
111: PO_ATTRIBUTE_VALUES_TLP PAVT,
112: PON_AUC_ITEMS_INTERFACE PAII
113: WHERE POL.po_header_id = p_po_header_id
114: AND POL.po_line_id = pavt.po_line_id

Line 138: PO_LINES_ALL POL

134: AND PRL.blanket_po_header_id IS NOT NULL
135: AND PRL.blanket_po_line_num IS NOT NULL
136: GROUP BY PB.auction_header_id,PB.line_number, blanket_po_header_id, blanket_po_line_num) PBR,
137: PO_ATTRIBUTE_VALUES PAV,
138: PO_LINES_ALL POL
139: WHERE PAIP.auction_header_id = PBR.auction_header_id
140: AND PAIP.line_number = PBR.line_number
141: AND POL.po_header_id = PBR.blanket_po_header_id
142: AND POL.line_num = PBR.blanket_po_line_num

Line 165: PO_LINES_ALL POL

161: AND PRL.blanket_po_header_id IS NOT NULL
162: AND PRL.blanket_po_line_num IS NOT NULL
163: GROUP BY PB.auction_header_id,PB.line_number, blanket_po_header_id, blanket_po_line_num) PBR,
164: PO_ATTRIBUTE_VALUES_TLP PAVT,
165: PO_LINES_ALL POL
166: WHERE PAIP.auction_header_id = PBR.auction_header_id
167: AND PAIP.line_number = PBR.line_number
168: AND POL.po_header_id = PBR.blanket_po_header_id
169: AND POL.line_num = PBR.blanket_po_line_num

Line 2835: PO_LINES_ALL POL,

2831: )
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

Line 2899: p_po_line_id IN PO_LINES.po_line_id%TYPE DEFAULT NULL,

2895: PROCEDURE create_translations
2896: (
2897: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
2898: p_default_lang_tlp_id IN PO_ATTRIBUTE_VALUES_TLP.attribute_values_tlp_id%TYPE DEFAULT NULL,
2899: p_po_line_id IN PO_LINES.po_line_id%TYPE DEFAULT NULL,
2900: p_default_lang_tlp_id_list IN PO_TBL_NUMBER DEFAULT NULL,
2901: p_po_line_id_list IN PO_TBL_NUMBER DEFAULT NULL,
2902: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,
2903: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE DEFAULT NULL,

Line 2904: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL

2900: p_default_lang_tlp_id_list IN PO_TBL_NUMBER DEFAULT NULL,
2901: p_po_line_id_list IN PO_TBL_NUMBER DEFAULT NULL,
2902: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,
2903: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE DEFAULT NULL,
2904: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL
2905: )
2906: IS
2907: d_mod CONSTANT VARCHAR2(100) := D_create_translations;
2908: l_progress VARCHAR2(4);

Line 3432: p_po_line_id IN PO_LINES.po_line_id%TYPE,

3428: --------------------------------------------------------------------------------
3429: PROCEDURE create_default_attr_tlp
3430: (
3431: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
3432: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3433: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3434: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3435: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3436: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

Line 3435: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

3431: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
3432: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3433: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3434: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3435: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3436: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3437: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3438: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
3439: -- Bug 7039409: Added new param p_manufacturer

Line 3436: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

3432: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3433: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3434: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3435: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3436: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3437: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3438: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
3439: -- Bug 7039409: Added new param p_manufacturer
3440: p_manufacturer IN PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE

Line 3437: p_org_id IN PO_LINES_ALL.org_id%TYPE,

3433: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3434: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3435: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3436: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3437: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3438: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
3439: -- Bug 7039409: Added new param p_manufacturer
3440: p_manufacturer IN PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE
3441: )

Line 3472: PO_LINES_ALL POL

3468: -- SQL Join: po_line_id, po_header_id
3469: SELECT POH.created_language
3470: INTO l_default_lang
3471: FROM PO_HEADERS_ALL POH,
3472: PO_LINES_ALL POL
3473: WHERE POH.po_header_id = POL.po_header_id
3474: AND POL.po_line_id = p_po_line_id;
3475: ELSE
3476: l_progress := '030';

Line 3598: p_po_line_id IN PO_LINES.po_line_id%TYPE,

3594: --------------------------------------------------------------------------------
3595: PROCEDURE create_default_attributes
3596: (
3597: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
3598: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3599: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3600: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3601: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3602: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

Line 3601: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

3597: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
3598: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3599: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3600: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3601: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3602: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3603: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3604: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
3605: )

Line 3602: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

3598: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3599: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3600: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3601: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3602: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3603: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3604: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
3605: )
3606: IS

Line 3603: p_org_id IN PO_LINES_ALL.org_id%TYPE,

3599: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3600: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3601: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3602: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3603: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3604: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
3605: )
3606: IS
3607: d_mod CONSTANT VARCHAR2(100) := D_create_default_attributes;

Line 3639: PO_LINES_ALL POL

3635: -- SQL Join: po_line_id
3636: SELECT POH.type_lookup_code
3637: INTO l_type_lookup_code
3638: FROM PO_HEADERS_ALL POH,
3639: PO_LINES_ALL POL
3640: WHERE POL.po_line_id = p_po_line_id
3641: AND POH.po_header_id = POL.po_header_id;
3642: ELSE
3643: l_type_lookup_code := p_doc_type;

Line 3743: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

3739: END create_default_attributes;
3740:
3741: PROCEDURE create_default_attributes_MI
3742: (
3743: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3744: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3745: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3746: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
3747: p_organization_id IN NUMBER,

Line 3744: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

3740:
3741: PROCEDURE create_default_attributes_MI
3742: (
3743: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3744: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3745: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3746: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
3747: p_organization_id IN NUMBER,
3748: p_master_organization_id IN NUMBER

Line 3745: p_org_id IN PO_LINES_ALL.org_id%TYPE,

3741: PROCEDURE create_default_attributes_MI
3742: (
3743: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3744: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3745: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3746: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
3747: p_organization_id IN NUMBER,
3748: p_master_organization_id IN NUMBER
3749: )

Line 3874: p_org_id IN PO_LINES_ALL.org_id%TYPE,

3870: -- this is for master items
3871:
3872: PROCEDURE wipeout_category_attributes_MI
3873: (
3874: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3875: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3876: p_inventory_item_id IN PO_ATTRIBUTE_VALUES_TLP.inventory_item_id%TYPE,
3877: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
3878: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE

Line 3875: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

3871:
3872: PROCEDURE wipeout_category_attributes_MI
3873: (
3874: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3875: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3876: p_inventory_item_id IN PO_ATTRIBUTE_VALUES_TLP.inventory_item_id%TYPE,
3877: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
3878: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
3879: )

Line 4105: p_org_id IN PO_LINES_ALL.org_id%TYPE,

4101:
4102: -- update attributes for master items
4103: PROCEDURE update_attributes_MI
4104: (
4105: p_org_id IN PO_LINES_ALL.org_id%TYPE,
4106: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
4107: p_inventory_item_id IN PO_ATTRIBUTE_VALUES_TLP.inventory_item_id%TYPE,
4108: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
4109: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,

Line 4106: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

4102: -- update attributes for master items
4103: PROCEDURE update_attributes_MI
4104: (
4105: p_org_id IN PO_LINES_ALL.org_id%TYPE,
4106: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
4107: p_inventory_item_id IN PO_ATTRIBUTE_VALUES_TLP.inventory_item_id%TYPE,
4108: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
4109: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
4110: p_long_description IN PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE,

Line 4119: l_orig_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;

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

Line 4127: l_inventory_org_id PO_LINES_ALL.org_id%TYPE;

4123: l_new_long_description PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE := nvl(p_long_description,' ');
4124: l_manufacturer PO_ATTRIBUTE_VALUES_TLP.MANUFACTURER%TYPE;
4125: l_proc_lead_time PO_ATTRIBUTE_VALUES.LEAD_TIME%TYPE;
4126: l_orig_manufacturer PO_ATTRIBUTE_VALUES_TLP.MANUFACTURER%TYPE;
4127: l_inventory_org_id PO_LINES_ALL.org_id%TYPE;
4128: l_rec_tlp_for_lang VARCHAR2(100);
4129:
4130: BEGIN
4131: l_progress := '010';

Line 4432: -- present in the PO_LINES_DRAFT_ALL table for a given draft_id.

4428: --Locks:
4429: -- None.
4430: --Function:
4431: -- Create Translations in the TLP table for each of the modified line
4432: -- present in the PO_LINES_DRAFT_ALL table for a given draft_id.
4433: -- (for a Blanket or Quotation).
4434: -- It creates translations from one of the 2 sources:
4435: -- a) INV Item Master (if item_id is not null)
4436: -- b) Copies the TLP row of the created language to all other langs

Line 4442: -- The DRAFT_ID to get the modifed PO Lines for which translations need to

4438: --
4439: --Parameters:
4440: --IN:
4441: --p_draft_id
4442: -- The DRAFT_ID to get the modifed PO Lines for which translations need to
4443: -- be created.
4444: --p_doc-type
4445: -- The document type of the document.
4446: --End of Comments

Line 4473: -- PO_LINES_DRAFT_ALL table would contain only the lines that are

4469: IF (p_doc_type IN ('BLANKET', 'QUOTATION')) THEN
4470:
4471: -- SQL What: Get the PO_LINE_ID's and TLP_ID's for the PO
4472: -- Fetch only the lines that are modified. Since the
4473: -- PO_LINES_DRAFT_ALL table would contain only the lines that are
4474: -- modified, we join to it to get the list of PO_LINE_ID's.
4475: -- SQL Why : To create the TLP translations for each line
4476: -- SQL Join: draft_id, po_header_id, po_line_id, language
4477: SELECT POLD.po_line_id, TLP.attribute_values_tlp_id

Line 4479: FROM PO_LINES_DRAFT_ALL POLD,

4475: -- SQL Why : To create the TLP translations for each line
4476: -- SQL Join: draft_id, po_header_id, po_line_id, language
4477: SELECT POLD.po_line_id, TLP.attribute_values_tlp_id
4478: BULK COLLECT INTO l_po_line_id_list, l_tlp_id_list
4479: FROM PO_LINES_DRAFT_ALL POLD,
4480: PO_ATTRIBUTE_VALUES_TLP TLP,
4481: PO_HEADERS_ALL POH
4482: WHERE POLD.draft_id = p_draft_id
4483: AND NVL(POLD.change_accepted_flag, 'Y') = 'Y'

Line 4788: p_po_line_id IN PO_LINES.po_line_id%TYPE,

4784: --------------------------------------------------------------------------------
4785: PROCEDURE update_attributes
4786: (
4787: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
4788: p_po_line_id IN PO_LINES.po_line_id%TYPE,
4789: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
4790: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
4791: p_org_id IN PO_LINES_ALL.org_id%TYPE,
4792: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

Line 4791: p_org_id IN PO_LINES_ALL.org_id%TYPE,

4787: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
4788: p_po_line_id IN PO_LINES.po_line_id%TYPE,
4789: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
4790: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
4791: p_org_id IN PO_LINES_ALL.org_id%TYPE,
4792: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
4793: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
4794: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
4795: )

Line 4792: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

4788: p_po_line_id IN PO_LINES.po_line_id%TYPE,
4789: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
4790: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
4791: p_org_id IN PO_LINES_ALL.org_id%TYPE,
4792: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
4793: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
4794: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
4795: )
4796: IS

Line 4801: l_orig_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;

4797: d_mod CONSTANT VARCHAR2(100) := D_update_attributes;
4798: l_progress VARCHAR2(4);
4799:
4800: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
4801: l_orig_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
4802: l_orig_item_description PO_ATTRIBUTE_VALUES_TLP.description%TYPE;
4803: l_orig_long_description PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE;
4804: l_long_description MTL_SYSTEM_ITEMS_TL.long_description%TYPE;
4805: l_lead_time MTL_SYSTEM_ITEMS_B.full_lead_time%TYPE;

Line 4831: PO_LINES_ALL POL

4827: -- SQL Join: po_line_id
4828: SELECT POH.type_lookup_code
4829: INTO l_type_lookup_code
4830: FROM PO_HEADERS_ALL POH,
4831: PO_LINES_ALL POL
4832: WHERE POL.po_line_id = p_po_line_id
4833: AND POH.po_header_id = POL.po_header_id;
4834: ELSE
4835: l_type_lookup_code := p_doc_type;

Line 5089: p_orig_po_line_id IN PO_LINES.po_line_id%TYPE

5085: --End of Comments
5086: --------------------------------------------------------------------------------
5087: PROCEDURE copy_attributes
5088: (
5089: p_orig_po_line_id IN PO_LINES.po_line_id%TYPE
5090: , p_new_po_line_id IN PO_LINES.po_line_id%TYPE
5091: )
5092: IS
5093: d_mod CONSTANT VARCHAR2(100) := D_copy_attributes;

Line 5090: , p_new_po_line_id IN PO_LINES.po_line_id%TYPE

5086: --------------------------------------------------------------------------------
5087: PROCEDURE copy_attributes
5088: (
5089: p_orig_po_line_id IN PO_LINES.po_line_id%TYPE
5090: , p_new_po_line_id IN PO_LINES.po_line_id%TYPE
5091: )
5092: IS
5093: d_mod CONSTANT VARCHAR2(100) := D_copy_attributes;
5094: l_progress VARCHAR2(4);

Line 6242: p_po_line_id IN PO_LINES.po_line_id%TYPE DEFAULT NULL,

6238: --------------------------------------------------------------------------------
6239: PROCEDURE delete_attributes
6240: (
6241: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
6242: p_po_line_id IN PO_LINES.po_line_id%TYPE DEFAULT NULL,
6243: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,
6244: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE DEFAULT NULL,
6245: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL
6246: )

Line 6245: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL

6241: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
6242: p_po_line_id IN PO_LINES.po_line_id%TYPE DEFAULT NULL,
6243: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,
6244: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE DEFAULT NULL,
6245: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL
6246: )
6247: IS
6248: d_mod CONSTANT VARCHAR2(100) := D_delete_attributes;
6249: l_progress VARCHAR2(4);

Line 6318: p_po_header_id IN PO_LINES.po_header_id%TYPE

6314: --------------------------------------------------------------------------------
6315: PROCEDURE delete_attributes_for_header
6316: (
6317: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION'
6318: p_po_header_id IN PO_LINES.po_header_id%TYPE
6319: )
6320: IS
6321: d_mod CONSTANT VARCHAR2(100) := D_delete_attributes_for_header;
6322: l_progress VARCHAR2(4);

Line 6338: (SELECT 'All PO Lines for the given Header'

6334: -- SQL Why : as required by this procedure
6335: -- SQL Join: po_line_id, po_header_id
6336: DELETE FROM PO_ATTRIBUTE_VALUES POATR
6337: WHERE EXISTS
6338: (SELECT 'All PO Lines for the given Header'
6339: FROM PO_LINES_ALL POL
6340: WHERE POL.po_header_id = p_po_header_id
6341: AND POATR.po_line_id = POL.po_line_id);
6342:

Line 6339: FROM PO_LINES_ALL POL

6335: -- SQL Join: po_line_id, po_header_id
6336: DELETE FROM PO_ATTRIBUTE_VALUES POATR
6337: WHERE EXISTS
6338: (SELECT 'All PO Lines for the given Header'
6339: FROM PO_LINES_ALL POL
6340: WHERE POL.po_header_id = p_po_header_id
6341: AND POATR.po_line_id = POL.po_line_id);
6342:
6343:

Line 6352: (SELECT 'All PO Lines for the given Header'

6348: -- SQL Why : as required by this procedure
6349: -- SQL Join: po_line_id, po_header_id
6350: DELETE FROM PO_ATTRIBUTE_VALUES_TLP POTLP
6351: WHERE EXISTS
6352: (SELECT 'All PO Lines for the given Header'
6353: FROM PO_LINES_ALL POL
6354: WHERE POL.po_header_id = p_po_header_id
6355: AND POTLP.po_line_id = POL.po_line_id);
6356:

Line 6353: FROM PO_LINES_ALL POL

6349: -- SQL Join: po_line_id, po_header_id
6350: DELETE FROM PO_ATTRIBUTE_VALUES_TLP POTLP
6351: WHERE EXISTS
6352: (SELECT 'All PO Lines for the given Header'
6353: FROM PO_LINES_ALL POL
6354: WHERE POL.po_header_id = p_po_header_id
6355: AND POTLP.po_line_id = POL.po_line_id);
6356:
6357: l_progress := '030';

Line 6421: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

6417: END get_base_lang;
6418:
6419: PROCEDURE create_attributes_tlp_MI
6420: (
6421: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6422: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
6423: p_org_id IN PO_LINES_ALL.org_id%TYPE,
6424: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
6425: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,

Line 6422: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

6418:
6419: PROCEDURE create_attributes_tlp_MI
6420: (
6421: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6422: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
6423: p_org_id IN PO_LINES_ALL.org_id%TYPE,
6424: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
6425: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
6426: p_long_description IN PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE,

Line 6423: p_org_id IN PO_LINES_ALL.org_id%TYPE,

6419: PROCEDURE create_attributes_tlp_MI
6420: (
6421: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6422: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
6423: p_org_id IN PO_LINES_ALL.org_id%TYPE,
6424: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
6425: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
6426: p_long_description IN PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE,
6427: p_organization_id IN NUMBER,

Line 6570: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

6566: --End of Comments
6567: --------------------------------------------------------------------------------
6568: PROCEDURE get_item_attributes_values
6569: (
6570: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6571: p_manufacturer_part_num OUT NOCOPY PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE,
6572: p_manufacturer OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE,
6573: p_lead_time OUT NOCOPY PO_ATTRIBUTE_VALUES.lead_time%TYPE
6574: )

Line 6607: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

6603: --End of Comments
6604: --------------------------------------------------------------------------------
6605: PROCEDURE get_item_attributes_values
6606: (
6607: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6608: p_manufacturer_part_num OUT NOCOPY PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE,
6609: p_manufacturer OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE,
6610: p_lead_time OUT NOCOPY PO_ATTRIBUTE_VALUES.lead_time%TYPE,
6611: p_manufacturer_id OUT NOCOPY po_requisition_lines_All.MANUFACTURER_ID%TYPE

Line 6710: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

6706: --End of Comments
6707: --------------------------------------------------------------------------------
6708: PROCEDURE get_item_attributes_tlp_values
6709: (
6710: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6711: p_lang IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
6712: p_long_description OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE
6713: )
6714: IS

Line 6717: l_master_organization_id PO_LINES_ALL.org_id%TYPE;

6713: )
6714: IS
6715: d_mod CONSTANT VARCHAR2(100) := D_get_item_attributes_tlp;
6716: l_progress VARCHAR2(4);
6717: l_master_organization_id PO_LINES_ALL.org_id%TYPE;
6718: BEGIN
6719: l_progress := '010';
6720: IF PO_LOG.d_proc THEN
6721: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);