APPS.POR_UDA_PKG dependencies on PO_TBL_NUMBER

Line 10: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,

6: PROCEDURE get_pr_line_attr_group_ids(
7: p_template_id IN VARCHAR2,
8: p_req_line_id IN NUMBER,
9: p_is_amd_mode VARCHAR2,
10: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
11: x_return_status OUT NOCOPY VARCHAR2
12: ) IS
13:
14: d_api_name CONSTANT VARCHAR2(30) := 'get_pr_line_attr_group_ids';

Line 20: l_attr_grp_ids_list PO_TBL_NUMBER;

16: d_progress NUMBER := 0;
17:
18: l_po_uda_usage_object po_uda_usage_object ;
19: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
20: l_attr_grp_ids_list PO_TBL_NUMBER;
21: l_contract_type VARCHAR2(250);
22: l_x_attr_ids_count NUMBER;
23: l_attr_grp_ids PO_TBL_NUMBER;
24: t_count NUMBER;

Line 23: l_attr_grp_ids PO_TBL_NUMBER;

19: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
20: l_attr_grp_ids_list PO_TBL_NUMBER;
21: l_contract_type VARCHAR2(250);
22: l_x_attr_ids_count NUMBER;
23: l_attr_grp_ids PO_TBL_NUMBER;
24: t_count NUMBER;
25: l_count NUMBER;
26:
27: CURSOR c_get_usages(p_template_id NUMBER) IS

Line 43: l_attr_grp_ids := PO_TBL_NUMBER();

39: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
40: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_req_line_id);
41: END IF;
42:
43: l_attr_grp_ids := PO_TBL_NUMBER();
44: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();
45:
46: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
47:

Line 580: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,

576: PROCEDURE get_pr_header_attr_group_ids(
577: p_template_id IN VARCHAR2,
578: p_req_header_id IN NUMBER,
579: p_is_amd_mode VARCHAR2,
580: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
581: x_return_status OUT NOCOPY VARCHAR2
582: )IS
583:
584: d_api_name CONSTANT VARCHAR2(30) := 'get_pr_header_attr_group_ids';

Line 589: l_attr_grp_ids_list PO_TBL_NUMBER;

585: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
586: d_progress NUMBER := 0;
587:
588: l_po_uda_usage_object po_uda_usage_object ;
589: l_attr_grp_ids_list PO_TBL_NUMBER;
590: l_x_attr_ids_count NUMBER;
591: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
592: l_attr_grp_ids PO_TBL_NUMBER;
593: t_count NUMBER;

Line 592: l_attr_grp_ids PO_TBL_NUMBER;

588: l_po_uda_usage_object po_uda_usage_object ;
589: l_attr_grp_ids_list PO_TBL_NUMBER;
590: l_x_attr_ids_count NUMBER;
591: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
592: l_attr_grp_ids PO_TBL_NUMBER;
593: t_count NUMBER;
594:
595: CURSOR c_get_usages(p_template_id NUMBER) IS
596: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages

Line 605: l_attr_grp_ids := PO_TBL_NUMBER();

601: PO_LOG.proc_begin(d_module);
602: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
603: END IF;
604:
605: l_attr_grp_ids := PO_TBL_NUMBER();
606: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();
607:
608: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
609: IF(p_is_amd_mode = 'true' AND c_get_usages_rec.attribute_category = 'CHAIN') THEN

Line 1016: l_attr_grp_ids_list PO_TBL_NUMBER;

1012: l_line_type_id NUMBER;
1013: l_contract_line_type VARCHAR2(100);
1014: l_item_id NUMBER;
1015: l_deliver_to_location_id NUMBER;
1016: l_attr_grp_ids_list PO_TBL_NUMBER;
1017:
1018: l_return_status VARCHAR2(2);
1019: l_errorcode NUMBER;
1020: l_msg_count NUMBER;