APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on PO_SESSION_GT

Line 2687: l_key PO_SESSION_GT.key%TYPE;

2683: IS
2684: d_mod CONSTANT VARCHAR2(100) := D_get_translations;
2685: l_progress VARCHAR2(4);
2686:
2687: l_key PO_SESSION_GT.key%TYPE;
2688: l_onetime_item_all_languages FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
2689: BEGIN
2690: l_progress := '010';
2691:

Line 2703: SELECT PO_SESSION_GT_S.nextval

2699:
2700: -- SQL What: Pick a new key from session GT sequence .
2701: -- SQL Why : To get tlp_id's
2702: -- SQL Join: none
2703: SELECT PO_SESSION_GT_S.nextval
2704: INTO l_key
2705: FROM DUAL;
2706:
2707: l_progress := '020';

Line 2713: INSERT INTO PO_SESSION_GT(key,

2709: -- SQL Why : They will be inserted into the TLP table
2710: -- SQL Join: attribute_values_tlp_id, inventory_item_id, org_id, inventory_organization_id, language
2711: -- MANUFACTURER will be populated from the base language only
2712: FORALL i IN 1 .. p_attr_values_tlp_id_list.COUNT
2713: INSERT INTO PO_SESSION_GT(key,
2714: num1,
2715: char1,
2716: char2,
2717: char3 -- Bug7039409: Added for long_description

Line 2758: DELETE FROM PO_SESSION_GT

2754: l_progress := '030';
2755: -- SQL What: Transfer from session GT table to local arrays
2756: -- SQL Why : It will be used to populate the OUT parameters.
2757: -- SQL Join: key
2758: DELETE FROM PO_SESSION_GT
2759: WHERE key = l_key
2760: RETURNING num1, char1, char2, char3
2761: BULK COLLECT INTO
2762: x_tlp_id_to_be_copied_list, -- OUT parameters

Line 2809: l_key PO_SESSION_GT.key%TYPE;

2805: d_mod CONSTANT VARCHAR2(100) := D_get_tlp_ids_for_lines;
2806: l_progress VARCHAR2(4);
2807:
2808: l_attr_values_tlp_id PO_ATTRIBUTE_VALUES_TLP.attribute_values_tlp_id%TYPE;
2809: l_key PO_SESSION_GT.key%TYPE;
2810: BEGIN
2811: l_progress := '010';
2812:
2813: IF PO_LOG.d_proc THEN

Line 2820: SELECT PO_SESSION_GT_S.nextval

2816:
2817: -- SQL What: Pick a new key from session GT sequence .
2818: -- SQL Why : To get tlp_id's
2819: -- SQL Join: none
2820: SELECT PO_SESSION_GT_S.nextval
2821: INTO l_key
2822: FROM DUAL;
2823:
2824: l_progress := '020';

Line 2829: INSERT INTO PO_SESSION_GT(key,

2825: -- SQL What: Get the primary key to the TLP row of the created_language
2826: -- SQL Why : This TLP row will be copied when creating translations
2827: -- SQL Join: po_line_id, po_header_id, language
2828: FORALL i IN 1 .. p_po_line_id_list.COUNT
2829: INSERT INTO PO_SESSION_GT(key,
2830: num1
2831: )
2832: SELECT l_key,
2833: TLP.attribute_values_tlp_id

Line 2847: DELETE FROM PO_SESSION_GT

2843: l_progress := '030';
2844: -- SQL What: Transfer from session GT table to local arrays
2845: -- SQL Why : It will be used to populate the OUT parameters.
2846: -- SQL Join: key
2847: DELETE FROM PO_SESSION_GT
2848: WHERE key = l_key
2849: RETURNING num1
2850: BULK COLLECT INTO x_tlp_id_list; -- OUT parameter
2851: