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.

[Home] [Help]

APPS.PO_UDA_AUTOCREATE_PKG dependencies on PO_TBL_VARCHAR3

Line 187: x_attr_group_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

183: END get_uda_template_id;
184:
185:
186: PROCEDURE get_attribute_groups(p_uda_template_id IN NUMBER,
187: x_attr_group_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
188: )
189: IS
190: l_api_name VARCHAR2(30) := 'get_attribute_groups';
191: l_progress VARCHAR2(3) := '000';

Line 196: l_attr_group_tbl PO_TBL_VARCHAR30;

192:
193:
194: l_return_status VARCHAR2(1);
195: l_err_msg VARCHAR2(1000);
196: l_attr_group_tbl PO_TBL_VARCHAR30;
197:
198: BEGIN
199: IF g_debug_stmt THEN
200: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

Line 240: x_priorities_tbl OUT NOCOPY PO_TBL_VARCHAR3,

236: p_src_doc_type IN VARCHAR2,
237: p_tar_doc_type IN VARCHAR2,
238: p_group_property IN VARCHAR2,
239: x_source_doc_level OUT NOCOPY VARCHAR2,
240: x_priorities_tbl OUT NOCOPY PO_TBL_VARCHAR3,
241: x_group_type OUT NOCOPY VARCHAR2
242: )
243: /* Query our newly created Rules Table */
244: IS

Line 251: l_priorities_tbl PO_TBL_VARCHAR3;

247:
248:
249: l_return_status VARCHAR2(1);
250: l_err_msg VARCHAR2(1000);
251: l_priorities_tbl PO_TBL_VARCHAR3;
252:
253: l_priority VARCHAR2(4);
254:
255: BEGIN

Line 272: x_priorities_tbl := PO_TBL_VARCHAR3();

268: );
269: END IF;
270:
271:
272: x_priorities_tbl := PO_TBL_VARCHAR3();
273: l_priorities_tbl := PO_TBL_VARCHAR3(); --bug 12611018
274: l_priorities_tbl.extend(5); --bug 12611018
275:
276: BEGIN

Line 273: l_priorities_tbl := PO_TBL_VARCHAR3(); --bug 12611018

269: END IF;
270:
271:
272: x_priorities_tbl := PO_TBL_VARCHAR3();
273: l_priorities_tbl := PO_TBL_VARCHAR3(); --bug 12611018
274: l_priorities_tbl.extend(5); --bug 12611018
275:
276: BEGIN
277:

Line 382: x_group_property_tbl OUT NOCOPY PO_TBL_VARCHAR30

378: PROCEDURE get_autocreate_properties(p_doc_level IN VARCHAR2,
379: p_attr_group IN VARCHAR2,
380: p_src_doc_type IN VARCHAR2,
381: p_tar_doc_type IN VARCHAR2,
382: x_group_property_tbl OUT NOCOPY PO_TBL_VARCHAR30
383: )
384: /* Query our newly created Rules Table */
385: IS
386: l_api_name VARCHAR2(30) := 'get_autocreate_properties';

Line 392: l_priorities_tbl PO_TBL_VARCHAR3;

388:
389:
390: l_return_status VARCHAR2(1);
391: l_err_msg VARCHAR2(1000);
392: l_priorities_tbl PO_TBL_VARCHAR3;
393:
394: l_priority VARCHAR2(4);
395:
396: BEGIN

Line 1334: ,p_priorities_tbl IN PO_TBL_VARCHAR3

1330: ,p_intf_line_id IN NUMBER
1331: ,p_attr_group IN VARCHAR2
1332: ,p_to_pk1_col_name IN VARCHAR2
1333: ,p_to_pk1_value IN NUMBER
1334: ,p_priorities_tbl IN PO_TBL_VARCHAR3
1335: )
1336:
1337: IS
1338: l_api_name VARCHAR2(30) := 'autocreate_attr_group';

Line 1345: l_attr_group_tbl po_tbl_varchar30;

