DBA Data[Home] [Help]

APPS.OE_ORDER_WF_UTIL dependencies on OE_ORDER_PUB

Line 32: , p_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC

28: ( p_itemtype IN VARCHAR2
29: , p_itemkey IN VARCHAR2
30: , p_wfasgn_item_type IN VARCHAR2 := FND_API.G_MISS_CHAR
31: , p_SalesDocumentTypeCode IN VARCHAR2 Default null
32: , p_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC
33: ) RETURN VARCHAR2
34: IS
35: l_process_name varchar2(30);
36:

Line 344: PROCEDURE Set_Header_User_Key(p_header_rec IN OE_Order_PUB.Header_Rec_Type)

340:
341: END Set_Line_Descriptor;
342:
343:
344: PROCEDURE Set_Header_User_Key(p_header_rec IN OE_Order_PUB.Header_Rec_Type)
345: IS
346: sales_order VARCHAR2(240);
347: --
348: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 371: PROCEDURE Set_Line_User_Key(p_line_rec IN OE_Order_PUB.Line_Rec_Type)

367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;
369: END Set_Header_User_Key;
370:
371: PROCEDURE Set_Line_User_Key(p_line_rec IN OE_Order_PUB.Line_Rec_Type)
372: IS
373: l_header_id NUMBER;
374: --
375: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 493: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

489: -- This process is called from OE_ORDER_PVT.HEader to create the
490: -- Header workitem and start the flow.
491:
492: PROCEDURE CreateStart_HdrProcess
493: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
494: )
495: IS
496: --
497: l_count NUMBER;

Line 554: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

550:
551: -- This procedure creates the Header WorkItem
552: --
553: PROCEDURE Create_HdrWorkItem
554: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
555: )
556: IS
557: l_hdr_process_name VARCHAR2(30);
558: l_aname wf_engine.nametabtyp;

Line 676: ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type

672: -- THis is called from OE_ORDER_PVT.LINES to create the Line
673: -- workitem and start the line flow.
674:
675: PROCEDURE CreateStart_LineProcess
676: ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type
677: )
678: IS
679: l_item_type varchar2(30);
680: l_index number;

Line 741: ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type

737:
738: END CreateStart_LineProcess;
739:
740: PROCEDURE CreateStart_LineFork
741: ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type
742: )
743: IS
744: --
745: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 781: ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type,

777:
778: -- This procedure creates the Line WorkItem.
779: --
780: PROCEDURE Create_LineWorkItem
781: ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type,
782: p_item_type IN VARCHAR2
783: )
784: IS
785: l_line_process_name VARCHAR2(30);

Line 884: (p_Line_rec IN OE_Order_PUB.Line_Rec_Type

880:
881: END Create_LineWorkItem;
882:
883: PROCEDURE Create_LineFork
884: (p_Line_rec IN OE_Order_PUB.Line_Rec_Type
885: )
886:
887: IS
888: l_order_number NUMBER;

Line 936: ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type

932:
933: END Create_LineFork;
934:
935: FUNCTION Get_Wf_Item_type
936: ( p_Line_rec IN OE_Order_PUB.Line_Rec_Type
937: ) RETURN VARCHAR2
938: IS
939: l_item_rec OE_ORDER_CACHE.item_rec_type;
940: --

Line 1059: l_line_rec oe_order_pub.line_rec_type;

1055: l_item_type_code VARCHAR2(30);
1056: l_ato_line_id NUMBER;
1057: l_line_id NUMBER;
1058: l_item_type varchar2(30);
1059: l_line_rec oe_order_pub.line_rec_type;
1060: l_header_id NUMBER;
1061: --
1062: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1063: --

Line 1455: l_header_rec OE_Order_PUB.Header_Rec_Type;

1451: x_return_status OUT NOCOPY VARCHAR2
1452: )
1453: IS
1454: l_flow_status_code VARCHAR2(30);
1455: l_header_rec OE_Order_PUB.Header_Rec_Type;
1456: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1457: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1458: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1459: l_return_status VARCHAR2(30);

Line 1456: l_old_header_rec OE_Order_PUB.Header_Rec_Type;

1452: )
1453: IS
1454: l_flow_status_code VARCHAR2(30);
1455: l_header_rec OE_Order_PUB.Header_Rec_Type;
1456: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1457: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1458: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1459: l_return_status VARCHAR2(30);
1460: l_source_document_id NUMBER;

Line 1457: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

1453: IS
1454: l_flow_status_code VARCHAR2(30);
1455: l_header_rec OE_Order_PUB.Header_Rec_Type;
1456: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1457: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1458: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1459: l_return_status VARCHAR2(30);
1460: l_source_document_id NUMBER;
1461: l_source_document_line_id NUMBER;

Line 1458: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

1454: l_flow_status_code VARCHAR2(30);
1455: l_header_rec OE_Order_PUB.Header_Rec_Type;
1456: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1457: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1458: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1459: l_return_status VARCHAR2(30);
1460: l_source_document_id NUMBER;
1461: l_source_document_line_id NUMBER;
1462: l_header_id NUMBER;

Line 1815: l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;

1811: ,p_source_document_line_id => l_source_document_line_id );
1812:
1813: --7138604 : l_line_tbl(1) is used below, so it has to be
1814: -- initialized in order to prevent NO_DATA_FOUND exception
1815: l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
1816:
1817: END IF;
1818: ELSIF p_header_id IS NOT NULL THEN
1819: -- validate p_flow_status

Line 2292: l_header_rec OE_Order_PUB.Header_Rec_Type;

2288: x_return_status OUT NOCOPY VARCHAR2)
2289: IS
2290: l_header_id NUMBER;
2291: l_flow_status_code VARCHAR2(30);
2292: l_header_rec OE_Order_PUB.Header_Rec_Type;
2293: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2294: l_return_status VARCHAR2(30);
2295: l_index NUMBER;
2296: l_blanket_lock_control NUMBER;

Line 2293: l_old_header_rec OE_Order_PUB.Header_Rec_Type;

2289: IS
2290: l_header_id NUMBER;
2291: l_flow_status_code VARCHAR2(30);
2292: l_header_rec OE_Order_PUB.Header_Rec_Type;
2293: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2294: l_return_status VARCHAR2(30);
2295: l_index NUMBER;
2296: l_blanket_lock_control NUMBER;
2297: l_msg_count NUMBER;

Line 3389: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

3385:
3386:
3387: -- Quote Line Attributes
3388: l_line_margin_percent NUMBER;
3389: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
3390: l_unit_cost NUMBER;
3391: l_unit_margin_amount NUMBER;
3392: l_margin_percent NUMBER;
3393: l_line line_record; -- ?? Is it still being used somewhere