eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_WF_UTIL dependencies on OE_GLOBALS

Line 49: and nvl(wf_assign.wf_item_type, OE_GLOBALS.G_WFI_HDR) = OE_GLOBALS.G_WFI_HDR;

45: and header.order_type_id = wf_assign.order_type_id
46: and sysdate >= wf_assign.start_date_active
47: and trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate)
48: and wf_assign.line_type_id IS NULL
49: and nvl(wf_assign.wf_item_type, OE_GLOBALS.G_WFI_HDR) = OE_GLOBALS.G_WFI_HDR;
50: /* NEED UPGRADE ON NEW COLUMN? */
51:
52: CURSOR find_LineProcessname is
53: SELECT wf_assign.process_name

Line 74: and wf_assign.wf_item_type = OE_GLOBALS.G_WFI_NGO

70: WHERE header.header_id = to_number(itemkey)
71: and header.order_type_id = wf_assign.order_type_id
72: and sysdate >= wf_assign.start_date_active
73: and trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate)
74: and wf_assign.wf_item_type = OE_GLOBALS.G_WFI_NGO
75: and wf_assign.line_type_id IS NULL;
76:
77: CURSOR find_BktNgoHdrProcessname(itemkey varchar2) is
78: SELECT wf_assign.process_name

Line 85: and wf_assign.wf_item_type = OE_GLOBALS.G_WFI_NGO

81: WHERE header.header_id = to_number(itemkey)
82: and header.order_type_id = wf_assign.order_type_id
83: and sysdate >= wf_assign.start_date_active
84: and trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate)
85: and wf_assign.wf_item_type = OE_GLOBALS.G_WFI_NGO
86: and wf_assign.line_type_id IS NULL;
87:
88: CURSOR find_BlanketHdrProcessname(itemkey varchar2) is
89: SELECT wf_assign.process_name

Line 96: and wf_assign.wf_item_type = OE_GLOBALS.G_WFI_BKT

92: WHERE blanket.header_id = to_number(itemkey)
93: and blanket.order_type_id = wf_assign.order_type_id
94: and sysdate >= wf_assign.start_date_active
95: and trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate)
96: and wf_assign.wf_item_type = OE_GLOBALS.G_WFI_BKT
97: and wf_assign.line_type_id IS NULL;
98:
99: --
100: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 108: IF (p_itemtype = OE_GLOBALS.G_WFI_HDR) THEN

104: IF l_debug_level > 0 THEN
105: oe_debug_pub.add( 'IN GET_PROCESSNAME: ' || p_itemtype || '/' || p_itemkey || '/' || p_wfasgn_item_type) ;
106: END IF;
107:
108: IF (p_itemtype = OE_GLOBALS.G_WFI_HDR) THEN
109:
110: OPEN find_HdrProcessname(p_itemkey);
111: FETCH find_HdrProcessname
112: INTO l_process_name;

Line 115: ELSIF (p_itemtype = OE_GLOBALS.G_WFI_LIN) THEN

111: FETCH find_HdrProcessname
112: INTO l_process_name;
113:
114: CLOSE find_HdrProcessname;
115: ELSIF (p_itemtype = OE_GLOBALS.G_WFI_LIN) THEN
116: IF l_debug_level > 0 THEN
117: oe_debug_pub.add( 'header_id: ' || p_line_rec.header_id || ' line_id: ' || p_line_rec.line_id || ' line_type_id: ' || p_line_rec.line_type_id);
118: END IF;
119: OPEN find_LineProcessname;

Line 124: ELSIF (p_itemtype = OE_GLOBALS.G_WFI_NGO) THEN

120: FETCH find_LineProcessname
121: INTO l_process_name;
122:
123: CLOSE find_LineProcessname;
124: ELSIF (p_itemtype = OE_GLOBALS.G_WFI_NGO) THEN
125: IF nvl(p_SalesDocumentTypeCode, 'O') = 'O' THEN
126: OPEN find_NegotiateHdrProcessname(p_itemkey);
127: FETCH find_NegotiateHdrProcessname
128: INTO l_process_name;

Line 142: ELSIF (p_itemtype = OE_GLOBALS.G_WFI_BKT) THEN

138: -- error
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141:
142: ELSIF (p_itemtype = OE_GLOBALS.G_WFI_BKT) THEN
143: OPEN find_BlanketHdrProcessname(p_itemkey);
144: FETCH find_BlanketHdrProcessname
145: INTO l_process_name;
146:

Line 511: OE_GLOBALS.G_START_HEADER_FLOW := p_header_rec.header_id;

507:
508: -- We do not start the flow when the record is written, rather
509: -- when the transaction is committed. Here we will set the
510: -- Global.
511: OE_GLOBALS.G_START_HEADER_FLOW := p_header_rec.header_id;
512:
513: -- For OENH
514: -- Check if a OENH flow exists, if so set the parent
515: SELECT count(1)

Line 518: WHERE item_type=OE_GLOBALS.G_WFI_NGO

514: -- Check if a OENH flow exists, if so set the parent
515: SELECT count(1)
516: INTO l_count
517: FROM wf_items
518: WHERE item_type=OE_GLOBALS.G_WFI_NGO
519: AND item_key =to_char(p_header_rec.header_id);
520:
521: IF l_count > 0 THEN
522: WF_ITEM.Set_Item_Parent(OE_GLOBALS.G_WFI_HDR,

Line 522: WF_ITEM.Set_Item_Parent(OE_GLOBALS.G_WFI_HDR,

518: WHERE item_type=OE_GLOBALS.G_WFI_NGO
519: AND item_key =to_char(p_header_rec.header_id);
520:
521: IF l_count > 0 THEN
522: WF_ITEM.Set_Item_Parent(OE_GLOBALS.G_WFI_HDR,
523: to_char(p_header_rec.header_id),
524: OE_GLOBALS.G_WFI_NGO,
525: to_char(p_header_rec.header_id), '');
526: END IF;

Line 524: OE_GLOBALS.G_WFI_NGO,

520:
521: IF l_count > 0 THEN
522: WF_ITEM.Set_Item_Parent(OE_GLOBALS.G_WFI_HDR,
523: to_char(p_header_rec.header_id),
524: OE_GLOBALS.G_WFI_NGO,
525: to_char(p_header_rec.header_id), '');
526: END IF;
527:
528:

Line 530: /* Start_Flow(OE_GLOBALS.G_WFI_HDR, p_header_rec.header_id); */

526: END IF;
527:
528:
529:
530: /* Start_Flow(OE_GLOBALS.G_WFI_HDR, p_header_rec.header_id); */
531:
532: IF l_debug_level > 0 THEN
533: oe_debug_pub.add( 'EXITING CREATESTART_HDRPROCESS' ) ;
534: END IF;

Line 582: l_hdr_process_name := Get_ProcessName(p_itemtype => OE_GLOBALS.G_WFI_HDR, p_itemkey => p_header_rec.header_id);

578: -- Get name of Header Process
579: IF l_debug_level > 0 THEN
580: oe_debug_pub.add( 'GET HEADER PROCESS NAME' ) ;
581: END IF;
582: l_hdr_process_name := Get_ProcessName(p_itemtype => OE_GLOBALS.G_WFI_HDR, p_itemkey => p_header_rec.header_id);
583:
584: Set_Header_User_Key(p_header_rec);
585: sales_order := substrb(fnd_message.get, 1, 240);
586:

Line 592: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_HDR,to_char(p_header_rec.header_id),

588: INTO l_owner_role
589: FROM FND_USER
590: WHERE USER_ID = FND_GLOBAL.USER_ID;
591: -- Create Header Work item
592: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_HDR,to_char(p_header_rec.header_id),
593: l_hdr_process_name,
594: sales_order,
595: l_owner_role);
596:

Line 597: WF_ENGINE.additemattr(OE_Globals.G_WFI_HDR,to_char(p_header_rec.header_id),

593: l_hdr_process_name,
594: sales_order,
595: l_owner_role);
596:
597: WF_ENGINE.additemattr(OE_Globals.G_WFI_HDR,to_char(p_header_rec.header_id),
598: '#WAITFORDETAIL',null,0);
599:
600: IF l_debug_level > 0 THEN
601: oe_debug_pub.add( 'AFTER WF_ENGINE.CREATEPROCESS' ) ;

Line 612: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);

