DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on WF_ENGINE

Line 8078: RETURN( WF_ENGINE.Activity_Exist_In_Process(

8074: SELECT header_id
8075: INTO l_header_id
8076: FROM oe_order_lines
8077: WHERE line_id = p_line_id;
8078: RETURN( WF_ENGINE.Activity_Exist_In_Process(
8079: p_item_type => OE_GLOBALS.G_WFI_HDR
8080: ,p_item_key => to_char(l_header_id)
8081: ,p_activity_name => 'HEADER_INVOICE_INTERFACE'));
8082: END Header_Activity;

Line 8098: RETURN( WF_ENGINE.Activity_Exist_In_Process(

8094: -- This function is provided by WF for our use with bug# 1040262.
8095: -- WF team removed this function at one stage and now provided the same
8096: -- for backward compatibility purpose with bug# 1869241.
8097: -- Issue with invoice interface due the the missing wf function is reported in bug# 1868026.
8098: RETURN( WF_ENGINE.Activity_Exist_In_Process(
8099: p_item_type => OE_GLOBALS.G_WFI_LIN
8100: ,p_item_key => to_char(p_line_id)
8101: ,p_activity_name => 'INVOICE_INTERFACE'));
8102: END Line_Activity;

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

8511: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
8512: IF l_debug_level > 0 THEN
8513: oe_debug_pub.add( 'RFR-PENDING LINE INTERFACED SUCCESSFULLY' , 5 ) ;
8514: END IF;
8515: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
8516: END IF;
8517: END IF;
8518: END IF;
8519: END LOOP;

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

9345: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
9346: IF l_debug_level > 0 THEN
9347: oe_debug_pub.add( 'RFR-PENDING LINE INTERFACED SUCCESSFULLY' , 5 ) ;
9348: END IF;
9349: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9350: END IF;
9351: END IF;
9352: END IF;
9353: END LOOP;

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

9776: IF l_debug_level > 0 THEN
9777: oe_debug_pub.add( 'RFR: MANUAL-PENDING + RFR LINE HAS BEEN FULLY INVOICED' , 5 ) ;
9778: oe_debug_pub.add( 'NOW COMPLETING THE WF BLOCK ACTIVITY' , 5 ) ;
9779: END IF;
9780: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9781: END IF;
9782: END IF;
9783: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN -- RFR line is partially invoiced
9784: IF l_debug_level > 0 THEN

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

9844: IF l_debug_level > 0 THEN
9845: oe_debug_pub.add( 'MANUAL-PENDING LINE HAS BEEN INVOICED' , 5 ) ;
9846: oe_debug_pub.add( 'NOW COMPLETING THE WF BLOCK ACTIVITY' , 5 ) ;
9847: END IF;
9848: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9849: END IF;
9850: END IF; -- check for interface_single_line result
9851: END IF; -- check for PTO
9852: END IF; -- Bug2181628.Process the line.

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

9974: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
9975: IF l_debug_level > 0 THEN
9976: oe_debug_pub.add( 'RFR: RFR-PENDING LINE INTERFACED SUCCESSFULLY , COMPLETING BLOCK' , 5 ) ;
9977: END IF;
9978: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9979: END IF;
9980: END IF;
9981: END IF;
9982: END LOOP;