DBA Data[Home] [Help]

APPS.PO_PDOI_DIST_PROCESS_PVT dependencies on PO_TBL_VARCHAR30

Line 42: p_dest_type_tbl IN PO_TBL_VARCHAR30,

38: PROCEDURE derive_dest_type_code
39: (
40: p_key IN po_session_gt.key%TYPE,
41: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
42: p_dest_type_tbl IN PO_TBL_VARCHAR30,
43: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
44: );
45:
46: PROCEDURE derive_dest_org_id

Line 43: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

39: (
40: p_key IN po_session_gt.key%TYPE,
41: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
42: p_dest_type_tbl IN PO_TBL_VARCHAR30,
43: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
44: );
45:
46: PROCEDURE derive_dest_org_id
47: (

Line 61: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

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: );
64:
65: PROCEDURE derive_wip_line_id

Line 69: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,

65: PROCEDURE derive_wip_line_id
66: (
67: p_key IN po_session_gt.key%TYPE,
68: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
69: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,
70: p_dest_org_id_tbl IN PO_TBL_NUMBER,
71: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
72: x_wip_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
73: );

Line 71: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

67: p_key IN po_session_gt.key%TYPE,
68: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
69: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,
70: p_dest_org_id_tbl IN PO_TBL_NUMBER,
71: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
72: x_wip_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
73: );
74:
75: PROCEDURE derive_ship_to_ou_coa_id

Line 89: p_bom_resource_code_tbl IN PO_TBL_VARCHAR30,

85: PROCEDURE derive_bom_resource_id
86: (
87: p_key IN po_session_gt.key%TYPE,
88: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
89: p_bom_resource_code_tbl IN PO_TBL_VARCHAR30,
90: p_dest_org_id_tbl IN PO_TBL_NUMBER,
91: x_bom_resource_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
92: );
93:

Line 112: p_project_tbl IN PO_TBL_VARCHAR30,

108: PROCEDURE derive_project_id
109: (
110: p_key IN po_session_gt.key%TYPE,
111: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
112: p_project_tbl IN PO_TBL_VARCHAR30,
113: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
114: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
115: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
116: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

Line 113: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

109: (
110: p_key IN po_session_gt.key%TYPE,
111: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
112: p_project_tbl IN PO_TBL_VARCHAR30,
113: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
114: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
115: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
116: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
117: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 125: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

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,
129: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 139: x_expenditure_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

135: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
136: p_expenditure_tbl IN PO_TBL_VARCHAR100,
137: p_project_id_tbl IN PO_TBL_NUMBER,
138: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
139: x_expenditure_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
140: );
141:
142: PROCEDURE derive_expenditure_org_id
143: (

Line 2707: p_dest_type_tbl IN PO_TBL_VARCHAR30,

2703: PROCEDURE derive_dest_type_code
2704: (
2705: p_key IN po_session_gt.key%TYPE,
2706: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2707: p_dest_type_tbl IN PO_TBL_VARCHAR30,
2708: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2709: ) IS
2710:
2711: d_api_name CONSTANT VARCHAR2(30) := 'derive_dest_type_code';

Line 2708: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

2704: (
2705: p_key IN po_session_gt.key%TYPE,
2706: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2707: p_dest_type_tbl IN PO_TBL_VARCHAR30,
2708: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2709: ) IS
2710:
2711: d_api_name CONSTANT VARCHAR2(30) := 'derive_dest_type_code';
2712: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2914: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

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
2917:
2918: d_api_name CONSTANT VARCHAR2(30) := 'derive_wip_entity_id';

Line 3013: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,

3009: PROCEDURE derive_wip_line_id
3010: (
3011: p_key IN po_session_gt.key%TYPE,
3012: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3013: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,
3014: p_dest_org_id_tbl IN PO_TBL_NUMBER,
3015: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3016: x_wip_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3017: ) IS

Line 3015: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

3011: p_key IN po_session_gt.key%TYPE,
3012: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3013: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,
3014: p_dest_org_id_tbl IN PO_TBL_NUMBER,
3015: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3016: x_wip_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3017: ) IS
3018:
3019: d_api_name CONSTANT VARCHAR2(30) := 'derive_wip_line_id';

Line 3218: p_bom_resource_code_tbl IN PO_TBL_VARCHAR30,

3214: PROCEDURE derive_bom_resource_id
3215: (
3216: p_key IN po_session_gt.key%TYPE,
3217: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3218: p_bom_resource_code_tbl IN PO_TBL_VARCHAR30,
3219: p_dest_org_id_tbl IN PO_TBL_NUMBER,
3220: x_bom_resource_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3221: ) IS
3222:

Line 3784: p_project_tbl IN PO_TBL_VARCHAR30,

3780: PROCEDURE derive_project_id
3781: (
3782: p_key IN po_session_gt.key%TYPE,
3783: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3784: p_project_tbl IN PO_TBL_VARCHAR30,
3785: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3786: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3787: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
3788: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

Line 3785: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

3781: (
3782: p_key IN po_session_gt.key%TYPE,
3783: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3784: p_project_tbl IN PO_TBL_VARCHAR30,
3785: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3786: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3787: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
3788: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3789: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 3908: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

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,
3912: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 4030: x_expenditure_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

4026: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4027: p_expenditure_tbl IN PO_TBL_VARCHAR100,
4028: p_project_id_tbl IN PO_TBL_NUMBER,
4029: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
4030: x_expenditure_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
4031: ) IS
4032:
4033: d_api_name CONSTANT VARCHAR2(30) := 'derive_expenditure_type';
4034: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4039: l_result_tbl PO_TBL_VARCHAR30;

4035: d_position NUMBER;
4036:
4037: -- variable to hold derived result
4038: l_index_tbl PO_TBL_NUMBER;
4039: l_result_tbl PO_TBL_VARCHAR30;
4040: BEGIN
4041: d_position := 0;
4042:
4043: IF (PO_LOG.d_proc) THEN