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 124: p_task_tbl IN PO_TBL_VARCHAR2000, --- Bug#16505809

120: PROCEDURE derive_task_id
121: (
122: p_key IN po_session_gt.key%TYPE,
123: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
124: p_task_tbl IN PO_TBL_VARCHAR2000, --- Bug#16505809
125: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
126: p_project_id_tbl IN PO_TBL_NUMBER,
127: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
128: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

Line 2259: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

2255:
2256: l_distributions PO_DISTRIBUTIONS_VAL_TYPE := PO_DISTRIBUTIONS_VAL_TYPE();
2257: l_result_type VARCHAR2(30);
2258: l_results po_validation_results_type;
2259: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2260: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2261:
2262: BEGIN
2263: d_position := 0;

Line 2260: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

2256: l_distributions PO_DISTRIBUTIONS_VAL_TYPE := PO_DISTRIBUTIONS_VAL_TYPE();
2257: l_result_type VARCHAR2(30);
2258: l_results po_validation_results_type;
2259: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2260: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2261:
2262: BEGIN
2263: d_position := 0;
2264:

Line 2616: p_person_name_tbl IN PO_TBL_VARCHAR2000,

2612: PROCEDURE derive_deliver_to_person_id
2613: (
2614: p_key IN po_session_gt.key%TYPE,
2615: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2616: p_person_name_tbl IN PO_TBL_VARCHAR2000,
2617: x_person_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2618: ) IS
2619:
2620: d_api_name CONSTANT VARCHAR2(30) := 'derive_deliver_to_person_id';

Line 2912: p_wip_entity_tbl IN PO_TBL_VARCHAR2000,

2908: PROCEDURE derive_wip_entity_id
2909: (
2910: p_key IN po_session_gt.key%TYPE,
2911: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2912: p_wip_entity_tbl IN PO_TBL_VARCHAR2000,
2913: p_dest_org_id_tbl IN PO_TBL_NUMBER,
2914: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
2915: x_wip_entity_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2916: ) IS

Line 3907: p_task_tbl IN PO_TBL_VARCHAR2000, --- Bug#16505809

3903: PROCEDURE derive_task_id
3904: (
3905: p_key IN po_session_gt.key%TYPE,
3906: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3907: p_task_tbl IN PO_TBL_VARCHAR2000, --- Bug#16505809
3908: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3909: p_project_id_tbl IN PO_TBL_NUMBER,
3910: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
3911: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,