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.

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 124: p_task_tbl IN PO_TBL_VARCHAR30,

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_VARCHAR30,
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 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_VARCHAR30,
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 2559: p_dest_type_tbl IN PO_TBL_VARCHAR30,

2555: PROCEDURE derive_dest_type_code
2556: (
2557: p_key IN po_session_gt.key%TYPE,
2558: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2559: p_dest_type_tbl IN PO_TBL_VARCHAR30,
2560: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2561: ) IS
2562:
2563: d_api_name CONSTANT VARCHAR2(30) := 'derive_dest_type_code';

Line 2560: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

2556: (
2557: p_key IN po_session_gt.key%TYPE,
2558: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2559: p_dest_type_tbl IN PO_TBL_VARCHAR30,
2560: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2561: ) IS
2562:
2563: d_api_name CONSTANT VARCHAR2(30) := 'derive_dest_type_code';
2564: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2766: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

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

Line 2865: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,

2861: PROCEDURE derive_wip_line_id
2862: (
2863: p_key IN po_session_gt.key%TYPE,
2864: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2865: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,
2866: p_dest_org_id_tbl IN PO_TBL_NUMBER,
2867: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
2868: x_wip_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2869: ) IS

Line 2867: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

2863: p_key IN po_session_gt.key%TYPE,
2864: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2865: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,
2866: p_dest_org_id_tbl IN PO_TBL_NUMBER,
2867: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
2868: x_wip_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2869: ) IS
2870:
2871: d_api_name CONSTANT VARCHAR2(30) := 'derive_wip_line_id';

Line 3070: p_bom_resource_code_tbl IN PO_TBL_VARCHAR30,

3066: PROCEDURE derive_bom_resource_id
3067: (
3068: p_key IN po_session_gt.key%TYPE,
3069: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3070: p_bom_resource_code_tbl IN PO_TBL_VARCHAR30,
3071: p_dest_org_id_tbl IN PO_TBL_NUMBER,
3072: x_bom_resource_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3073: ) IS
3074:

Line 3630: p_project_tbl IN PO_TBL_VARCHAR30,

3626: PROCEDURE derive_project_id
3627: (
3628: p_key IN po_session_gt.key%TYPE,
3629: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3630: p_project_tbl IN PO_TBL_VARCHAR30,
3631: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3632: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3633: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
3634: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

Line 3631: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

3627: (
3628: p_key IN po_session_gt.key%TYPE,
3629: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3630: p_project_tbl IN PO_TBL_VARCHAR30,
3631: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3632: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3633: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
3634: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3635: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 3753: p_task_tbl IN PO_TBL_VARCHAR30,

3749: PROCEDURE derive_task_id
3750: (
3751: p_key IN po_session_gt.key%TYPE,
3752: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3753: p_task_tbl IN PO_TBL_VARCHAR30,
3754: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3755: p_project_id_tbl IN PO_TBL_NUMBER,
3756: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
3757: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

Line 3754: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

3750: (
3751: p_key IN po_session_gt.key%TYPE,
3752: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3753: p_task_tbl IN PO_TBL_VARCHAR30,
3754: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3755: p_project_id_tbl IN PO_TBL_NUMBER,
3756: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
3757: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3758: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 3876: x_expenditure_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

3872: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3873: p_expenditure_tbl IN PO_TBL_VARCHAR100,
3874: p_project_id_tbl IN PO_TBL_NUMBER,
3875: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3876: x_expenditure_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
3877: ) IS
3878:
3879: d_api_name CONSTANT VARCHAR2(30) := 'derive_expenditure_type';
3880: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3885: l_result_tbl PO_TBL_VARCHAR30;

3881: d_position NUMBER;
3882:
3883: -- variable to hold derived result
3884: l_index_tbl PO_TBL_NUMBER;
3885: l_result_tbl PO_TBL_VARCHAR30;
3886: BEGIN
3887: d_position := 0;
3888:
3889: IF (PO_LOG.d_proc) THEN