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_TBL_NUMBER

Line 2677: p_attr_values_tlp_id_list IN PO_TBL_NUMBER

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

Line 2678: , x_tlp_id_to_be_copied_list OUT NOCOPY PO_TBL_NUMBER

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

Line 2801: p_po_line_id_list IN PO_TBL_NUMBER

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;

Line 2802: , x_tlp_id_list OUT NOCOPY PO_TBL_NUMBER

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);

Line 2900: p_default_lang_tlp_id_list IN PO_TBL_NUMBER DEFAULT NULL,

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

Line 2901: p_po_line_id_list IN PO_TBL_NUMBER 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: )

Line 2911: l_attr_values_tlp_id_list PO_TBL_NUMBER := PO_TBL_NUMBER();

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

Line 2912: l_tlp_id_to_be_copied_list PO_TBL_NUMBER := PO_TBL_NUMBER();

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:

Line 2917: l_po_line_id_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:
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:

Line 2918: l_default_lang_tlp_id_list PO_TBL_NUMBER := PO_TBL_NUMBER();

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

Line 4457: l_language_codes PO_TBL_NUMBER;

4453: IS
4454: d_mod CONSTANT VARCHAR2(100) := D_gen_draft_line_translations;
4455: l_progress VARCHAR2(4);
4456:
4457: l_language_codes PO_TBL_NUMBER;
4458: l_tlp_row PO_ATTRIBUTE_VALUES_TLP%rowtype;
4459: l_po_line_id_list PO_TBL_NUMBER;
4460: l_tlp_id_list PO_TBL_NUMBER;
4461: BEGIN

Line 4459: l_po_line_id_list PO_TBL_NUMBER;

4455: l_progress VARCHAR2(4);
4456:
4457: l_language_codes PO_TBL_NUMBER;
4458: l_tlp_row PO_ATTRIBUTE_VALUES_TLP%rowtype;
4459: l_po_line_id_list PO_TBL_NUMBER;
4460: l_tlp_id_list PO_TBL_NUMBER;
4461: BEGIN
4462: l_progress := '010';
4463:

Line 4460: l_tlp_id_list PO_TBL_NUMBER;

4456:
4457: l_language_codes PO_TBL_NUMBER;
4458: l_tlp_row PO_ATTRIBUTE_VALUES_TLP%rowtype;
4459: l_po_line_id_list PO_TBL_NUMBER;
4460: l_tlp_id_list PO_TBL_NUMBER;
4461: BEGIN
4462: l_progress := '010';
4463:
4464: IF PO_LOG.d_proc THEN