DBA Data[Home] [Help]

APPS.OE_OEOL_SCH dependencies on OE_ORDER_PUB

Line 5: (p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type);

1: PACKAGE BODY OE_OEOL_SCH AS
2: /* $Header: OEXWSCHB.pls 120.10.12000000.3 2007/04/25 17:56:10 rajukris ship $ */
3:
4: PROCEDURE Bulk_Mode_Copy_Sch_Attribs
5: (p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type);
6:
7: -- Chache Values
8: sch_cached_line_id NUMBER ;
9: sch_cached_sch_status_code VARCHAR2(30);

Line 235: l_line_rec OE_Order_PUB.Line_Rec_Type;

231: actid in number,
232: funcmode in varchar2,
233: resultout in out nocopy varchar2) /* file.sql.39 change */
234: IS
235: l_line_rec OE_Order_PUB.Line_Rec_Type;
236: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
237: l_return_status VARCHAR2(1);
238: l_dummy VARCHAR2(240);
239: l_write_to_db VARCHAR2(1);

Line 236: l_old_line_rec OE_Order_PUB.Line_Rec_Type;

232: funcmode in varchar2,
233: resultout in out nocopy varchar2) /* file.sql.39 change */
234: IS
235: l_line_rec OE_Order_PUB.Line_Rec_Type;
236: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
237: l_return_status VARCHAR2(1);
238: l_dummy VARCHAR2(240);
239: l_write_to_db VARCHAR2(1);
240: l_msg_count NUMBER;

Line 1017: (p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type)

1013: This procedure sets the sceduling attributes on the bulk glabal line
1014: record, if scheduling happens through workflow.
1015: -----------------------------------------------------------------------*/
1016: PROCEDURE Bulk_Mode_Copy_Sch_Attribs
1017: (p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type)
1018: IS
1019: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1020: l_key NUMBER;
1021: BEGIN

Line 1099: --l_line_rec OE_Order_PUB.Line_Rec_Type;

1095: actid in number,
1096: funcmode in varchar2,
1097: resultout in out nocopy varchar2) /* file.sql.39 change */
1098: IS
1099: --l_line_rec OE_Order_PUB.Line_Rec_Type;
1100: l_source_type_code VARCHAR2(30);
1101: l_ato_line_id NUMBER;
1102: l_item_type_code VARCHAR2(30);
1103: l_line_id NUMBER;

Line 1218: l_line_rec OE_Order_PUB.Line_Rec_Type;

1214: actid in number,
1215: funcmode in varchar2,
1216: resultout in out nocopy varchar2) /* file.sql.39 change */
1217: IS
1218: l_line_rec OE_Order_PUB.Line_Rec_Type;
1219: l_header_rec OE_Order_PUB.Header_Rec_Type;
1220: l_drop_ship_line_rec OE_Purchase_Release_PVT.Drop_Ship_Line_Rec_Type;
1221: l_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;
1222: ll_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;

Line 1219: l_header_rec OE_Order_PUB.Header_Rec_Type;

1215: funcmode in varchar2,
1216: resultout in out nocopy varchar2) /* file.sql.39 change */
1217: IS
1218: l_line_rec OE_Order_PUB.Line_Rec_Type;
1219: l_header_rec OE_Order_PUB.Header_Rec_Type;
1220: l_drop_ship_line_rec OE_Purchase_Release_PVT.Drop_Ship_Line_Rec_Type;
1221: l_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;
1222: ll_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;
1223: l_return_status VARCHAR2(1);