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_UDA_DATA_UTIL dependencies on PO_TBL_NUMBER

Line 669: ,x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER

665: PROCEDURE GET_ATTR_OR_PAGE_ID
666: (
667: p_sql_str IN VARCHAR2
668: ,p_template_id IN VARCHAR2
669: ,x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER
670: ,x_type OUT NOCOPY VARCHAR2
671: ,x_id OUT NOCOPY NUMBER
672: ,x_found_status OUT NOCOPY VARCHAR2
673: )

Line 704: x_attr_grp_ids := PO_TBL_NUMBER();

700: v_query_hdl2 := DBMS_SQL.open_cursor;
701: DBMS_SQL.parse(v_query_hdl2, p_sql_str, DBMS_SQL.native);
702: DBMS_SQL.define_column(v_query_hdl2, 1, v_attr_group_id);
703: v_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl2);
704: x_attr_grp_ids := PO_TBL_NUMBER();
705:
706: d_progress := 20;
707:
708: IF PO_LOG.d_stmt THEN

Line 1874: l_attr_grp_ids_tbl po_tbl_NUMBER;

1870: l_where_ag_sql VARCHAR2(2000) := '';
1871: l_from_where_pk_sql VARCHAR2(2000);
1872: l_to_where_pk_sql VARCHAR2(2000);
1873: l_attr_group_id NUMBER;
1874: l_attr_grp_ids_tbl po_tbl_NUMBER;
1875: l_attr_grp_ids_list VARCHAR2(1000) := '';
1876: l_get_attr_list_sql VARCHAR2(4000);
1877:
1878: BEGIN

Line 2313: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER

2309: PROCEDURE get_attr_group_ids(
2310: p_object_name IN VARCHAR2,
2311: p_where_clause IN VARCHAR2,
2312: p_attr_grp_type IN VARCHAR2,
2313: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER
2314: ) IS
2315:
2316: TYPE ref_cursor IS REF CURSOR;
2317: c_attr_grp_id ref_cursor;

Line 2336: x_attr_grp_ids := PO_TBL_NUMBER();

2332: OPEN c_count_num FOR count_query;
2333: FETCH c_count_num into l_count;
2334: CLOSE c_count_num;
2335:
2336: x_attr_grp_ids := PO_TBL_NUMBER();
2337: x_attr_grp_ids.extend(l_count);
2338:
2339: OPEN c_attr_grp_id FOR (query);
2340:

Line 2769: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,

2765: PROCEDURE get_po_header_attr_group_ids(
2766: p_template_id IN VARCHAR2,
2767: p_po_header_id IN NUMBER,
2768: p_is_doc_mod VARCHAR2,
2769: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
2770: x_return_status OUT NOCOPY VARCHAR2
2771: ) IS
2772: d_api_name CONSTANT VARCHAR2(30) := 'get_po_header_attr_group_ids';
2773: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;

Line 2776: l_attr_grp_ids_list PO_TBL_NUMBER;

2772: d_api_name CONSTANT VARCHAR2(30) := 'get_po_header_attr_group_ids';
2773: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
2774: d_progress NUMBER := 0;
2775: l_po_uda_usage_object po_uda_usage_object ;
2776: l_attr_grp_ids_list PO_TBL_NUMBER;
2777: l_x_attr_ids_count NUMBER;
2778: l_clm_standard_form PO_HEADERS_ALL.CLM_STANDARD_FORM%TYPE;
2779: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
2780: l_attr_grp_ids PO_TBL_NUMBER;

Line 2780: l_attr_grp_ids PO_TBL_NUMBER;

2776: l_attr_grp_ids_list PO_TBL_NUMBER;
2777: l_x_attr_ids_count NUMBER;
2778: l_clm_standard_form PO_HEADERS_ALL.CLM_STANDARD_FORM%TYPE;
2779: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
2780: l_attr_grp_ids PO_TBL_NUMBER;
2781: t_count NUMBER;
2782:
2783: cursor c_get_usages(p_template_id number) is
2784: select distinct(attribute_category) from po_uda_ag_template_usages

