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.19.12020000.7 2013/04/09 07:59:07 spothula 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 242: l_line_rec OE_Order_PUB.Line_Rec_Type;

238: actid in number,
239: funcmode in varchar2,
240: resultout in out nocopy varchar2) /* file.sql.39 change */
241: IS
242: l_line_rec OE_Order_PUB.Line_Rec_Type;
243: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
244: l_return_status VARCHAR2(1);
245: l_dummy VARCHAR2(240);
246: l_write_to_db VARCHAR2(1);

Line 243: l_old_line_rec OE_Order_PUB.Line_Rec_Type;

239: funcmode in varchar2,
240: resultout in out nocopy varchar2) /* file.sql.39 change */
241: IS
242: l_line_rec OE_Order_PUB.Line_Rec_Type;
243: l_old_line_rec OE_Order_PUB.Line_Rec_Type;
244: l_return_status VARCHAR2(1);
245: l_dummy VARCHAR2(240);
246: l_write_to_db VARCHAR2(1);
247: l_msg_count NUMBER;

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

1133: This procedure sets the sceduling attributes on the bulk glabal line
1134: record, if scheduling happens through workflow.
1135: -----------------------------------------------------------------------*/
1136: PROCEDURE Bulk_Mode_Copy_Sch_Attribs
1137: (p_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type)
1138: IS
1139: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1140: l_key NUMBER;
1141: BEGIN

Line 1219: --l_line_rec OE_Order_PUB.Line_Rec_Type;

1215: actid in number,
1216: funcmode in varchar2,
1217: resultout in out nocopy varchar2) /* file.sql.39 change */
1218: IS
1219: --l_line_rec OE_Order_PUB.Line_Rec_Type;
1220: l_source_type_code VARCHAR2(30);
1221: l_ato_line_id NUMBER;
1222: l_item_type_code VARCHAR2(30);
1223: l_line_id NUMBER;

Line 1339: l_line_rec OE_Order_PUB.Line_Rec_Type;

1335: actid in number,
1336: funcmode in varchar2,
1337: resultout in out nocopy varchar2) /* file.sql.39 change */
1338: IS
1339: l_line_rec OE_Order_PUB.Line_Rec_Type;
1340: l_header_rec OE_Order_PUB.Header_Rec_Type;
1341: l_drop_ship_line_rec OE_Purchase_Release_PVT.Drop_Ship_Line_Rec_Type;
1342: l_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;
1343: ll_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;

Line 1340: l_header_rec OE_Order_PUB.Header_Rec_Type;

1336: funcmode in varchar2,
1337: resultout in out nocopy varchar2) /* file.sql.39 change */
1338: IS
1339: l_line_rec OE_Order_PUB.Line_Rec_Type;
1340: l_header_rec OE_Order_PUB.Header_Rec_Type;
1341: l_drop_ship_line_rec OE_Purchase_Release_PVT.Drop_Ship_Line_Rec_Type;
1342: l_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;
1343: ll_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;
1344: l_return_status VARCHAR2(1);