DBA Data[Home] [Help]

APPS.WSH_PR_PICKING_ROWS dependencies on STANDARD

Line 99: u_standard_comp_freeze_date VARCHAR2(15); b_standard_comp_freeze_date VARCHAR2(15);

95: u_shipment_schedule_line_id BINARY_INTEGER; b_shipment_schedule_line_id BINARY_INTEGER;
96: u_unit_code VARCHAR2(3); b_unit_code VARCHAR2(3);
97: u_line_type_code VARCHAR2(30); b_line_type_code VARCHAR2(30);
98: u_component_code VARCHAR2(1000); b_component_code VARCHAR2(1000);
99: u_standard_comp_freeze_date VARCHAR2(15); b_standard_comp_freeze_date VARCHAR2(15);
100: u_order_number BINARY_INTEGER; b_order_number BINARY_INTEGER;
101: u_order_type_id BINARY_INTEGER; b_order_type_id BINARY_INTEGER;
102: u_customer_id BINARY_INTEGER; b_customer_id BINARY_INTEGER;
103: u_invoice_to_site_use_id BINARY_INTEGER; b_invoice_to_site_use_id BINARY_INTEGER;

Line 483: DBMS_SQL.Define_Column(u_cursor, 28, u_standard_comp_freeze_date, 15);

479: DBMS_SQL.Define_Column(u_cursor, 24, u_shipment_schedule_line_id);
480: DBMS_SQL.Define_Column(u_cursor, 25, u_unit_code, 3);
481: DBMS_SQL.Define_Column(u_cursor, 26, u_line_type_code, 30);
482: DBMS_SQL.Define_Column(u_cursor, 27, u_component_code, 1000);
483: DBMS_SQL.Define_Column(u_cursor, 28, u_standard_comp_freeze_date, 15);
484: DBMS_SQL.Define_Column(u_cursor, 29, u_order_number);
485: DBMS_SQL.Define_Column(u_cursor, 30, u_order_type_id);
486: DBMS_SQL.Define_Column(u_cursor, 31, u_customer_id);
487: DBMS_SQL.Define_Column(u_cursor, 32, u_invoice_to_site_use_id);

Line 612: DBMS_SQL.Define_Column(b_cursor, 28, b_standard_comp_freeze_date, 15);

608: DBMS_SQL.Define_Column(b_cursor, 24, b_shipment_schedule_line_id);
609: DBMS_SQL.Define_Column(b_cursor, 25, b_unit_code, 3);
610: DBMS_SQL.Define_Column(b_cursor, 26, b_line_type_code, 30);
611: DBMS_SQL.Define_Column(b_cursor, 27, b_component_code, 1000);
612: DBMS_SQL.Define_Column(b_cursor, 28, b_standard_comp_freeze_date, 15);
613: DBMS_SQL.Define_Column(b_cursor, 29, b_order_number);
614: DBMS_SQL.Define_Column(b_cursor, 30, b_order_type_id);
615: DBMS_SQL.Define_Column(b_cursor, 31, b_customer_id);
616: DBMS_SQL.Define_Column(b_cursor, 32, b_invoice_to_site_use_id);

Line 935: standard_comp_freeze_date OUT cdateTabTyp,

931: shipment_schedule_line_id OUT intTabTyp,
932: unit_code OUT ccodeTabTyp,
933: line_type_code OUT cnameTabTyp,
934: component_code OUT cbufTabTyp,
935: standard_comp_freeze_date OUT cdateTabTyp,
936: order_number OUT intTabTyp,
937: order_type_id OUT intTabTyp,
938: customer_id OUT intTabTyp,
939: invoice_to_site_use_id OUT intTabTyp,

Line 1116: standard_comp_freeze_date(i) := release_table(i).standard_comp_freeze_date;