608: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
609: l_aname(3) := 'RESPONSIBILITY_ID';
610: l_avalue(3) := FND_GLOBAL.RESP_ID;
611: l_aname(4) := 'ORG_ID';
612: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
613: l_aname(5) := 'ORDER_NUMBER';
614: l_avalue(5) := p_header_rec.order_number;
615:
616: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_HDR

Line 616: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_HDR

612: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
613: l_aname(5) := 'ORDER_NUMBER';
614: l_avalue(5) := p_header_rec.order_number;
615:
616: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_HDR
617: , p_header_rec.header_id
618: , l_aname
619: , l_avalue
620: );

Line 647: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_HDR

643: '/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' ||
644: 'akRegionApplicationId=660' || '&' || 'HeaderId=' || to_char(p_header_rec.header_id);
645:
646:
647: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_HDR
648: , p_header_rec.header_id
649: , l_aname2
650: , l_avaluetext
651: );

Line 701: -- Start_Flow(OE_GLOBALS.G_WFI_LIN, p_Line_rec.Line_id);

697: Create_LineWorkItem(p_Line_rec, l_item_type);
698:
699: -- We do not start the flow when the record is written, rather
700: -- when the transaction is committed.
701: -- Start_Flow(OE_GLOBALS.G_WFI_LIN, p_Line_rec.Line_id);
702: -- Add line Id to global table for later processing.
703:
704: -- Bug 3000619, references to G_START_LINE_FLOWS_TBL are changed.
705: IF (OE_GLOBALS.G_START_LINE_FLOWS_TBL.COUNT = 0) THEN

Line 705: IF (OE_GLOBALS.G_START_LINE_FLOWS_TBL.COUNT = 0) THEN

701: -- Start_Flow(OE_GLOBALS.G_WFI_LIN, p_Line_rec.Line_id);
702: -- Add line Id to global table for later processing.
703:
704: -- Bug 3000619, references to G_START_LINE_FLOWS_TBL are changed.
705: IF (OE_GLOBALS.G_START_LINE_FLOWS_TBL.COUNT = 0) THEN
706: IF l_debug_level > 0 THEN
707: oe_debug_pub.add( 'G_START_LINE_FLOWS_TBL.COUNT = 0'|| p_Line_rec.ato_Line_id || '-'|| p_Line_rec.Line_id , 2) ;
708: END IF;
709: OE_GLOBALS.G_START_LINE_FLOWS_TBL(1).line_id := p_Line_rec.Line_id;

Line 709: OE_GLOBALS.G_START_LINE_FLOWS_TBL(1).line_id := p_Line_rec.Line_id;

705: IF (OE_GLOBALS.G_START_LINE_FLOWS_TBL.COUNT = 0) THEN
706: IF l_debug_level > 0 THEN
707: oe_debug_pub.add( 'G_START_LINE_FLOWS_TBL.COUNT = 0'|| p_Line_rec.ato_Line_id || '-'|| p_Line_rec.Line_id , 2) ;
708: END IF;
709: OE_GLOBALS.G_START_LINE_FLOWS_TBL(1).line_id := p_Line_rec.Line_id;
710: OE_GLOBALS.G_START_LINE_FLOWS_TBL(1).post_write_ato_line_id := p_Line_rec.ato_Line_id;
711: ELSE -- the table has entries
712: l_index := OE_GLOBALS.G_START_LINE_FLOWS_TBL.LAST;
713: IF l_debug_level > 0 THEN

Line 710: OE_GLOBALS.G_START_LINE_FLOWS_TBL(1).post_write_ato_line_id := p_Line_rec.ato_Line_id;

706: IF l_debug_level > 0 THEN
707: oe_debug_pub.add( 'G_START_LINE_FLOWS_TBL.COUNT = 0'|| p_Line_rec.ato_Line_id || '-'|| p_Line_rec.Line_id , 2) ;
708: END IF;
709: OE_GLOBALS.G_START_LINE_FLOWS_TBL(1).line_id := p_Line_rec.Line_id;
710: OE_GLOBALS.G_START_LINE_FLOWS_TBL(1).post_write_ato_line_id := p_Line_rec.ato_Line_id;
711: ELSE -- the table has entries
712: l_index := OE_GLOBALS.G_START_LINE_FLOWS_TBL.LAST;
713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add( 'G_START_LINE_FLOWS_TBL.COUNT = ' || to_char(l_index) || p_Line_rec.ato_Line_id || '-'|| p_Line_rec.Line_id, 3 ) ;

Line 712: l_index := OE_GLOBALS.G_START_LINE_FLOWS_TBL.LAST;

708: END IF;
709: OE_GLOBALS.G_START_LINE_FLOWS_TBL(1).line_id := p_Line_rec.Line_id;
710: OE_GLOBALS.G_START_LINE_FLOWS_TBL(1).post_write_ato_line_id := p_Line_rec.ato_Line_id;
711: ELSE -- the table has entries
712: l_index := OE_GLOBALS.G_START_LINE_FLOWS_TBL.LAST;
713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add( 'G_START_LINE_FLOWS_TBL.COUNT = ' || to_char(l_index) || p_Line_rec.ato_Line_id || '-'|| p_Line_rec.Line_id, 3 ) ;
715: END IF;
716: OE_GLOBALS.G_START_LINE_FLOWS_TBL(l_index + 1).line_id := p_Line_rec.Line_id;

Line 716: OE_GLOBALS.G_START_LINE_FLOWS_TBL(l_index + 1).line_id := p_Line_rec.Line_id;

712: l_index := OE_GLOBALS.G_START_LINE_FLOWS_TBL.LAST;
713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add( 'G_START_LINE_FLOWS_TBL.COUNT = ' || to_char(l_index) || p_Line_rec.ato_Line_id || '-'|| p_Line_rec.Line_id, 3 ) ;
715: END IF;
716: OE_GLOBALS.G_START_LINE_FLOWS_TBL(l_index + 1).line_id := p_Line_rec.Line_id;
717: OE_GLOBALS.G_START_LINE_FLOWS_TBL(l_index + 1).post_write_ato_line_id := p_Line_rec.ato_Line_id;
718: END IF;
719:
720: IF l_debug_level > 0 THEN

Line 717: OE_GLOBALS.G_START_LINE_FLOWS_TBL(l_index + 1).post_write_ato_line_id := p_Line_rec.ato_Line_id;

713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add( 'G_START_LINE_FLOWS_TBL.COUNT = ' || to_char(l_index) || p_Line_rec.ato_Line_id || '-'|| p_Line_rec.Line_id, 3 ) ;
715: END IF;
716: OE_GLOBALS.G_START_LINE_FLOWS_TBL(l_index + 1).line_id := p_Line_rec.Line_id;
717: OE_GLOBALS.G_START_LINE_FLOWS_TBL(l_index + 1).post_write_ato_line_id := p_Line_rec.ato_Line_id;
718: END IF;
719:
720: IF l_debug_level > 0 THEN
721: oe_debug_pub.add( 'EXITING CREATESTART_LINEPROCESS' ) ;

Line 809: l_line_process_name := Get_ProcessName(p_itemtype => OE_GLOBALS.G_WFI_LIN, p_itemkey => p_Line_rec.line_id, p_wfasgn_item_type => l_item_type, p_line_rec => p_line_rec);

