APPS.PO_UDA_AUTOCREATE_PKG dependencies on PO_TBL_NUMBER

Line 36: p_attr_group_id_tbl IN po_tbl_number

32: p_pk1_col_name IN VARCHAR2,
33: p_pk1_col_value IN VARCHAR2,
34: p_pk2_col_name IN VARCHAR2,
35: p_pk2_col_value IN VARCHAR2,
36: p_attr_group_id_tbl IN po_tbl_number
37: );
38:
39: PROCEDURE auto_complexpricing_ag;
40:

Line 670: l_doc_primary_key PO_TBL_NUMBER;

666:
667: l_ag_type VARCHAR2(400);
668: l_tbl_name VARCHAR2(200);
669:
670: l_doc_primary_key PO_TBL_NUMBER;
671:
672: l_pkey_col_name VARCHAR2(200);
673: l_src_table_name VARCHAR2(200);
674: BEGIN

Line 1341: x_source_pkey_tbl po_tbl_number;

1337: IS
1338: l_api_name VARCHAR2(30) := 'autocreate_attr_group';
1339: l_progress VARCHAR2(3) := '000';
1340:
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;

Line 1342: x_target_pkey_tbl po_tbl_number;

1338: l_api_name VARCHAR2(30) := 'autocreate_attr_group';
1339: l_progress VARCHAR2(3) := '000';
1340:
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);

Line 1343: x_pkey_tbl po_tbl_number;

1339: l_progress VARCHAR2(3) := '000';
1340:
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;

Line 2072: l_attr_grp_ids_list po_tbl_NUMBER;

2068: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2069:
2070: l_address_lookup_type varchar2(100);
2071:
2072: l_attr_grp_ids_list po_tbl_NUMBER;
2073:
2074: l_row_identifier NUMBER;
2075:
2076: l_attr_group_type VARCHAR2(100) := 'PO_HEADER_EXT_ATTRS';

Line 2561: x_attr_group_id_tbl OUT NOCOPY po_tbl_number

2557: END process_addresses;
2558:
2559: /* Bug 12611018 : New proceduree written to get the group_id_tbl*/
2560: PROCEDURE get_group_id_tbl(p_level IN VARCHAR2,
2561: x_attr_group_id_tbl OUT NOCOPY po_tbl_number
2562: )
2563: IS
2564:
2565: l_api_name VARCHAR2(30) := 'get_group_id_tbl';

Line 2721: x_attr_group_id_tbl po_tbl_number;

2717: IS
2718: l_api_name VARCHAR2(30) := 'autocreate_uda_postprocess';
2719: l_progress VARCHAR2(3) := '000';
2720:
2721: x_attr_group_id_tbl po_tbl_number;
2722:
2723: CURSOR c_lines
2724: IS
2725: SELECT pld.po_line_id

Line 2839: p_attr_group_id_tbl IN po_tbl_number

2835: p_pk1_col_name IN VARCHAR2,
2836: p_pk1_col_value IN VARCHAR2,
2837: p_pk2_col_name IN VARCHAR2,
2838: p_pk2_col_value IN VARCHAR2,
2839: p_attr_group_id_tbl IN po_tbl_number
2840: )
2841: IS
2842:
2843: l_api_name VARCHAR2(30) := 'exec_uda_function';

Line 3202: x_source_pkey_tbl po_tbl_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;
3204: l_data_copied VARCHAR2(1);
3205: x_source_doc_level VARCHAR2(10);
3206: x_group_type VARCHAR2(120);

Line 3203: x_target_pkey_tbl po_tbl_number;

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;
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);