DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_LOC_PROCESS_PVT dependencies on PO_TBL_VARCHAR1

Line 69: x_inspection_required_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1

65: (
66: p_key IN po_session_gt.key%TYPE,
67: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
68: p_item_id_tbl IN PO_TBL_NUMBER,
69: x_inspection_required_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
70: );
71:
72: PROCEDURE default_ship_to_org_id
73: (

Line 106: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,

102: p_key IN po_session_gt.key%TYPE,
103: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
104: p_item_id_tbl IN PO_TBL_NUMBER,
105: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
106: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,
107: x_accrue_on_receipt_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
108: );
109:
110: PROCEDURE default_outsourced_assembly

Line 107: x_accrue_on_receipt_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1

103: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
104: p_item_id_tbl IN PO_TBL_NUMBER,
105: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
106: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,
107: x_accrue_on_receipt_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
108: );
109:
110: PROCEDURE default_outsourced_assembly
111: (

Line 1057: p_error_flag_tbl IN PO_TBL_VARCHAR1

1053: PROCEDURE update_line_loc_interface
1054: (
1055: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
1056: p_line_loc_id_tbl IN PO_TBL_NUMBER,
1057: p_error_flag_tbl IN PO_TBL_VARCHAR1
1058: ) IS
1059:
1060: d_api_name CONSTANT VARCHAR2(30) := 'update_line_loc_interface';
1061: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1188: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

1184: -- variables to hold results from po_session_gt table
1185: l_line_loc_id_tbl PO_TBL_NUMBER;
1186: l_draft_id_tbl PO_TBL_NUMBER;
1187:
1188: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1189: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1190: BEGIN
1191: d_position := 0;
1192:

Line 1189: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

1185: l_line_loc_id_tbl PO_TBL_NUMBER;
1186: l_draft_id_tbl PO_TBL_NUMBER;
1187:
1188: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1189: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1190: BEGIN
1191: d_position := 0;
1192:
1193: IF (PO_LOG.d_proc) THEN

Line 2332: x_inspection_required_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1

2328: (
2329: p_key IN po_session_gt.key%TYPE,
2330: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2331: p_item_id_tbl IN PO_TBL_NUMBER,
2332: x_inspection_required_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
2333: ) IS
2334:
2335: d_api_name CONSTANT VARCHAR2(30) := 'default_inspect_required_flag';
2336: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2341: l_result_tbl PO_TBL_VARCHAR1;

2337: d_position NUMBER;
2338:
2339: -- variable to hold the default query result
2340: l_index_tbl PO_TBL_NUMBER;
2341: l_result_tbl PO_TBL_VARCHAR1;
2342: BEGIN
2343: d_position := 0;
2344:
2345: IF (PO_LOG.d_proc) THEN

Line 2867: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,

2863: p_key IN po_session_gt.key%TYPE,
2864: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2865: p_item_id_tbl IN PO_TBL_NUMBER,
2866: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2867: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,
2868: x_accrue_on_receipt_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
2869: ) IS
2870:
2871: d_api_name CONSTANT VARCHAR2(30) := 'default_accrue_on_receipt_flag';

Line 2868: x_accrue_on_receipt_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1

2864: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2865: p_item_id_tbl IN PO_TBL_NUMBER,
2866: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2867: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,
2868: x_accrue_on_receipt_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
2869: ) IS
2870:
2871: d_api_name CONSTANT VARCHAR2(30) := 'default_accrue_on_receipt_flag';
2872: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2877: l_outside_op_flag_tbl PO_TBL_VARCHAR1;

2873: d_position NUMBER;
2874:
2875: -- variable to hold the default query result
2876: l_index_tbl PO_TBL_NUMBER;
2877: l_outside_op_flag_tbl PO_TBL_VARCHAR1;
2878: l_stock_enabled_flag_tbl PO_TBL_VARCHAR1;
2879:
2880: l_item_status VARCHAR2(1);
2881: l_index NUMBER;

Line 2878: l_stock_enabled_flag_tbl PO_TBL_VARCHAR1;

2874:
2875: -- variable to hold the default query result
2876: l_index_tbl PO_TBL_NUMBER;
2877: l_outside_op_flag_tbl PO_TBL_VARCHAR1;
2878: l_stock_enabled_flag_tbl PO_TBL_VARCHAR1;
2879:
2880: l_item_status VARCHAR2(1);
2881: l_index NUMBER;
2882: BEGIN