805: -- Get name of Line Process
806: IF l_debug_level > 0 THEN
807: oe_debug_pub.add( 'GET LINE PROCESSNAME' ) ;
808: END IF;
809: l_line_process_name := Get_ProcessName(p_itemtype => OE_GLOBALS.G_WFI_LIN, p_itemkey => p_Line_rec.line_id, p_wfasgn_item_type => l_item_type, p_line_rec => p_line_rec);
810:
811: Set_Line_User_Key(p_line_rec);
812: line := substrb(fnd_message.get, 1, 240);
813:

Line 820: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_LIN,to_char(p_Line_rec.line_id),

816: FROM FND_USER
817: WHERE USER_ID = FND_GLOBAL.USER_ID;
818:
819: -- Create Line Work item
820: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_LIN,to_char(p_Line_rec.line_id),
821: l_line_process_name,
822: line,
823: l_owner_role);
824:

Line 839: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);

835: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
836: l_aname(3) := 'RESPONSIBILITY_ID';
837: l_avalue(3) := FND_GLOBAL.RESP_ID;
838: l_aname(4) := 'ORG_ID';
839: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
840:
841: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_LIN
842: , p_line_rec.line_id
843: , l_aname

Line 841: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_LIN

837: l_avalue(3) := FND_GLOBAL.RESP_ID;
838: l_aname(4) := 'ORG_ID';
839: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
840:
841: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_LIN
842: , p_line_rec.line_id
843: , l_aname
844: , l_avalue
845: );

Line 852: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_LIN

848: l_avaluetext(1) := p_line_rec.line_category_code;
849: l_aname2(2) := 'NOTIFICATION_APPROVER';
850: l_avaluetext(2) := FND_PROFILE.VALUE('OE_NOTIFICATION_APPROVER');
851:
852: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_LIN
853: , p_line_rec.line_id
854: , l_aname2
855: , l_avaluetext
856: );

Line 858: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,

854: , l_aname2
855: , l_avaluetext
856: );
857:
858: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,
859: to_char(p_Line_rec.line_id),
860: OE_GLOBALS.G_WFI_HDR,
861: to_char(p_Line_rec.header_id), '',
862: true);

Line 860: OE_GLOBALS.G_WFI_HDR,

856: );
857:
858: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,
859: to_char(p_Line_rec.line_id),
860: OE_GLOBALS.G_WFI_HDR,
861: to_char(p_Line_rec.header_id), '',
862: true);
863:
864: IF l_debug_level > 0 THEN

Line 909: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_LIN

905: p_line_rec.line_id,
906: true,
907: true );
908:
909: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_LIN
910: , p_line_rec.line_id
911: , line);
912:
913: IF l_debug_level > 0 THEN

Line 961: --ELSIF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND

957: IF OE_OTA_UTIL.Is_OTA_Line(p_line_rec.order_quantity_uom) THEN
958:
959: RETURN 'EDUCATION_ITEM';
960:
961: --ELSIF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND
962: -- l_item_rec.replenish_to_order_flag = 'Y') OR
963:
964: -- ## 1820608 ato item under a top pto model should start ato_item flow.
965:

Line 966: ELSIF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR

962: -- l_item_rec.replenish_to_order_flag = 'Y') OR
963:
964: -- ## 1820608 ato item under a top pto model should start ato_item flow.
965:
966: ELSIF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
967: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION)
968: AND p_line_rec.ato_line_id = p_line_rec.line_id THEN
969: RETURN 'ATO_ITEM';
970:

Line 967: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION)

963:
964: -- ## 1820608 ato item under a top pto model should start ato_item flow.
965:
966: ELSIF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
967: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION)
968: AND p_line_rec.ato_line_id = p_line_rec.line_id THEN
969: RETURN 'ATO_ITEM';
970:
971: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND

Line 971: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND

967: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION)
968: AND p_line_rec.ato_line_id = p_line_rec.line_id THEN
969: RETURN 'ATO_ITEM';
970:
971: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
972: p_line_rec.line_id = p_line_rec.ato_line_id) THEN
973:
974: RETURN 'ATO_MODEL';
975: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG) THEN

Line 975: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG) THEN

971: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
972: p_line_rec.line_id = p_line_rec.ato_line_id) THEN
973:
974: RETURN 'ATO_MODEL';
975: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG) THEN
976:
977: RETURN 'CONFIGURATION';
978:
979: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED) THEN

Line 979: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED) THEN

975: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG) THEN
976:
977: RETURN 'CONFIGURATION';
978:
979: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED) THEN
980:
981: RETURN 'II';
982: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN
983:

Line 982: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN

978:
979: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED) THEN
980:
981: RETURN 'II';
982: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN
983:
984: RETURN 'KIT';
985: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
986: p_line_rec.line_id = p_line_rec.top_model_line_id AND

Line 985: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND

981: RETURN 'II';
982: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN
983:
984: RETURN 'KIT';
985: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
986: p_line_rec.line_id = p_line_rec.top_model_line_id AND
987: p_line_rec.ato_line_id IS NULL) THEN
988:
989: RETURN 'PTO_MODEL';

Line 990: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND

986: p_line_rec.line_id = p_line_rec.top_model_line_id AND
987: p_line_rec.ato_line_id IS NULL) THEN
988:
989: RETURN 'PTO_MODEL';
990: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
991: p_line_rec.ato_line_id IS NULL) THEN
992:
993: RETURN 'PTO_CLASS';
994: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION AND

Line 994: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION AND

990: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
991: p_line_rec.ato_line_id IS NULL) THEN
992:
993: RETURN 'PTO_CLASS';
994: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
995: p_line_rec.ato_line_id IS NULL) THEN
996:
997: RETURN 'PTO_OPTION';
998:

Line 1004: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND

1000: -- for ato under pto, we want to start ato model flow
1001: -- even if the item_type_code is class. For ato under ato
1002: -- start standard flow.
1003:
1004: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
1005: p_line_rec.ato_line_id IS NOT NULL) THEN
1006:
1007: IF p_line_rec.ato_line_id = p_line_rec.line_id
1008: THEN

Line 1014: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION AND

1010: ELSE
1011: RETURN 'ATO_CLASS'; --FP bug no 4572207
1012: END IF;
1013:
1014: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
1015: p_line_rec.ato_line_id IS NOT NULL) THEN
1016:
1017: RETURN 'ATO_OPTION'; --FB bug no 4572207
1018: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD) THEN

Line 1018: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD) THEN

1014: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
1015: p_line_rec.ato_line_id IS NOT NULL) THEN
1016:
1017: RETURN 'ATO_OPTION'; --FB bug no 4572207
1018: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD) THEN
1019:
1020: RETURN 'STANDARD';
1021: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE) THEN
1022:

Line 1021: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE) THEN

1017: RETURN 'ATO_OPTION'; --FB bug no 4572207
1018: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD) THEN
1019:
1020: RETURN 'STANDARD';
1021: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE) THEN
1022:
1023: RETURN 'SERVICE';
1024:
1025: ELSE

Line 1073: IF (NOT OE_GLOBALS.G_FLOW_PROCESSING_STARTED) THEN

1069:
1070: -- This code should be invoked again, once it starts executing
1071: -- Starting flows can cause the creation of new lines, but we do not
1072: -- want the creation call to get in here again.
1073: IF (NOT OE_GLOBALS.G_FLOW_PROCESSING_STARTED) THEN
1074: OE_GLOBALS.G_FLOW_PROCESSING_STARTED := TRUE;
1075: IF l_debug_level > 0 THEN
1076: oe_debug_pub.add( 'FLOW PROCESSING STARTED' ) ;
1077: END IF;

Line 1074: OE_GLOBALS.G_FLOW_PROCESSING_STARTED := TRUE;

1070: -- This code should be invoked again, once it starts executing
1071: -- Starting flows can cause the creation of new lines, but we do not
1072: -- want the creation call to get in here again.
1073: IF (NOT OE_GLOBALS.G_FLOW_PROCESSING_STARTED) THEN
1074: OE_GLOBALS.G_FLOW_PROCESSING_STARTED := TRUE;
1075: IF l_debug_level > 0 THEN
1076: oe_debug_pub.add( 'FLOW PROCESSING STARTED' ) ;
1077: END IF;
1078:

