DBA Data[Home] [Help]

APPS.OE_INBOUND_INT dependencies on OE_ORDER_PUB_LINE_REC_TYPE

Line 2211: FUNCTION PL_TO_SQL35(aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE)

2207: END;
2208: RETURN aPlsqlItem;
2209: END SQL_TO_PL11;
2210:
2211: FUNCTION PL_TO_SQL35(aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE)
2212: RETURN OE_ORDER_PUB_LINE_REC_TYPE IS
2213: aSqlItem OE_ORDER_PUB_LINE_REC_TYPE;
2214: BEGIN
2215: aSqlItem := OE_ORDER_PUB_LINE_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 2212: RETURN OE_ORDER_PUB_LINE_REC_TYPE IS

2208: RETURN aPlsqlItem;
2209: END SQL_TO_PL11;
2210:
2211: FUNCTION PL_TO_SQL35(aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE)
2212: RETURN OE_ORDER_PUB_LINE_REC_TYPE IS
2213: aSqlItem OE_ORDER_PUB_LINE_REC_TYPE;
2214: BEGIN
2215: aSqlItem := OE_ORDER_PUB_LINE_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2216: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 2213: aSqlItem OE_ORDER_PUB_LINE_REC_TYPE;

2209: END SQL_TO_PL11;
2210:
2211: FUNCTION PL_TO_SQL35(aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE)
2212: RETURN OE_ORDER_PUB_LINE_REC_TYPE IS
2213: aSqlItem OE_ORDER_PUB_LINE_REC_TYPE;
2214: BEGIN
2215: aSqlItem := OE_ORDER_PUB_LINE_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2216: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2217: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 2215: aSqlItem := OE_ORDER_PUB_LINE_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

2211: FUNCTION PL_TO_SQL35(aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE)
2212: RETURN OE_ORDER_PUB_LINE_REC_TYPE IS
2213: aSqlItem OE_ORDER_PUB_LINE_REC_TYPE;
2214: BEGIN
2215: aSqlItem := OE_ORDER_PUB_LINE_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2216: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2217: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2218: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2219: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 2637: FUNCTION SQL_TO_PL35(aSqlItem OE_ORDER_PUB_LINE_REC_TYPE)

2633: aSqlItem.CHARGE_PERIODICITY_CODE := aPlsqlItem.CHARGE_PERIODICITY_CODE;
2634: RETURN aSqlItem;
2635: END PL_TO_SQL35;
2636:
2637: FUNCTION SQL_TO_PL35(aSqlItem OE_ORDER_PUB_LINE_REC_TYPE)
2638: RETURN OE_ORDER_PUB.LINE_REC_TYPE IS
2639: aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE;
2640: BEGIN
2641:

Line 2638: RETURN OE_ORDER_PUB.LINE_REC_TYPE IS

2634: RETURN aSqlItem;
2635: END PL_TO_SQL35;
2636:
2637: FUNCTION SQL_TO_PL35(aSqlItem OE_ORDER_PUB_LINE_REC_TYPE)
2638: RETURN OE_ORDER_PUB.LINE_REC_TYPE IS
2639: aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE;
2640: BEGIN
2641:
2642: oe_debug_pub.add('Inside the SQL_TO_PL35', 1);

Line 2639: aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE;

2635: END PL_TO_SQL35;
2636:
2637: FUNCTION SQL_TO_PL35(aSqlItem OE_ORDER_PUB_LINE_REC_TYPE)
2638: RETURN OE_ORDER_PUB.LINE_REC_TYPE IS
2639: aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE;
2640: BEGIN
2641:
2642: oe_debug_pub.add('Inside the SQL_TO_PL35', 1);
2643:

Line 5161: l_line_reco OE_ORDER_PUB_LINE_REC_TYPE;

5157: --
5158: l_in_line_tab := Oe_Order_Pub_Line_Tbl_Type();
5159: l_in_line_val_tab := Oe_Order_Pub_Line_Val_Tbl_Typ();
5160: DECLARE
5161: l_line_reco OE_ORDER_PUB_LINE_REC_TYPE;
5162: l_line_val_reco OE_ORDER_PUB_LINE_VAL_REC_TYP;
5163: l_count NUMBER := 0;
5164: BEGIN
5165: FOR i IN p_line_tbl.first..p_line_tbl.last

Line 5560: l_line_rec oe_order_pub.line_rec_type;

5556: AND line_id <> p_top_model_line_id
5557: AND flow_status_code <> 'CANCELLED'
5558: ;
5559:
5560: l_line_rec oe_order_pub.line_rec_type;
5561: l_line_rec_obj oe_order_pub_line_rec_type;
5562: l_line_rec25_obj oe_order_pub_line_rec25;
5563: BEGIN
5564: l_model_line_tab := number_table_type();

Line 5561: l_line_rec_obj oe_order_pub_line_rec_type;

5557: AND flow_status_code <> 'CANCELLED'
5558: ;
5559:
5560: l_line_rec oe_order_pub.line_rec_type;
5561: l_line_rec_obj oe_order_pub_line_rec_type;
5562: l_line_rec25_obj oe_order_pub_line_rec25;
5563: BEGIN
5564: l_model_line_tab := number_table_type();
5565:

Line 5607: tmp_line_rec oe_order_pub.line_rec_type;

5603: -- from AIA).
5604: ------------------
5605: DECLARE
5606: l_reprice_flag VARCHAR2(1) := 'N';
5607: tmp_line_rec oe_order_pub.line_rec_type;
5608: BEGIN
5609: tmp_line_rec := l_line_rec;
5610: oe_debug_pub.ADD(' Just before the loop... with j as index....');
5611: oe_debug_pub.ADD(' # of records in l_config_process_tab.count...' ||

Line 5661: repr_line_rec oe_order_pub.line_rec_type;

5657: repr_control_rec oe_globals.control_rec_type;
5658: repr_line_tbl oe_order_pub.line_tbl_type;
5659: repr_old_line_tbl oe_order_pub.line_tbl_type;
5660:
5661: repr_line_rec oe_order_pub.line_rec_type;
5662: repr_old_line_rec oe_order_pub.line_rec_type;
5663:
5664: repr_return_status VARCHAR2(30);
5665: BEGIN

Line 5662: repr_old_line_rec oe_order_pub.line_rec_type;

5658: repr_line_tbl oe_order_pub.line_tbl_type;
5659: repr_old_line_tbl oe_order_pub.line_tbl_type;
5660:
5661: repr_line_rec oe_order_pub.line_rec_type;
5662: repr_old_line_rec oe_order_pub.line_rec_type;
5663:
5664: repr_return_status VARCHAR2(30);
5665: BEGIN
5666: repr_old_line_rec := tmp_line_rec;

Line 6582: PROCEDURE Convert_Line_null_to_miss(p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)

6578:
6579: END Process_Order; -- Overloaded form with the older deprecated signature.
6580:
6581: ----------------- O2C25: Start ---------
6582: PROCEDURE Convert_Line_null_to_miss(p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
6583: IS
6584: BEGIN
6585: oe_genesis_util.Convert_Line_null_to_miss(p_x_line_rec);
6586: EXCEPTION