Line 2793: l_attr_grp_ids := PO_TBL_NUMBER();

2789: PO_LOG.proc_begin(d_module);
2790: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
2791: END IF;
2792:
2793: l_attr_grp_ids := PO_TBL_NUMBER();
2794:
2795: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
2796: l_context := NULL;
2797:

Line 2844: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,

2840: p_template_id IN VARCHAR2,
2841: p_po_line_id IN NUMBER,
2842: p_draft_id IN NUMBER DEFAULT -1,
2843: p_is_doc_mod VARCHAR2,
2844: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
2845: x_return_status OUT NOCOPY VARCHAR2
2846: ) IS
2847: d_api_name CONSTANT VARCHAR2(30) := 'get_po_line_attr_group_ids';
2848: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;

Line 2853: l_attr_grp_ids_list PO_TBL_NUMBER;

2849: d_progress NUMBER := 0;
2850:
2851: l_po_uda_usage_object po_uda_usage_object ;
2852: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
2853: l_attr_grp_ids_list PO_TBL_NUMBER;
2854: l_contract_type PO_LINES_ALL.CONTRACT_TYPE%TYPE;
2855: l_clm_idc_type PO_LINES_ALL.CLM_IDC_TYPE%TYPE;
2856: l_x_attr_ids_count NUMBER;
2857: l_attr_grp_ids PO_TBL_NUMBER;

Line 2857: l_attr_grp_ids PO_TBL_NUMBER;

2853: l_attr_grp_ids_list PO_TBL_NUMBER;
2854: l_contract_type PO_LINES_ALL.CONTRACT_TYPE%TYPE;
2855: l_clm_idc_type PO_LINES_ALL.CLM_IDC_TYPE%TYPE;
2856: l_x_attr_ids_count NUMBER;
2857: l_attr_grp_ids PO_TBL_NUMBER;
2858: t_count NUMBER;
2859: l_count NUMBER;
2860:
2861: CURSOR c_get_usages(p_template_id NUMBER) IS

Line 2872: l_attr_grp_ids := PO_TBL_NUMBER();

2868: PO_LOG.proc_begin(d_module);
2869: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
2870: END IF;
2871:
2872: l_attr_grp_ids := PO_TBL_NUMBER();
2873:
2874: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
2875:
2876: l_context := NULL;

Line 2934: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,

2930: PROCEDURE get_po_line_loc_attr_group_ids(
2931: p_template_id IN VARCHAR2,
2932: p_po_line_location_id IN NUMBER,
2933: p_is_doc_mod VARCHAR2,
2934: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
2935: x_return_status OUT NOCOPY VARCHAR2
2936: ) IS
2937:
2938: d_api_name CONSTANT VARCHAR2(30) := 'get_po_line_loc_attr_group_ids';

Line 2942: l_attr_grp_ids_list PO_TBL_NUMBER;

2938: d_api_name CONSTANT VARCHAR2(30) := 'get_po_line_loc_attr_group_ids';
2939: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
2940: d_progress NUMBER := 0;
2941: l_po_uda_usage_object po_uda_usage_object ;
2942: l_attr_grp_ids_list PO_TBL_NUMBER;
2943: l_x_attr_ids_count NUMBER;
2944: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
2945: l_attr_grp_ids PO_TBL_NUMBER;
2946: t_count NUMBER;

Line 2945: l_attr_grp_ids PO_TBL_NUMBER;

2941: l_po_uda_usage_object po_uda_usage_object ;
2942: l_attr_grp_ids_list PO_TBL_NUMBER;
2943: l_x_attr_ids_count NUMBER;
2944: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
2945: l_attr_grp_ids PO_TBL_NUMBER;
2946: t_count NUMBER;
2947:
2948: CURSOR c_get_usages(p_template_id NUMBER) IS
2949: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages

Line 2958: l_attr_grp_ids := PO_TBL_NUMBER();

2954: PO_LOG.proc_begin(d_module);
2955: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
2956: END IF;
2957:
2958: l_attr_grp_ids := PO_TBL_NUMBER();
2959:
2960: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
2961: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN
2962: IF PO_LOG.d_stmt THEN

Line 2999: po_dest_line_ids_tbl IN PO_TBL_NUMBER,

2995:
2996: PROCEDURE global_update_line_uda
2997: (
2998: po_src_line_id IN NUMBER ,
2999: po_dest_line_ids_tbl IN PO_TBL_NUMBER,
3000: p_draft_id IN NUMBER
3001: )
3002:
3003: IS

Line 3009: extension_id_tbl PO_TBL_NUMBER;

3005: d_api_name CONSTANT VARCHAR2(30) := 'global_update_line_uda';
3006: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
3007:
3008: po_dest_line_ids VARCHAR2(32000) := '';
3009: extension_id_tbl PO_TBL_NUMBER;
3010: attr_group_id_tbl PO_TBL_NUMBER;
3011: po_line_id_tbl PO_TBL_NUMBER;
3012: data_level_id_tbl PO_TBL_NUMBER;
3013: uda_template_id_tbl PO_TBL_NUMBER;

Line 3010: attr_group_id_tbl PO_TBL_NUMBER;

3006: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
3007:
3008: po_dest_line_ids VARCHAR2(32000) := '';
3009: extension_id_tbl PO_TBL_NUMBER;
3010: attr_group_id_tbl PO_TBL_NUMBER;
3011: po_line_id_tbl PO_TBL_NUMBER;
3012: data_level_id_tbl PO_TBL_NUMBER;
3013: uda_template_id_tbl PO_TBL_NUMBER;
3014: mergeStmt VARCHAR(20000) := '';

Line 3011: po_line_id_tbl PO_TBL_NUMBER;

3007:
3008: po_dest_line_ids VARCHAR2(32000) := '';
3009: extension_id_tbl PO_TBL_NUMBER;
3010: attr_group_id_tbl PO_TBL_NUMBER;
3011: po_line_id_tbl PO_TBL_NUMBER;
3012: data_level_id_tbl PO_TBL_NUMBER;
3013: uda_template_id_tbl PO_TBL_NUMBER;
3014: mergeStmt VARCHAR(20000) := '';
3015: selectStmt VARCHAR(2000) := '';

Line 3012: data_level_id_tbl PO_TBL_NUMBER;

3008: po_dest_line_ids VARCHAR2(32000) := '';
3009: extension_id_tbl PO_TBL_NUMBER;
3010: attr_group_id_tbl PO_TBL_NUMBER;
3011: po_line_id_tbl PO_TBL_NUMBER;
3012: data_level_id_tbl PO_TBL_NUMBER;
3013: uda_template_id_tbl PO_TBL_NUMBER;
3014: mergeStmt VARCHAR(20000) := '';
3015: selectStmt VARCHAR(2000) := '';
3016: d_progress NUMBER := 0;

Line 3013: uda_template_id_tbl PO_TBL_NUMBER;

3009: extension_id_tbl PO_TBL_NUMBER;
3010: attr_group_id_tbl PO_TBL_NUMBER;
3011: po_line_id_tbl PO_TBL_NUMBER;
3012: data_level_id_tbl PO_TBL_NUMBER;
3013: uda_template_id_tbl PO_TBL_NUMBER;
3014: mergeStmt VARCHAR(20000) := '';
3015: selectStmt VARCHAR(2000) := '';
3016: d_progress NUMBER := 0;
3017:

Line 3770: po_dest_line_location_ids_tbl IN PO_TBL_NUMBER,