Line 1083: IF (OE_GLOBALS.G_START_HEADER_FLOW IS NOT NULL) THEN

1079: -- Issue Savepoint
1080: SAVEPOINT Start_All_Flows;
1081:
1082: -- Check if Header flow needs to be started
1083: IF (OE_GLOBALS.G_START_HEADER_FLOW IS NOT NULL) THEN
1084:
1085: BEGIN
1086: -- Sanity Check to verify that header exists
1087: -- The create of the header could have been rolled back

Line 1092: where header_id = OE_GLOBALS.G_START_HEADER_FLOW;

1088: -- but the PL/SQL global is not in synch.
1089: Select order_type_id
1090: into l_type_id
1091: from oe_order_headers_all
1092: where header_id = OE_GLOBALS.G_START_HEADER_FLOW;
1093:
1094: IF l_debug_level > 0 THEN
1095: oe_debug_pub.add( 'STARTING HEADER FLOW' ) ;
1096: END IF;

Line 1099: Start_Flow(OE_GLOBALS.G_WFI_HDR, OE_GLOBALS.G_START_HEADER_FLOW);

1095: oe_debug_pub.add( 'STARTING HEADER FLOW' ) ;
1096: END IF;
1097:
1098: -- Start flow and clear global
1099: Start_Flow(OE_GLOBALS.G_WFI_HDR, OE_GLOBALS.G_START_HEADER_FLOW);
1100: OE_GLOBALS.G_START_HEADER_FLOW := NULL;
1101:
1102: EXCEPTION
1103: WHEN NO_DATA_FOUND THEN

Line 1100: OE_GLOBALS.G_START_HEADER_FLOW := NULL;

1096: END IF;
1097:
1098: -- Start flow and clear global
1099: Start_Flow(OE_GLOBALS.G_WFI_HDR, OE_GLOBALS.G_START_HEADER_FLOW);
1100: OE_GLOBALS.G_START_HEADER_FLOW := NULL;
1101:
1102: EXCEPTION
1103: WHEN NO_DATA_FOUND THEN
1104: IF l_debug_level > 0 THEN

Line 1105: oe_debug_pub.add( 'HEADER '||OE_GLOBALS.G_START_HEADER_FLOW||' IS MISSING , BUT ID EXISTS IN GLOBAL TABLE' ) ;

1101:
1102: EXCEPTION
1103: WHEN NO_DATA_FOUND THEN
1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add( 'HEADER '||OE_GLOBALS.G_START_HEADER_FLOW||' IS MISSING , BUT ID EXISTS IN GLOBAL TABLE' ) ;
1106: END IF;
1107: OE_GLOBALS.G_START_HEADER_FLOW := NULL;
1108: END;
1109:

Line 1107: OE_GLOBALS.G_START_HEADER_FLOW := NULL;

1103: WHEN NO_DATA_FOUND THEN
1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add( 'HEADER '||OE_GLOBALS.G_START_HEADER_FLOW||' IS MISSING , BUT ID EXISTS IN GLOBAL TABLE' ) ;
1106: END IF;
1107: OE_GLOBALS.G_START_HEADER_FLOW := NULL;
1108: END;
1109:
1110:
1111: END IF;

Line 1114: IF (OE_GLOBALS.G_START_LINE_FLOWS_TBL.COUNT > 0) THEN

1110:
1111: END IF;
1112:
1113: -- Check if Line Flows need to be started
1114: IF (OE_GLOBALS.G_START_LINE_FLOWS_TBL.COUNT > 0) THEN
1115:
1116: -- This global table can grow while it is being processed, hence we can cannot
1117: -- loop thru using first ... count. Starting a line flow can create included item
1118: -- lines (booking, scheduling activity).

Line 1124: ctr := OE_GLOBALS.G_START_LINE_FLOWS_TBL.FIRST;

1120: IF l_debug_level > 0 THEN
1121: oe_debug_pub.add( 'START LINE FLOWS' ) ;
1122: END IF;
1123:
1124: ctr := OE_GLOBALS.G_START_LINE_FLOWS_TBL.FIRST;
1125:
1126: WHILE (ctr is NOT NULL) LOOP
1127:
1128: IF l_debug_level > 0 THEN

Line 1129: oe_debug_pub.add( 'INSIDE LOOP '||'LINE ID IS '||OE_GLOBALS.G_START_LINE_FLOWS_TBL ( CTR ).line_id ) ;

1125:
1126: WHILE (ctr is NOT NULL) LOOP
1127:
1128: IF l_debug_level > 0 THEN
1129: oe_debug_pub.add( 'INSIDE LOOP '||'LINE ID IS '||OE_GLOBALS.G_START_LINE_FLOWS_TBL ( CTR ).line_id ) ;
1130: END IF;
1131:
1132: BEGIN
1133:

Line 1145: where line_id = OE_GLOBALS.G_START_LINE_FLOWS_TBL(ctr).line_id;

1141: ato_line_id, line_id
1142: into l_type_id, l_item_type_code,
1143: l_ato_line_id, l_line_id
1144: from oe_order_lines_all
1145: where line_id = OE_GLOBALS.G_START_LINE_FLOWS_TBL(ctr).line_id;
1146:
1147: IF l_debug_level > 0 THEN
1148: oe_debug_pub.add( 'STARTING LINE FLOW '||'LINE ID = ' ||OE_GLOBALS.G_START_LINE_FLOWS_TBL ( CTR ).line_id ) ;
1149: END IF;

Line 1148: oe_debug_pub.add( 'STARTING LINE FLOW '||'LINE ID = ' ||OE_GLOBALS.G_START_LINE_FLOWS_TBL ( CTR ).line_id ) ;

1144: from oe_order_lines_all
1145: where line_id = OE_GLOBALS.G_START_LINE_FLOWS_TBL(ctr).line_id;
1146:
1147: IF l_debug_level > 0 THEN
1148: oe_debug_pub.add( 'STARTING LINE FLOW '||'LINE ID = ' ||OE_GLOBALS.G_START_LINE_FLOWS_TBL ( CTR ).line_id ) ;
1149: END IF;
1150:
1151: IF l_item_type_code = 'CLASS' AND
1152: l_ato_line_id is not null AND

Line 1158: IF OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).post_write_ato_line_id

1154: IF l_debug_level > 0 THEN
1155: oe_debug_pub.add('need to check wf assignment for ato under ato under pto, 3');
1156: END IF;
1157:
1158: IF OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).post_write_ato_line_id
1159: <> l_ato_line_id THEN
1160:
1161: WF_ENGINE.AbortProcess
1162: (itemtype => OE_GLOBALS.G_WFI_LIN,

Line 1162: (itemtype => OE_GLOBALS.G_WFI_LIN,

1158: IF OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).post_write_ato_line_id
1159: <> l_ato_line_id THEN
1160:
1161: WF_ENGINE.AbortProcess
1162: (itemtype => OE_GLOBALS.G_WFI_LIN,
1163: itemkey => OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).line_id);
1164:
1165: WF_PURGE.Items
1166: (itemtype => OE_GLOBALS.G_WFI_LIN,

Line 1163: itemkey => OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).line_id);

1159: <> l_ato_line_id THEN
1160:
1161: WF_ENGINE.AbortProcess
1162: (itemtype => OE_GLOBALS.G_WFI_LIN,
1163: itemkey => OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).line_id);
1164:
1165: WF_PURGE.Items
1166: (itemtype => OE_GLOBALS.G_WFI_LIN,
1167: itemkey => OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).line_id,

Line 1166: (itemtype => OE_GLOBALS.G_WFI_LIN,

1162: (itemtype => OE_GLOBALS.G_WFI_LIN,
1163: itemkey => OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).line_id);
1164:
1165: WF_PURGE.Items
1166: (itemtype => OE_GLOBALS.G_WFI_LIN,
1167: itemkey => OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).line_id,
1168: force => TRUE,
1169: docommit => false);
1170:

Line 1167: itemkey => OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).line_id,

1163: itemkey => OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).line_id);
1164:
1165: WF_PURGE.Items
1166: (itemtype => OE_GLOBALS.G_WFI_LIN,
1167: itemkey => OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).line_id,
1168: force => TRUE,
1169: docommit => false);
1170:
1171: OE_Line_Util.Query_Row

Line 1172: ( p_line_id => OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).line_id

1168: force => TRUE,
1169: docommit => false);
1170:
1171: OE_Line_Util.Query_Row
1172: ( p_line_id => OE_GLOBALS.G_START_LINE_FLOWS_TBL(CTR).line_id
1173: ,x_line_rec => l_line_rec);
1174:
1175: l_item_type := OE_Order_Wf_Util.get_wf_item_type(l_line_rec);
1176:

Line 1182: Start_Flow(OE_GLOBALS.G_WFI_LIN, OE_GLOBALS.G_START_LINE_FLOWS_TBL(ctr).line_id); -- End bug 3000619

1178:
1179: END IF; -- if post_write_ato_line_id <> l_ato_line_id
1180: END IF; -- item_type = CLASS
1181:
1182: Start_Flow(OE_GLOBALS.G_WFI_LIN, OE_GLOBALS.G_START_LINE_FLOWS_TBL(ctr).line_id); -- End bug 3000619
1183:
1184: EXCEPTION
1185: WHEN NO_DATA_FOUND THEN
1186: IF l_debug_level > 0 THEN

Line 1187: oe_debug_pub.add( 'LINE '||OE_GLOBALS.G_START_LINE_FLOWS_TBL ( CTR ).line_id ||' IS MISSING , BUT ID EXISTS IN GLOBAL TABLE' ) ;

1183:
1184: EXCEPTION
1185: WHEN NO_DATA_FOUND THEN
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( 'LINE '||OE_GLOBALS.G_START_LINE_FLOWS_TBL ( CTR ).line_id ||' IS MISSING , BUT ID EXISTS IN GLOBAL TABLE' ) ;
1188: END IF;
1189: END;
1190:
1191:

Line 1192: ctr := OE_GLOBALS.G_START_LINE_FLOWS_TBL.NEXT(ctr);

1188: END IF;
1189: END;
1190:
1191:
1192: ctr := OE_GLOBALS.G_START_LINE_FLOWS_TBL.NEXT(ctr);
1193:
1194: END LOOP;
1195:
1196: -- Clear the Global table.

Line 1197: OE_GLOBALS.G_START_LINE_FLOWS_TBL.DELETE;

1193:
1194: END LOOP;
1195:
1196: -- Clear the Global table.
1197: OE_GLOBALS.G_START_LINE_FLOWS_TBL.DELETE;
1198:
1199: END IF;
1200:
1201: -- Start OENH/OEBH handling

Line 1202: IF (OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW IS NOT NULL) THEN

1198:
1199: END IF;
1200:
1201: -- Start OENH/OEBH handling
1202: IF (OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW IS NOT NULL) THEN
1203: BEGIN
1204: -- Sanity Check to verify that negotiate header exists
1205: -- The create of the header could have been rolled back
1206: -- but the PL/SQL global is not in synch.

Line 1207: IF OE_GLOBALS.G_SALES_DOCUMENT_TYPE_CODE = 'O' THEN

1203: BEGIN
1204: -- Sanity Check to verify that negotiate header exists
1205: -- The create of the header could have been rolled back
1206: -- but the PL/SQL global is not in synch.
1207: IF OE_GLOBALS.G_SALES_DOCUMENT_TYPE_CODE = 'O' THEN
1208: Select header_id
1209: into l_header_id
1210: from oe_order_headers_all
1211: where header_id = OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW;

Line 1211: where header_id = OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW;

1207: IF OE_GLOBALS.G_SALES_DOCUMENT_TYPE_CODE = 'O' THEN
1208: Select header_id
1209: into l_header_id
1210: from oe_order_headers_all
1211: where header_id = OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW;
1212: ELSIF OE_GLOBALS.G_SALES_DOCUMENT_TYPE_CODE = 'B' THEN
1213: Select header_id
1214: into l_header_id
1215: from oe_blanket_headers_all

Line 1212: ELSIF OE_GLOBALS.G_SALES_DOCUMENT_TYPE_CODE = 'B' THEN

1208: Select header_id
1209: into l_header_id
1210: from oe_order_headers_all
1211: where header_id = OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW;
1212: ELSIF OE_GLOBALS.G_SALES_DOCUMENT_TYPE_CODE = 'B' THEN
1213: Select header_id
1214: into l_header_id
1215: from oe_blanket_headers_all
1216: where header_id = OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW;

Line 1216: where header_id = OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW;

1212: ELSIF OE_GLOBALS.G_SALES_DOCUMENT_TYPE_CODE = 'B' THEN
1213: Select header_id
1214: into l_header_id
1215: from oe_blanket_headers_all
1216: where header_id = OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW;
1217: END IF;
1218: IF l_debug_level > 0 THEN
1219: oe_debug_pub.add( 'STARTING NEGOTIATE HEADER FLOW' ) ;
1220: END IF;

Line 1223: Start_Flow(OE_GLOBALS.G_WFI_NGO, OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW);

1219: oe_debug_pub.add( 'STARTING NEGOTIATE HEADER FLOW' ) ;
1220: END IF;
1221:
1222: -- Start flow and clear global
1223: Start_Flow(OE_GLOBALS.G_WFI_NGO, OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW);
1224: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW := NULL;
1225:
1226: EXCEPTION
1227: WHEN NO_DATA_FOUND THEN

Line 1224: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW := NULL;

1220: END IF;
1221:
1222: -- Start flow and clear global
1223: Start_Flow(OE_GLOBALS.G_WFI_NGO, OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW);
1224: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW := NULL;
1225:
1226: EXCEPTION
1227: WHEN NO_DATA_FOUND THEN
1228: IF l_debug_level > 0 THEN

Line 1229: oe_debug_pub.add( 'Negotiate Header (OENH): '||OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW||' IS MISSING , BUT ID EXISTS IN GLOBAL' ) ;

1225:
1226: EXCEPTION
1227: WHEN NO_DATA_FOUND THEN
1228: IF l_debug_level > 0 THEN
1229: oe_debug_pub.add( 'Negotiate Header (OENH): '||OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW||' IS MISSING , BUT ID EXISTS IN GLOBAL' ) ;
1230: END IF;
1231: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW:= NULL;
1232: END;
1233: END IF;

Line 1231: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW:= NULL;

1227: WHEN NO_DATA_FOUND THEN
1228: IF l_debug_level > 0 THEN
1229: oe_debug_pub.add( 'Negotiate Header (OENH): '||OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW||' IS MISSING , BUT ID EXISTS IN GLOBAL' ) ;
1230: END IF;
1231: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW:= NULL;
1232: END;
1233: END IF;
1234:
1235: IF (OE_GLOBALS.G_START_BLANKET_HEADER_FLOW IS NOT NULL) THEN

Line 1235: IF (OE_GLOBALS.G_START_BLANKET_HEADER_FLOW IS NOT NULL) THEN

1231: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW:= NULL;
1232: END;
1233: END IF;
1234:
1235: IF (OE_GLOBALS.G_START_BLANKET_HEADER_FLOW IS NOT NULL) THEN
1236: BEGIN
1237: -- Sanity Check to verify that negotiate header exists
1238: -- The create of the header could have been rolled back
1239: -- but the PL/SQL global is not in synch.

Line 1243: where header_id = OE_GLOBALS.G_START_BLANKET_HEADER_FLOW;

1239: -- but the PL/SQL global is not in synch.
1240: Select header_id
1241: into l_header_id
1242: from oe_blanket_headers_all
1243: where header_id = OE_GLOBALS.G_START_BLANKET_HEADER_FLOW;
1244:
1245: IF l_debug_level > 0 THEN
1246: oe_debug_pub.add( 'STARTING BLANKET HEADER FLOW' ) ;
1247: END IF;

Line 1250: Start_Flow(OE_GLOBALS.G_WFI_BKT, OE_GLOBALS.G_START_BLANKET_HEADER_FLOW);

1246: oe_debug_pub.add( 'STARTING BLANKET HEADER FLOW' ) ;
1247: END IF;
1248:
1249: -- Start flow and clear global
1250: Start_Flow(OE_GLOBALS.G_WFI_BKT, OE_GLOBALS.G_START_BLANKET_HEADER_FLOW);
1251: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := NULL;
1252:
1253: EXCEPTION
1254: WHEN NO_DATA_FOUND THEN

Line 1251: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := NULL;

1247: END IF;
1248:
1249: -- Start flow and clear global
1250: Start_Flow(OE_GLOBALS.G_WFI_BKT, OE_GLOBALS.G_START_BLANKET_HEADER_FLOW);
1251: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := NULL;
1252:
1253: EXCEPTION
1254: WHEN NO_DATA_FOUND THEN
1255: IF l_debug_level > 0 THEN

Line 1256: oe_debug_pub.add( 'Blanket Header (OEBH): '||OE_GLOBALS.G_START_BLANKET_HEADER_FLOW||' IS MISSING , BUT ID EXISTS IN GLOBAL' ) ;

1252:
1253: EXCEPTION
1254: WHEN NO_DATA_FOUND THEN
1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'Blanket Header (OEBH): '||OE_GLOBALS.G_START_BLANKET_HEADER_FLOW||' IS MISSING , BUT ID EXISTS IN GLOBAL' ) ;
1257: END IF;
1258: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := NULL;
1259: END;
1260: END IF;

Line 1258: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := NULL;

1254: WHEN NO_DATA_FOUND THEN
1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'Blanket Header (OEBH): '||OE_GLOBALS.G_START_BLANKET_HEADER_FLOW||' IS MISSING , BUT ID EXISTS IN GLOBAL' ) ;
1257: END IF;
1258: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := NULL;
1259: END;
1260: END IF;
1261:
1262: -- End of OENH/OEBH handling

Line 1266: OE_GLOBALS.G_FLOW_PROCESSING_STARTED := FALSE;

1262: -- End of OENH/OEBH handling
1263:
1264:
1265: -- Reset global value
1266: OE_GLOBALS.G_FLOW_PROCESSING_STARTED := FALSE;
1267: END IF;
1268:
1269: IF l_debug_level > 0 THEN
1270: oe_debug_pub.add( 'EXITING START_ALL_FLOWS' ) ;

Line 1299: OE_GLOBALS.G_START_HEADER_FLOW := NULL;

1295: IF l_debug_level > 0 THEN
1296: oe_debug_pub.add( 'IN CLEAR_FLOWSTART_GLOBALS' ) ;
1297: END IF;
1298:
1299: OE_GLOBALS.G_START_HEADER_FLOW := NULL;
1300: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW:= NULL;
1301: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := NULL;
1302: OE_GLOBALS.G_START_LINE_FLOWS_TBL.DELETE;
1303: OE_GLOBALS.G_FLOW_PROCESSING_STARTED := FALSE;

Line 1300: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW:= NULL;

1296: oe_debug_pub.add( 'IN CLEAR_FLOWSTART_GLOBALS' ) ;
1297: END IF;
1298:
1299: OE_GLOBALS.G_START_HEADER_FLOW := NULL;
1300: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW:= NULL;
1301: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := NULL;
1302: OE_GLOBALS.G_START_LINE_FLOWS_TBL.DELETE;
1303: OE_GLOBALS.G_FLOW_PROCESSING_STARTED := FALSE;
1304:

Line 1301: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := NULL;

1297: END IF;
1298:
1299: OE_GLOBALS.G_START_HEADER_FLOW := NULL;
1300: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW:= NULL;
1301: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := NULL;
1302: OE_GLOBALS.G_START_LINE_FLOWS_TBL.DELETE;
1303: OE_GLOBALS.G_FLOW_PROCESSING_STARTED := FALSE;
1304:
1305: END Clear_FlowStart_Globals;

Line 1302: OE_GLOBALS.G_START_LINE_FLOWS_TBL.DELETE;

1298:
1299: OE_GLOBALS.G_START_HEADER_FLOW := NULL;
1300: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW:= NULL;
1301: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := NULL;
1302: OE_GLOBALS.G_START_LINE_FLOWS_TBL.DELETE;
1303: OE_GLOBALS.G_FLOW_PROCESSING_STARTED := FALSE;
1304:
1305: END Clear_FlowStart_Globals;
1306:

Line 1303: OE_GLOBALS.G_FLOW_PROCESSING_STARTED := FALSE;

1299: OE_GLOBALS.G_START_HEADER_FLOW := NULL;
1300: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW:= NULL;
1301: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := NULL;
1302: OE_GLOBALS.G_START_LINE_FLOWS_TBL.DELETE;
1303: OE_GLOBALS.G_FLOW_PROCESSING_STARTED := FALSE;
1304:
1305: END Clear_FlowStart_Globals;
1306:
1307:

Line 1327: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_HDR,

1323: oe_debug_pub.add( 'IN OE_ORDER_WF_UTIL.DELETE_ROW' ) ;
1324: END IF;
1325:
1326: IF p_type = 'HEADER' THEN
1327: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_HDR,
1328: itemkey => p_id,
1329: status => l_status,
1330: result => l_result);
1331: IF l_status <> 'COMPLETE' THEN

Line 1332: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_HDR,

1328: itemkey => p_id,
1329: status => l_status,
1330: result => l_result);
1331: IF l_status <> 'COMPLETE' THEN
1332: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_HDR,
1333: itemkey => p_id);
1334: END IF;
1335: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_HDR,
1336: itemkey => p_id,

Line 1335: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_HDR,

1331: IF l_status <> 'COMPLETE' THEN
1332: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_HDR,
1333: itemkey => p_id);
1334: END IF;
1335: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_HDR,
1336: itemkey => p_id,
1337: force => TRUE,
1338: docommit => false);
1339:

Line 1343: where item_type=OE_GLOBALS.G_WFI_NGO

1339:
1340: select count(1)
1341: into l_count
1342: from wf_items
1343: where item_type=OE_GLOBALS.G_WFI_NGO
1344: and item_key=to_char(p_id);
1345:
1346: IF l_count > 0 THEN
1347: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_NGO,

Line 1347: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_NGO,

1343: where item_type=OE_GLOBALS.G_WFI_NGO
1344: and item_key=to_char(p_id);
1345:
1346: IF l_count > 0 THEN
1347: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_NGO,
1348: itemkey => p_id,
1349: force => TRUE,
1350: docommit => false);
1351: END IF;

Line 1361: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_LIN,

1357: WHERE line_id = p_id;
1358:
1359: IF nvl(l_transaction_phase_code, 'F') <> 'N' THEN
1360:
1361: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_LIN,
1362: itemkey => p_id,
1363: status => l_status,
1364: result => l_result);
1365: --Added the nvl condition to fix bug 2333095

Line 1367: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_LIN,

1363: status => l_status,
1364: result => l_result);
1365: --Added the nvl condition to fix bug 2333095
1366: IF nvl(l_status,'ACTIVE') <> 'COMPLETE' THEN
1367: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_LIN,
1368: itemkey => p_id);
1369: END IF;
1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( 'PURGING WF ITEM' ) ;

Line 1373: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_LIN,

1369: END IF;
1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( 'PURGING WF ITEM' ) ;
1372: END IF;
1373: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_LIN,
1374: itemkey => p_id,
1375: force => TRUE,
1376: docommit => false);
1377: END IF;

Line 1380: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_NGO,

1376: docommit => false);
1377: END IF;
1378:
1379: ELSIF p_type = 'NEGOTIATE' THEN
1380: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_NGO,
1381: itemkey => p_id,
1382: status => l_status,
1383: result => l_result);
1384: IF nvl(l_status,'ACTIVE') <> 'COMPLETE' THEN

Line 1385: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_NGO,

1381: itemkey => p_id,
1382: status => l_status,
1383: result => l_result);
1384: IF nvl(l_status,'ACTIVE') <> 'COMPLETE' THEN
1385: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_NGO,
1386: itemkey => p_id);
1387: END IF;
1388: IF l_debug_level > 0 THEN
1389: oe_debug_pub.add( 'PURGING WF ITEM - Negotiate') ;

Line 1391: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_NGO,

1387: END IF;
1388: IF l_debug_level > 0 THEN
1389: oe_debug_pub.add( 'PURGING WF ITEM - Negotiate') ;
1390: END IF;
1391: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_NGO,
1392: itemkey => p_id,
1393: force => TRUE,
1394: docommit => false);
1395: ELSIF p_type = 'BLANKET' THEN

Line 1396: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_BKT,

1392: itemkey => p_id,
1393: force => TRUE,
1394: docommit => false);
1395: ELSIF p_type = 'BLANKET' THEN
1396: WF_ENGINE.ItemStatus(itemtype => OE_GLOBALS.G_WFI_BKT,
1397: itemkey => p_id,
1398: status => l_status,
1399: result => l_result);
1400: IF nvl(l_status,'ACTIVE') <> 'COMPLETE' THEN

Line 1401: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_BKT,

1397: itemkey => p_id,
1398: status => l_status,
1399: result => l_result);
1400: IF nvl(l_status,'ACTIVE') <> 'COMPLETE' THEN
1401: WF_ENGINE.AbortProcess(itemtype => OE_GLOBALS.G_WFI_BKT,
1402: itemkey => p_id);
1403: END IF;
1404: IF l_debug_level > 0 THEN
1405: oe_debug_pub.add( 'PURGING WF ITEM - BLANKET') ;

Line 1407: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_BKT,

1403: END IF;
1404: IF l_debug_level > 0 THEN
1405: oe_debug_pub.add( 'PURGING WF ITEM - BLANKET') ;
1406: END IF;
1407: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_BKT,
1408: itemkey => p_id,
1409: force => TRUE,
1410: docommit => false);
1411:

Line 1415: where item_type=OE_GLOBALS.G_WFI_NGO

1411:
1412: select count(1)
1413: into l_count
1414: from wf_items
1415: where item_type=OE_GLOBALS.G_WFI_NGO
1416: and item_key=to_char(p_id);
1417:
1418: IF l_count > 0 THEN
1419: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_NGO,

Line 1419: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_NGO,

1415: where item_type=OE_GLOBALS.G_WFI_NGO
1416: and item_key=to_char(p_id);
1417:
1418: IF l_count > 0 THEN
1419: WF_PURGE.Items(itemtype => OE_GLOBALS.G_WFI_NGO,
1420: itemkey => p_id,
1421: force => TRUE,
1422: docommit => false);
1423: END IF;

Line 1512: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

1508:
1509: x_return_status := FND_API.G_RET_STS_SUCCESS;
1510:
1511: -- Check if the ASO is installed to call the NOTIFY_OC.
1512: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
1513: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
1514: END IF;
1515:
1516: -- *** Negotiation Changes Start ***

Line 1513: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);

1509: x_return_status := FND_API.G_RET_STS_SUCCESS;
1510:
1511: -- Check if the ASO is installed to call the NOTIFY_OC.
1512: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
1513: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
1514: END IF;
1515:
1516: -- *** Negotiation Changes Start ***
1517: IF p_item_type in (OE_GLOBALS.G_WFI_NGO, OE_GLOBALS.G_WFI_BKT) THEN

Line 1517: IF p_item_type in (OE_GLOBALS.G_WFI_NGO, OE_GLOBALS.G_WFI_BKT) THEN

1513: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
1514: END IF;
1515:
1516: -- *** Negotiation Changes Start ***
1517: IF p_item_type in (OE_GLOBALS.G_WFI_NGO, OE_GLOBALS.G_WFI_BKT) THEN
1518: IF p_header_id IS NOT NULL THEN
1519: -- validate p_flow_status
1520: SELECT lookup_code
1521: INTO l_flow_status_code

Line 1529: IF p_item_type = OE_GLOBALS.G_WFI_NGO THEN

1525: AND enabled_flag = 'Y'
1526: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1527: AND NVL(END_DATE_ACTIVE, SYSDATE);
1528:
1529: IF p_item_type = OE_GLOBALS.G_WFI_NGO THEN
1530:
1531: IF p_sales_document_type_code is null THEN
1532: -- for Negotiation, you must pass the document type code
1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1621: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;

1617: -- update global picture directly
1618: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
1619: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
1620: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
1621: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
1622: IF l_debug_level > 0 THEN
1623: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE,1);
1624: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION,1);
1625: END IF;

Line 1687: ELSIF p_item_type = OE_GLOBALS.G_WFI_BKT THEN

1683: WHERE HEADER_ID = p_header_id;
1684:
1685: END IF; --check sales_document_type_code
1686:
1687: ELSIF p_item_type = OE_GLOBALS.G_WFI_BKT THEN
1688: IF l_debug_level > 0 THEN
1689: oe_debug_pub.add('Update_Flow_Status_Code for Blanket Fulfillment:' || p_flow_status_code, 5 ) ;
1690: END IF;
1691:

Line 1746: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR

1742: AND enabled_flag = 'Y'
1743: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1744: AND NVL(END_DATE_ACTIVE, SYSDATE);
1745:
1746: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1747: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
1748:
1749: OE_Line_Util.Lock_Rows
1750: (p_line_id=>p_line_id

Line 1868: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR

1864: last_update_login = FND_GLOBAL.LOGIN_ID,
1865: LOCK_CONTROL = LOCK_CONTROL + 1
1866: WHERE LINE_ID = p_line_id;
1867:
1868: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1869: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
1870:
1871:
1872: l_line_tbl(1).flow_status_code := p_flow_status_code;

Line 1906: OE_ORDER_UTIL.g_line_tbl(l_index).operation:=OE_GLOBALS.G_OPR_UPDATE;

1902: OE_ORDER_UTIL.g_line_tbl(l_index).lock_control:=l_line_tbl(1).lock_control;
1903: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:=l_line_tbl(1).line_id;
1904: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:=l_line_tbl(1).header_id;
1905: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:=l_line_tbl(1).last_update_date;
1906: OE_ORDER_UTIL.g_line_tbl(l_index).operation:=OE_GLOBALS.G_OPR_UPDATE;
1907: IF l_debug_level > 0 THEN
1908: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
1909: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .OPERATION , 1 ) ;
1910: END IF;

Line 2047: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;

2043: -- update global picture directly
2044: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
2045: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
2046: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
2047: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2048: IF l_debug_level > 0 THEN
2049: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
2050: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION , 1 ) ;
2051: END IF;

Line 2327: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

2323:
2324: x_return_status := FND_API.G_RET_STS_SUCCESS;
2325:
2326: -- Check if the ASO is installed to call the NOTIFY_OC.
2327: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
2328: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
2329: END IF;
2330:
2331: l_header_id := to_number(p_item_key);

Line 2328: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);

2324: x_return_status := FND_API.G_RET_STS_SUCCESS;
2325:
2326: -- Check if the ASO is installed to call the NOTIFY_OC.
2327: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
2328: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
2329: END IF;
2330:
2331: l_header_id := to_number(p_item_key);
2332: IF p_flow_status_code is not null THEN

Line 2345: IF p_item_type = OE_GLOBALS.G_WFI_BKT THEN

2341: AND NVL(END_DATE_ACTIVE, SYSDATE);
2342:
2343: END IF;
2344:
2345: IF p_item_type = OE_GLOBALS.G_WFI_BKT THEN
2346: l_sales_document_type_code := 'B';
2347: ELSE -- itemtype = OENH
2348: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(p_item_type, p_item_key, 'SALES_DOCUMENT_TYPE_CODE');
2349: END IF;

Line 2476: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;

2472: IF p_draft_submitted_flag is not null THEN
2473: OE_ORDER_UTIL.g_header_rec.draft_submitted_flag:=p_draft_submitted_flag;
2474: END IF;
2475: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
2476: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2477: IF l_debug_level > 0 THEN
2478: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 );
2479: oe_debug_pub.add( 'GLOBAL HEADER OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 );
2480: oe_debug_pub.add( 'GLOBAL HEADER DRAFT_SUBMITTED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.DRAFT_SUBMITTED_FLAG , 1 );

Line 2770: IF p_item_type = OE_GLOBALS.G_WFI_NGO THEN

2766: END IF;
2767:
2768: Create_HdrWorkItemInternal(p_item_type, p_header_id, p_transaction_number, p_sales_document_type_code);
2769:
2770: IF p_item_type = OE_GLOBALS.G_WFI_NGO THEN
2771: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW := p_header_id;
2772: ELSIF p_item_type = OE_GLOBALS.G_WFI_BKT THEN
2773: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := p_header_id;
2774: -- For OEBH

Line 2771: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW := p_header_id;

2767:
2768: Create_HdrWorkItemInternal(p_item_type, p_header_id, p_transaction_number, p_sales_document_type_code);
2769:
2770: IF p_item_type = OE_GLOBALS.G_WFI_NGO THEN
2771: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW := p_header_id;
2772: ELSIF p_item_type = OE_GLOBALS.G_WFI_BKT THEN
2773: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := p_header_id;
2774: -- For OEBH
2775: -- Check if a OENH flow exists, if so set the parent

Line 2772: ELSIF p_item_type = OE_GLOBALS.G_WFI_BKT THEN

2768: Create_HdrWorkItemInternal(p_item_type, p_header_id, p_transaction_number, p_sales_document_type_code);
2769:
2770: IF p_item_type = OE_GLOBALS.G_WFI_NGO THEN
2771: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW := p_header_id;
2772: ELSIF p_item_type = OE_GLOBALS.G_WFI_BKT THEN
2773: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := p_header_id;
2774: -- For OEBH
2775: -- Check if a OENH flow exists, if so set the parent
2776: SELECT count(1)

Line 2773: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := p_header_id;

2769:
2770: IF p_item_type = OE_GLOBALS.G_WFI_NGO THEN
2771: OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW := p_header_id;
2772: ELSIF p_item_type = OE_GLOBALS.G_WFI_BKT THEN
2773: OE_GLOBALS.G_START_BLANKET_HEADER_FLOW := p_header_id;
2774: -- For OEBH
2775: -- Check if a OENH flow exists, if so set the parent
2776: SELECT count(1)
2777: INTO l_count

Line 2779: WHERE item_type=OE_GLOBALS.G_WFI_NGO

2775: -- Check if a OENH flow exists, if so set the parent
2776: SELECT count(1)
2777: INTO l_count
2778: FROM wf_items
2779: WHERE item_type=OE_GLOBALS.G_WFI_NGO
2780: AND item_key =to_char(p_header_id);
2781:
2782: IF l_count > 0 THEN
2783: WF_ITEM.Set_Item_Parent(OE_GLOBALS.G_WFI_BKT,

Line 2783: WF_ITEM.Set_Item_Parent(OE_GLOBALS.G_WFI_BKT,

2779: WHERE item_type=OE_GLOBALS.G_WFI_NGO
2780: AND item_key =to_char(p_header_id);
2781:
2782: IF l_count > 0 THEN
2783: WF_ITEM.Set_Item_Parent(OE_GLOBALS.G_WFI_BKT,
2784: to_char(p_header_id),
2785: OE_GLOBALS.G_WFI_NGO,
2786: to_char(p_header_id), '');
2787: END IF;

Line 2785: OE_GLOBALS.G_WFI_NGO,

2781:
2782: IF l_count > 0 THEN
2783: WF_ITEM.Set_Item_Parent(OE_GLOBALS.G_WFI_BKT,
2784: to_char(p_header_id),
2785: OE_GLOBALS.G_WFI_NGO,
2786: to_char(p_header_id), '');
2787: END IF;
2788:
2789: END IF;

Line 2791: OE_GLOBALS.G_SALES_DOCUMENT_TYPE_CODE := p_sales_document_type_code;

2787: END IF;
2788:
2789: END IF;
2790:
2791: OE_GLOBALS.G_SALES_DOCUMENT_TYPE_CODE := p_sales_document_type_code;
2792:
2793: IF l_debug_level > 0 THEN
2794: oe_debug_pub.add( 'EXITING CREATESTART_HDRPROCESSINTERNAL' ) ;
2795: END IF;

Line 2890: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);

2886: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
2887: l_aname(3) := 'RESPONSIBILITY_ID';
2888: l_avalue(3) := FND_GLOBAL.RESP_ID;
2889: l_aname(4) := 'ORG_ID';
2890: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
2891: l_aname(5) := 'TRANSACTION_NUMBER';
2892: l_avalue(5) := p_transaction_number;
2893:
2894: IF p_item_type = OE_GLOBALS.G_WFI_NGO THEN

Line 2894: IF p_item_type = OE_GLOBALS.G_WFI_NGO THEN

2890: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
2891: l_aname(5) := 'TRANSACTION_NUMBER';
2892: l_avalue(5) := p_transaction_number;
2893:
2894: IF p_item_type = OE_GLOBALS.G_WFI_NGO THEN
2895: l_aname(6) := 'HEADER_ID';
2896: l_avalue(6) := p_header_id;
2897: END IF;
2898:

Line 2922: IF p_item_type = OE_GLOBALS.G_WFI_NGO THEN

2918: to_char(p_header_id),
2919: 'NOTIFICATION_FROM_ROLE',
2920: l_user_name);
2921:
2922: IF p_item_type = OE_GLOBALS.G_WFI_NGO THEN
2923: -- if this is a negotiation flow, set some item attributes that
2924: -- only apply to negotiations
2925:
2926: l_aname2(1) := 'SALES_DOCUMENT_TYPE_CODE';

Line 2978: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_NGO

2974: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));
2975: END IF;
2976:
2977: l_user_key := substrb(fnd_message.get, 1, 240);
2978: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_NGO
2979: , p_header_id
2980: , l_user_key);
2981: EXCEPTION
2982: WHEN OTHERS THEN

Line 3005: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_BKT

3001: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
3002: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));
3003:
3004: l_user_key := substrb(fnd_message.get, 1, 240);
3005: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_BKT
3006: , p_header_id
3007: , l_user_key);
3008: EXCEPTION
3009: WHEN OTHERS THEN

Line 3060: OE_GLOBALS.G_WFI_NGO,

3056: if l_item_type = 'OEBH' THEN
3057: l_blanket_flag := 'Y';
3058: else
3059: l_sales_document_type_code := wf_engine.GetItemAttrText(
3060: OE_GLOBALS.G_WFI_NGO,
3061: l_item_key,
3062: 'SALES_DOCUMENT_TYPE_CODE');
3063: if l_sales_document_type_code = 'B' then
3064: l_blanket_flag := 'Y';

Line 3888: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO,

3884: IF l_debug_level > 0 THEN
3885: oe_debug_pub.add('ELIGIBLE Activity: ' || l_activity);
3886: END IF;
3887:
3888: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO,
3889: to_char(p_header_id), l_activity, l_retval);
3890: -- The order could have been booked already becuase the booking was synchronous.
3891: select booked_flag, flow_status_code
3892: into l_booked_flag, l_flow_status_code