1341: x_source_pkey_tbl po_tbl_number;
1342: x_target_pkey_tbl po_tbl_number;
1343: x_pkey_tbl po_tbl_number;
1344:
1345: l_attr_group_tbl po_tbl_varchar30;
1346: x_return_status VARCHAR2(1);
1347: x_msg_count NUMBER;
1348: x_msg_data VARCHAR2(2000);
1349:

Line 1545: ,p_priorities_tbl IN PO_TBL_VARCHAR3

1541:
1542:
1543: PROCEDURE autocreate_ag_header (p_src_doc_level IN VARCHAR2
1544: ,p_attr_group IN VARCHAR2
1545: ,p_priorities_tbl IN PO_TBL_VARCHAR3
1546: ,p_group_type IN VARCHAR2
1547: ,p_group_property IN VARCHAR2
1548: )
1549: IS

Line 1586: ,p_priorities_tbl IN PO_TBL_VARCHAR3

1582:
1583:
1584: PROCEDURE autocreate_ag_lines(p_src_doc_level IN VARCHAR2
1585: ,p_attr_group IN VARCHAR2
1586: ,p_priorities_tbl IN PO_TBL_VARCHAR3
1587: ,p_group_type IN VARCHAR2
1588: ,p_group_property IN VARCHAR2
1589: )
1590: IS

Line 1649: ,p_priorities_tbl IN PO_TBL_VARCHAR3

1645:
1646:
1647: PROCEDURE autocreate_ag_shipments(p_src_doc_level IN VARCHAR2
1648: ,p_attr_group IN VARCHAR2
1649: ,p_priorities_tbl IN PO_TBL_VARCHAR3
1650: ,p_group_type IN VARCHAR2
1651: ,p_group_property IN VARCHAR2
1652: )
1653: IS

Line 1726: ,p_priorities_tbl IN PO_TBL_VARCHAR3

1722:
1723: PROCEDURE autocreate_ag_level ( p_doc_level IN VARCHAR2
1724: ,p_src_doc_level IN VARCHAR2
1725: ,p_attr_group IN VARCHAR2
1726: ,p_priorities_tbl IN PO_TBL_VARCHAR3
1727: ,p_group_type IN VARCHAR2
1728: ,p_group_property IN VARCHAR2
1729: )
1730: IS

Line 1835: l_attr_group_tbl PO_TBL_VARCHAR30;

1831: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1832: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1833:
1834: l_to_pk1_value NUMBER;
1835: l_attr_group_tbl PO_TBL_VARCHAR30;
1836:
1837: x_return_status VARCHAR2(1);
1838: x_msg_count NUMBER;
1839: x_msg_data VARCHAR2(1000);

Line 3198: x_attr_group_tbl po_tbl_varchar30;

3194:
3195: x_doc_level_tbl po_tbl_varchar15;
3196:
3197: l_uda_template_id NUMBER;
3198: x_attr_group_tbl po_tbl_varchar30;
3199: x_priorities_tbl PO_TBL_VARCHAR3;
3200: l_ag_type VARCHAR2(300);
3201: l_tbl_name varchar2(100);
3202: x_source_pkey_tbl po_tbl_number;

Line 3199: x_priorities_tbl PO_TBL_VARCHAR3;

3195: x_doc_level_tbl po_tbl_varchar15;
3196:
3197: l_uda_template_id NUMBER;
3198: x_attr_group_tbl po_tbl_varchar30;
3199: x_priorities_tbl PO_TBL_VARCHAR3;
3200: l_ag_type VARCHAR2(300);
3201: l_tbl_name varchar2(100);
3202: x_source_pkey_tbl po_tbl_number;
3203: x_target_pkey_tbl po_tbl_number;

Line 3208: x_group_property_tbl PO_TBL_VARCHAR30;

3204: l_data_copied VARCHAR2(1);
3205: x_source_doc_level VARCHAR2(10);
3206: x_group_type VARCHAR2(120);
3207: x_group_property VARCHAR2(120);
3208: x_group_property_tbl PO_TBL_VARCHAR30;
3209: l_authorization_status po_headers_all.AUTHORIZATION_STATUS%TYPE; /*bug 12415651*/
3210:
3211:
3212: BEGIN