1112: shipment_schedule_line_id(i) := release_table(i).shipment_schedule_line_id;
1113: unit_code(i) := release_table(i).unit_code;
1114: line_type_code(i) := release_table(i).line_type_code;
1115: component_code(i) := release_table(i).component_code;
1116: standard_comp_freeze_date(i) := release_table(i).standard_comp_freeze_date;
1117: order_number(i) := release_table(i).order_number;
1118: order_type_id(i) := release_table(i).order_type_id;
1119: customer_id(i) := release_table(i).customer_id;
1120: invoice_to_site_use_id(i) := release_table(i).invoice_to_site_use_id;

Line 1379: DBMS_SQL.Column_Value(u_cursor, 28, u_standard_comp_freeze_date);

1375: DBMS_SQL.Column_Value(u_cursor, 24, u_shipment_schedule_line_id);
1376: DBMS_SQL.Column_Value(u_cursor, 25, u_unit_code);
1377: DBMS_SQL.Column_Value(u_cursor, 26, u_line_type_code);
1378: DBMS_SQL.Column_Value(u_cursor, 27, u_component_code);
1379: DBMS_SQL.Column_Value(u_cursor, 28, u_standard_comp_freeze_date);
1380: DBMS_SQL.Column_Value(u_cursor, 29, u_order_number);
1381: DBMS_SQL.Column_Value(u_cursor, 30, u_order_type_id);
1382: DBMS_SQL.Column_Value(u_cursor, 31, u_customer_id);
1383: DBMS_SQL.Column_Value(u_cursor, 32, u_invoice_to_site_use_id);

Line 1418: DBMS_SQL.Column_Value(b_cursor, 28, b_standard_comp_freeze_date);

1414: DBMS_SQL.Column_Value(b_cursor, 24, b_shipment_schedule_line_id);
1415: DBMS_SQL.Column_Value(b_cursor, 25, b_unit_code);
1416: DBMS_SQL.Column_Value(b_cursor, 26, b_line_type_code);
1417: DBMS_SQL.Column_Value(b_cursor, 27, b_component_code);
1418: DBMS_SQL.Column_Value(b_cursor, 28, b_standard_comp_freeze_date);
1419: DBMS_SQL.Column_Value(b_cursor, 29, b_order_number);
1420: DBMS_SQL.Column_Value(b_cursor, 30, b_order_type_id);
1421: DBMS_SQL.Column_Value(b_cursor, 31, b_customer_id);
1422: DBMS_SQL.Column_Value(b_cursor, 32, b_invoice_to_site_use_id);

Line 1526: release_table(current_line).standard_comp_freeze_date := u_standard_comp_freeze_date;

1522: release_table(current_line).shipment_schedule_line_id := u_shipment_schedule_line_id;
1523: release_table(current_line).unit_code := u_unit_code;
1524: release_table(current_line).line_type_code := u_line_type_code;
1525: release_table(current_line).component_code := u_component_code;
1526: release_table(current_line).standard_comp_freeze_date := u_standard_comp_freeze_date;
1527: release_table(current_line).order_number := u_order_number;
1528: release_table(current_line).order_type_id := u_order_type_id;
1529: release_table(current_line).customer_id := u_customer_id;
1530: release_table(current_line).invoice_to_site_use_id := u_invoice_to_site_use_id;

Line 1570: release_table(current_line).standard_comp_freeze_date := b_standard_comp_freeze_date;

1566: release_table(current_line).shipment_schedule_line_id := b_shipment_schedule_line_id;
1567: release_table(current_line).unit_code := b_unit_code;
1568: release_table(current_line).line_type_code := b_line_type_code;
1569: release_table(current_line).component_code := b_component_code;
1570: release_table(current_line).standard_comp_freeze_date := b_standard_comp_freeze_date;
1571: release_table(current_line).order_number := b_order_number;
1572: release_table(current_line).order_type_id := b_order_type_id;
1573: release_table(current_line).customer_id := b_customer_id;
1574: release_table(current_line).invoice_to_site_use_id := b_invoice_to_site_use_id;