DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on WF_ENGINE

Line 7694: RETURN( WF_ENGINE.Activity_Exist_In_Process(

7690: SELECT header_id
7691: INTO l_header_id
7692: FROM oe_order_lines
7693: WHERE line_id = p_line_id;
7694: RETURN( WF_ENGINE.Activity_Exist_In_Process(
7695: p_item_type => OE_GLOBALS.G_WFI_HDR
7696: ,p_item_key => to_char(l_header_id)
7697: ,p_activity_name => 'HEADER_INVOICE_INTERFACE'));
7698: END Header_Activity;

Line 7714: RETURN( WF_ENGINE.Activity_Exist_In_Process(

7710: -- This function is provided by WF for our use with bug# 1040262.
7711: -- WF team removed this function at one stage and now provided the same
7712: -- for backward compatibility purpose with bug# 1869241.
7713: -- Issue with invoice interface due the the missing wf function is reported in bug# 1868026.
7714: RETURN( WF_ENGINE.Activity_Exist_In_Process(
7715: p_item_type => OE_GLOBALS.G_WFI_LIN
7716: ,p_item_key => to_char(p_line_id)
7717: ,p_activity_name => 'INVOICE_INTERFACE'));
7718: END Line_Activity;

Line 8120: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

8116: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
8117: IF l_debug_level > 0 THEN
8118: oe_debug_pub.add( 'RFR-PENDING LINE INTERFACED SUCCESSFULLY' , 5 ) ;
8119: END IF;
8120: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
8121: END IF;
8122: END IF;
8123: END IF;
8124: END LOOP;

Line 8798: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

8794: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
8795: IF l_debug_level > 0 THEN
8796: oe_debug_pub.add( 'RFR-PENDING LINE INTERFACED SUCCESSFULLY' , 5 ) ;
8797: END IF;
8798: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
8799: END IF;
8800: END IF;
8801: END IF;
8802: END LOOP;

Line 9220: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

9216: IF l_debug_level > 0 THEN
9217: oe_debug_pub.add( 'RFR: MANUAL-PENDING + RFR LINE HAS BEEN FULLY INVOICED' , 5 ) ;
9218: oe_debug_pub.add( 'NOW COMPLETING THE WF BLOCK ACTIVITY' , 5 ) ;
9219: END IF;
9220: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9221: END IF;
9222: END IF;
9223: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN -- RFR line is partially invoiced
9224: IF l_debug_level > 0 THEN

Line 9288: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

9284: IF l_debug_level > 0 THEN
9285: oe_debug_pub.add( 'MANUAL-PENDING LINE HAS BEEN INVOICED' , 5 ) ;
9286: oe_debug_pub.add( 'NOW COMPLETING THE WF BLOCK ACTIVITY' , 5 ) ;
9287: END IF;
9288: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9289: END IF;
9290: END IF; -- check for interface_single_line result
9291: END IF; -- check for PTO
9292: END IF; -- Bug2181628.Process the line.

Line 9418: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

9414: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
9415: IF l_debug_level > 0 THEN
9416: oe_debug_pub.add( 'RFR: RFR-PENDING LINE INTERFACED SUCCESSFULLY , COMPLETING BLOCK' , 5 ) ;
9417: END IF;
9418: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9419: END IF;
9420: END IF;
9421: END IF;
9422: END LOOP;