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 1160: p_error_flag_tbl IN PO_TBL_VARCHAR1

1156: PROCEDURE update_line_loc_interface
1157: (
1158: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
1159: p_line_loc_id_tbl IN PO_TBL_NUMBER,
1160: p_error_flag_tbl IN PO_TBL_VARCHAR1
1161: ) IS
1162:
1163: d_api_name CONSTANT VARCHAR2(30) := 'update_line_loc_interface';
1164: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1297: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

1293: -- variables to hold results from po_session_gt table
1294: l_line_loc_id_tbl PO_TBL_NUMBER;
1295: l_draft_id_tbl PO_TBL_NUMBER;
1296:
1297: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1298: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1299: BEGIN
1300: d_position := 0;
1301:

Line 1298: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

1294: l_line_loc_id_tbl PO_TBL_NUMBER;
1295: l_draft_id_tbl PO_TBL_NUMBER;
1296:
1297: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1298: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1299: BEGIN
1300: d_position := 0;
1301:
1302: IF (PO_LOG.d_proc) THEN

Line 2523: x_inspection_required_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1

2519: (
2520: p_key IN po_session_gt.key%TYPE,
2521: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2522: p_item_id_tbl IN PO_TBL_NUMBER,
2523: x_inspection_required_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
2524: ) IS
2525:
2526: d_api_name CONSTANT VARCHAR2(30) := 'default_inspect_required_flag';
2527: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2532: l_result_tbl PO_TBL_VARCHAR1;

2528: d_position NUMBER;
2529:
2530: -- variable to hold the default query result
2531: l_index_tbl PO_TBL_NUMBER;
2532: l_result_tbl PO_TBL_VARCHAR1;
2533: BEGIN
2534: d_position := 0;
2535:
2536: IF (PO_LOG.d_proc) THEN

Line 3058: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,

3054: p_key IN po_session_gt.key%TYPE,
3055: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3056: p_item_id_tbl IN PO_TBL_NUMBER,
3057: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3058: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,
3059: x_accrue_on_receipt_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
3060: ) IS
3061:
3062: d_api_name CONSTANT VARCHAR2(30) := 'default_accrue_on_receipt_flag';

Line 3059: x_accrue_on_receipt_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1

3055: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3056: p_item_id_tbl IN PO_TBL_NUMBER,
3057: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3058: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,
3059: x_accrue_on_receipt_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
3060: ) IS
3061:
3062: d_api_name CONSTANT VARCHAR2(30) := 'default_accrue_on_receipt_flag';
3063: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3068: l_outside_op_flag_tbl PO_TBL_VARCHAR1;

3064: d_position NUMBER;
3065:
3066: -- variable to hold the default query result
3067: l_index_tbl PO_TBL_NUMBER;
3068: l_outside_op_flag_tbl PO_TBL_VARCHAR1;
3069: l_stock_enabled_flag_tbl PO_TBL_VARCHAR1;
3070:
3071: l_item_status VARCHAR2(1);
3072: l_index NUMBER;

Line 3069: l_stock_enabled_flag_tbl PO_TBL_VARCHAR1;

3065:
3066: -- variable to hold the default query result
3067: l_index_tbl PO_TBL_NUMBER;
3068: l_outside_op_flag_tbl PO_TBL_VARCHAR1;
3069: l_stock_enabled_flag_tbl PO_TBL_VARCHAR1;
3070:
3071: l_item_status VARCHAR2(1);
3072: l_index NUMBER;
3073: BEGIN