DBA Data[Home] [Help]

APPS.PO_PDOI_DIST_PROCESS_PVT dependencies on PO_TBL_VARCHAR2000

Line 34: p_person_name_tbl IN PO_TBL_VARCHAR2000,

30: PROCEDURE derive_deliver_to_person_id
31: (
32: p_key IN po_session_gt.key%TYPE,
33: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
34: p_person_name_tbl IN PO_TBL_VARCHAR2000,
35: x_person_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
36: );
37:
38: PROCEDURE derive_dest_type_code

Line 59: p_wip_entity_tbl IN PO_TBL_VARCHAR2000,

55: PROCEDURE derive_wip_entity_id
56: (
57: p_key IN po_session_gt.key%TYPE,
58: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
59: p_wip_entity_tbl IN PO_TBL_VARCHAR2000,
60: p_dest_org_id_tbl IN PO_TBL_NUMBER,
61: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
62: x_wip_entity_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
63: );

Line 2127: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

2123:
2124: l_distributions PO_DISTRIBUTIONS_VAL_TYPE := PO_DISTRIBUTIONS_VAL_TYPE();
2125: l_result_type VARCHAR2(30);
2126: l_results po_validation_results_type;
2127: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2128: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2129:
2130: BEGIN
2131: d_position := 0;

Line 2128: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

2124: l_distributions PO_DISTRIBUTIONS_VAL_TYPE := PO_DISTRIBUTIONS_VAL_TYPE();
2125: l_result_type VARCHAR2(30);
2126: l_results po_validation_results_type;
2127: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2128: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2129:
2130: BEGIN
2131: d_position := 0;
2132:

Line 2468: p_person_name_tbl IN PO_TBL_VARCHAR2000,

2464: PROCEDURE derive_deliver_to_person_id
2465: (
2466: p_key IN po_session_gt.key%TYPE,
2467: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2468: p_person_name_tbl IN PO_TBL_VARCHAR2000,
2469: x_person_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2470: ) IS
2471:
2472: d_api_name CONSTANT VARCHAR2(30) := 'derive_deliver_to_person_id';

Line 2764: p_wip_entity_tbl IN PO_TBL_VARCHAR2000,

2760: PROCEDURE derive_wip_entity_id
2761: (
2762: p_key IN po_session_gt.key%TYPE,
2763: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2764: p_wip_entity_tbl IN PO_TBL_VARCHAR2000,
2765: p_dest_org_id_tbl IN PO_TBL_NUMBER,
2766: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
2767: x_wip_entity_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2768: ) IS