3766:
3767: PROCEDURE global_update_shipment_uda
3768: (
3769: po_src_line_location_id IN NUMBER ,
3770: po_dest_line_location_ids_tbl IN PO_TBL_NUMBER,
3771: p_draft_id IN NUMBER
3772: )
3773:
3774: IS

Line 3780: extension_id_tbl PO_TBL_NUMBER;

3776: d_api_name CONSTANT VARCHAR2(30) := 'global_update_shipment_uda';
3777: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
3778:
3779: po_dest_line_location_ids VARCHAR2(32000) := '';
3780: extension_id_tbl PO_TBL_NUMBER;
3781: attr_group_id_tbl PO_TBL_NUMBER;
3782: line_location_id_tbl PO_TBL_NUMBER;
3783: data_level_id_tbl PO_TBL_NUMBER;
3784: uda_template_id_tbl PO_TBL_NUMBER;

Line 3781: attr_group_id_tbl PO_TBL_NUMBER;

3777: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
3778:
3779: po_dest_line_location_ids VARCHAR2(32000) := '';
3780: extension_id_tbl PO_TBL_NUMBER;
3781: attr_group_id_tbl PO_TBL_NUMBER;
3782: line_location_id_tbl PO_TBL_NUMBER;
3783: data_level_id_tbl PO_TBL_NUMBER;
3784: uda_template_id_tbl PO_TBL_NUMBER;
3785: l_ship_to_loc_id NUMBER ;

Line 3782: line_location_id_tbl PO_TBL_NUMBER;

3778:
3779: po_dest_line_location_ids VARCHAR2(32000) := '';
3780: extension_id_tbl PO_TBL_NUMBER;
3781: attr_group_id_tbl PO_TBL_NUMBER;
3782: line_location_id_tbl PO_TBL_NUMBER;
3783: data_level_id_tbl PO_TBL_NUMBER;
3784: uda_template_id_tbl PO_TBL_NUMBER;
3785: l_ship_to_loc_id NUMBER ;
3786: get_valid_line_loc_stmt VARCHAR2(32000) := '';

Line 3783: data_level_id_tbl PO_TBL_NUMBER;

3779: po_dest_line_location_ids VARCHAR2(32000) := '';
3780: extension_id_tbl PO_TBL_NUMBER;
3781: attr_group_id_tbl PO_TBL_NUMBER;
3782: line_location_id_tbl PO_TBL_NUMBER;
3783: data_level_id_tbl PO_TBL_NUMBER;
3784: uda_template_id_tbl PO_TBL_NUMBER;
3785: l_ship_to_loc_id NUMBER ;
3786: get_valid_line_loc_stmt VARCHAR2(32000) := '';
3787: get_valid_line_loc_tbl PO_TBL_NUMBER ;

Line 3784: uda_template_id_tbl PO_TBL_NUMBER;

3780: extension_id_tbl PO_TBL_NUMBER;
3781: attr_group_id_tbl PO_TBL_NUMBER;
3782: line_location_id_tbl PO_TBL_NUMBER;
3783: data_level_id_tbl PO_TBL_NUMBER;
3784: uda_template_id_tbl PO_TBL_NUMBER;
3785: l_ship_to_loc_id NUMBER ;
3786: get_valid_line_loc_stmt VARCHAR2(32000) := '';
3787: get_valid_line_loc_tbl PO_TBL_NUMBER ;
3788: mergeStmt VARCHAR(20000) := '';

Line 3787: get_valid_line_loc_tbl PO_TBL_NUMBER ;

3783: data_level_id_tbl PO_TBL_NUMBER;
3784: uda_template_id_tbl PO_TBL_NUMBER;
3785: l_ship_to_loc_id NUMBER ;
3786: get_valid_line_loc_stmt VARCHAR2(32000) := '';
3787: get_valid_line_loc_tbl PO_TBL_NUMBER ;
3788: mergeStmt VARCHAR(20000) := '';
3789: selectStmt VARCHAR(2000) := '';
3790: d_progress NUMBER := 0 ;
3791: