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

Line 24: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,

20: PROCEDURE get_po_header_attr_group_ids(
21: p_template_id IN VARCHAR2,
22: p_po_header_id IN NUMBER,
23: p_is_doc_mod VARCHAR2,
24: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
25: x_return_status OUT NOCOPY VARCHAR2
26: ) IS
27: d_api_name CONSTANT VARCHAR2(30) := 'get_po_header_attr_group_ids';
28: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;

Line 31: l_attr_grp_ids_list PO_TBL_NUMBER;

27: d_api_name CONSTANT VARCHAR2(30) := 'get_po_header_attr_group_ids';
28: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
29: d_progress NUMBER := 0;
30: l_po_uda_usage_object po_uda_usage_object ;
31: l_attr_grp_ids_list PO_TBL_NUMBER;
32: l_x_attr_ids_count NUMBER;
33: l_clm_standard_form PO_HEADERS_ALL.CLM_STANDARD_FORM%TYPE;
34: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
35: l_attr_grp_ids PO_TBL_NUMBER;

Line 35: l_attr_grp_ids PO_TBL_NUMBER;

31: l_attr_grp_ids_list PO_TBL_NUMBER;
32: l_x_attr_ids_count NUMBER;
33: l_clm_standard_form PO_HEADERS_ALL.CLM_STANDARD_FORM%TYPE;
34: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
35: l_attr_grp_ids PO_TBL_NUMBER;
36: t_count NUMBER;
37:
38: cursor c_get_usages(p_template_id number) is
39: select distinct(attribute_category) from po_uda_ag_template_usages

Line 48: l_attr_grp_ids := PO_TBL_NUMBER();

44: PO_LOG.proc_begin(d_module);
45: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
46: END IF;
47:
48: l_attr_grp_ids := PO_TBL_NUMBER();
49:
50: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
51: l_context := NULL;
52:

Line 105: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,

101: p_draft_id IN NUMBER DEFAULT -1,
102: p_is_doc_mod VARCHAR2,
103: p_contract_type IN VARCHAR2,
104: p_clm_idc_type IN VARCHAR2,
105: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
106: x_return_status OUT NOCOPY VARCHAR2
107: ) IS
108: d_api_name CONSTANT VARCHAR2(30) := 'get_po_line_attr_group_ids';
109: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;

Line 114: l_attr_grp_ids_list PO_TBL_NUMBER;

110: d_progress NUMBER := 0;
111:
112: l_po_uda_usage_object po_uda_usage_object ;
113: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
114: l_attr_grp_ids_list PO_TBL_NUMBER;
115: l_contract_type PO_LINES_ALL.CONTRACT_TYPE%TYPE;
116: l_clm_idc_type PO_LINES_ALL.CLM_IDC_TYPE%TYPE;
117: l_x_attr_ids_count NUMBER;
118: l_attr_grp_ids PO_TBL_NUMBER;

Line 118: l_attr_grp_ids PO_TBL_NUMBER;

114: l_attr_grp_ids_list PO_TBL_NUMBER;
115: l_contract_type PO_LINES_ALL.CONTRACT_TYPE%TYPE;
116: l_clm_idc_type PO_LINES_ALL.CLM_IDC_TYPE%TYPE;
117: l_x_attr_ids_count NUMBER;
118: l_attr_grp_ids PO_TBL_NUMBER;
119: t_count NUMBER;
120: l_count NUMBER;
121:
122: CURSOR c_get_usages(p_template_id NUMBER) IS

Line 133: l_attr_grp_ids := PO_TBL_NUMBER();

129: PO_LOG.proc_begin(d_module);
130: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
131: END IF;
132:
133: l_attr_grp_ids := PO_TBL_NUMBER();
134:
135: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
136:
137: l_context := NULL;

Line 218: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,

214: PROCEDURE get_po_line_loc_attr_group_ids(
215: p_template_id IN VARCHAR2,
216: p_po_line_location_id IN NUMBER,
217: p_is_doc_mod VARCHAR2,
218: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
219: x_return_status OUT NOCOPY VARCHAR2
220: ) IS
221:
222: d_api_name CONSTANT VARCHAR2(30) := 'get_po_line_loc_attr_group_ids';

Line 226: l_attr_grp_ids_list PO_TBL_NUMBER;

222: d_api_name CONSTANT VARCHAR2(30) := 'get_po_line_loc_attr_group_ids';
223: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
224: d_progress NUMBER := 0;
225: l_po_uda_usage_object po_uda_usage_object ;
226: l_attr_grp_ids_list PO_TBL_NUMBER;
227: l_x_attr_ids_count NUMBER;
228: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
229: l_attr_grp_ids PO_TBL_NUMBER;
230: t_count NUMBER;

Line 229: l_attr_grp_ids PO_TBL_NUMBER;

225: l_po_uda_usage_object po_uda_usage_object ;
226: l_attr_grp_ids_list PO_TBL_NUMBER;
227: l_x_attr_ids_count NUMBER;
228: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
229: l_attr_grp_ids PO_TBL_NUMBER;
230: t_count NUMBER;
231:
232: CURSOR c_get_usages(p_template_id NUMBER) IS
233: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages

Line 242: l_attr_grp_ids := PO_TBL_NUMBER();

238: PO_LOG.proc_begin(d_module);
239: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
240: END IF;
241:
242: l_attr_grp_ids := PO_TBL_NUMBER();
243:
244: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
245: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN
246: IF PO_LOG.d_stmt THEN

Line 497: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,

493:
494: PROCEDURE get_ext_param_xle_actions_ags(
495: p_template_id IN VARCHAR2,
496: p_external_param IN VARCHAR2,
497: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
498: x_return_status OUT NOCOPY VARCHAR2
499: ) IS
500:
501:

Line 505: l_attr_grp_ids PO_TBL_NUMBER;

501:
502: d_api_name CONSTANT VARCHAR2(30) := 'get_ext_param_xle_actions_ags';
503: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
504: d_progress NUMBER := 0;
505: l_attr_grp_ids PO_TBL_NUMBER;
506:
507: CURSOR c_get_attr_ids(p_template_id VARCHAR2) IS
508: SELECT ACT.ATTR_GROUP_ID
509: FROM EGO_ACTION_DISPLAYS_B EAD, EGO_ACTIONS_b ACT ,EGO_MAPPINGS_B B

Line 523: l_attr_grp_ids := PO_TBL_NUMBER();

519: PO_LOG.proc_begin(d_module);
520: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
521: END IF;
522:
523: l_attr_grp_ids := PO_TBL_NUMBER();
524:
525: FOR c_get_attr_ids_rec IN c_get_attr_ids(p_template_id) LOOP
526: l_attr_grp_ids.extend(1);
527: l_attr_grp_ids(l_attr_grp_ids.Count) := c_get_attr_ids_rec.ATTR_GROUP_ID;

Line 549: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,

545:
546: PROCEDURE get_ext_param_xd_actions_ags(
547: p_template_id IN VARCHAR2,
548: p_external_param IN VARCHAR2,
549: x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
550: x_return_status OUT NOCOPY VARCHAR2
551: ) IS
552:
553:

Line 557: l_attr_grp_ids PO_TBL_NUMBER;

553:
554: d_api_name CONSTANT VARCHAR2(30) := 'get_ext_param_xd_actions_ags';
555: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
556: d_progress NUMBER := 0;
557: l_attr_grp_ids PO_TBL_NUMBER;
558:
559: CURSOR c_get_attr_ids(p_template_id VARCHAR2) IS
560: SELECT ACT.ATTR_GROUP_ID
561: FROM EGO_ACTION_DISPLAYS_B EAD, EGO_ACTIONS_b ACT ,EGO_MAPPINGS_B B

Line 575: l_attr_grp_ids := PO_TBL_NUMBER();

571: PO_LOG.proc_begin(d_module);
572: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
573: END IF;
574:
575: l_attr_grp_ids := PO_TBL_NUMBER();
576:
577: FOR c_get_attr_ids_rec IN c_get_attr_ids(p_template_id) LOOP
578: l_attr_grp_ids.extend(1);
579: l_attr_grp_ids(l_attr_grp_ids.Count) := c_get_attr_ids_rec.ATTR_GROUP_ID;