2673: --End of Comments
2674: --------------------------------------------------------------------------------
2675: PROCEDURE get_translations
2676: (
2677: p_attr_values_tlp_id_list IN PO_TBL_NUMBER
2678: , x_tlp_id_to_be_copied_list OUT NOCOPY PO_TBL_NUMBER
2679: , x_tlp_new_descriptions_list OUT NOCOPY PO_TBL_VARCHAR480
2680: , x_tlp_language_list OUT NOCOPY PO_TBL_VARCHAR4
2681: , x_tlp_long_descriptions_list OUT NOCOPY PO_TBL_VARCHAR2000 -- Bug7039409: Added
2674: --------------------------------------------------------------------------------
2675: PROCEDURE get_translations
2676: (
2677: p_attr_values_tlp_id_list IN PO_TBL_NUMBER
2678: , x_tlp_id_to_be_copied_list OUT NOCOPY PO_TBL_NUMBER
2679: , x_tlp_new_descriptions_list OUT NOCOPY PO_TBL_VARCHAR480
2680: , x_tlp_language_list OUT NOCOPY PO_TBL_VARCHAR4
2681: , x_tlp_long_descriptions_list OUT NOCOPY PO_TBL_VARCHAR2000 -- Bug7039409: Added
2682: )
2797: --End of Comments
2798: --------------------------------------------------------------------------------
2799: PROCEDURE get_tlp_ids_for_lines
2800: (
2801: p_po_line_id_list IN PO_TBL_NUMBER
2802: , x_tlp_id_list OUT NOCOPY PO_TBL_NUMBER
2803: )
2804: IS
2805: d_mod CONSTANT VARCHAR2(100) := D_get_tlp_ids_for_lines;
2798: --------------------------------------------------------------------------------
2799: PROCEDURE get_tlp_ids_for_lines
2800: (
2801: p_po_line_id_list IN PO_TBL_NUMBER
2802: , x_tlp_id_list OUT NOCOPY PO_TBL_NUMBER
2803: )
2804: IS
2805: d_mod CONSTANT VARCHAR2(100) := D_get_tlp_ids_for_lines;
2806: l_progress VARCHAR2(4);
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,
2904: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL
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,
2904: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL
2905: )
2907: d_mod CONSTANT VARCHAR2(100) := D_create_translations;
2908: l_progress VARCHAR2(4);
2909:
2910: l_attr_values_tlp_id PO_ATTRIBUTE_VALUES_TLP.attribute_values_tlp_id%TYPE;
2911: l_attr_values_tlp_id_list PO_TBL_NUMBER := PO_TBL_NUMBER();
2912: l_tlp_id_to_be_copied_list PO_TBL_NUMBER := PO_TBL_NUMBER();
2913: l_tlp_new_descriptions_list PO_TBL_VARCHAR480;-- := PO_TBL_VARCHAR480();
2914: l_tlp_language_list PO_TBL_VARCHAR4;-- := PO_TBL_VARCHAR4();
2915: l_tlp_long_descriptions_list PO_TBL_VARCHAR2000; -- Bug7039409: Declared new table
2908: l_progress VARCHAR2(4);
2909:
2910: l_attr_values_tlp_id PO_ATTRIBUTE_VALUES_TLP.attribute_values_tlp_id%TYPE;
2911: l_attr_values_tlp_id_list PO_TBL_NUMBER := PO_TBL_NUMBER();
2912: l_tlp_id_to_be_copied_list PO_TBL_NUMBER := PO_TBL_NUMBER();
2913: l_tlp_new_descriptions_list PO_TBL_VARCHAR480;-- := PO_TBL_VARCHAR480();
2914: l_tlp_language_list PO_TBL_VARCHAR4;-- := PO_TBL_VARCHAR4();
2915: l_tlp_long_descriptions_list PO_TBL_VARCHAR2000; -- Bug7039409: Declared new table
2916:
2913: l_tlp_new_descriptions_list PO_TBL_VARCHAR480;-- := PO_TBL_VARCHAR480();
2914: l_tlp_language_list PO_TBL_VARCHAR4;-- := PO_TBL_VARCHAR4();
2915: l_tlp_long_descriptions_list PO_TBL_VARCHAR2000; -- Bug7039409: Declared new table
2916:
2917: l_po_line_id_list PO_TBL_NUMBER := PO_TBL_NUMBER();
2918: l_default_lang_tlp_id_list PO_TBL_NUMBER := PO_TBL_NUMBER();
2919: BEGIN
2920: l_progress := '010';
2921:
2914: l_tlp_language_list PO_TBL_VARCHAR4;-- := PO_TBL_VARCHAR4();
2915: l_tlp_long_descriptions_list PO_TBL_VARCHAR2000; -- Bug7039409: Declared new table
2916:
2917: l_po_line_id_list PO_TBL_NUMBER := PO_TBL_NUMBER();
2918: l_default_lang_tlp_id_list PO_TBL_NUMBER := PO_TBL_NUMBER();
2919: BEGIN
2920: l_progress := '010';
2921:
2922: IF PO_LOG.d_proc THEN
4432: IS
4433: d_mod CONSTANT VARCHAR2(100) := D_gen_draft_line_translations;
4434: l_progress VARCHAR2(4);
4435:
4436: l_language_codes PO_TBL_NUMBER;
4437: l_tlp_row PO_ATTRIBUTE_VALUES_TLP%rowtype;
4438: l_po_line_id_list PO_TBL_NUMBER;
4439: l_tlp_id_list PO_TBL_NUMBER;
4440: BEGIN
4434: l_progress VARCHAR2(4);
4435:
4436: l_language_codes PO_TBL_NUMBER;
4437: l_tlp_row PO_ATTRIBUTE_VALUES_TLP%rowtype;
4438: l_po_line_id_list PO_TBL_NUMBER;
4439: l_tlp_id_list PO_TBL_NUMBER;
4440: BEGIN
4441: l_progress := '010';
4442:
4435:
4436: l_language_codes PO_TBL_NUMBER;
4437: l_tlp_row PO_ATTRIBUTE_VALUES_TLP%rowtype;
4438: l_po_line_id_list PO_TBL_NUMBER;
4439: l_tlp_id_list PO_TBL_NUMBER;
4440: BEGIN
4441: l_progress := '010';
4442:
4443: IF PO_LOG.d_proc THEN