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_ACKNOWLEDGMENT_PUB dependencies on OE_ORDER_IMPORT_WF

Line 194: l_start_from_flow := OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM;

190:
191: l_event_name := 'oracle.apps.ont.oi.po_ack.create';
192:
193: If l_start_from_flow is null then
194: l_start_from_flow := OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM;
195: End If;
196:
197: IF l_debug_level > 0 THEN
198: oe_debug_pub.add( 'L_START_FROM_FLOW = '||L_START_FROM_FLOW ) ;

Line 282: If l_itemtype <> OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM then

278:
279: l_parameter_list.DELETE;
280:
281: -- Up to your own code to commit the transaction
282: If l_itemtype <> OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM then
283: IF l_debug_level > 0 THEN
284: oe_debug_pub.add( 'BEFORE COMMIT' ) ;
285: END IF;
286: Commit;

Line 453: l_itemtype := OE_ORDER_IMPORT_WF.G_WFI_PROC;

449: oe_debug_pub.add( 'AFTER ADD PARAMETERS' ) ;
450: END IF;
451:
452: If p_itemtype Is Null Then
453: l_itemtype := OE_ORDER_IMPORT_WF.G_WFI_PROC;
454: Else
455: l_itemtype := p_itemtype;
456: End If;
457: wf_event.AddParameterToList(p_name=> 'START_FROM_FLOW',

Line 466: IF l_itemtype = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM THEN

462: oe_debug_pub.add( 'start_from_flow:' || l_itemtype) ;
463: END IF;
464:
465: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
466: IF l_itemtype = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM THEN
467: wf_event.AddParameterToList(p_name=> 'REQ_ID',
468: p_value=> p_request_id,
469: p_parameterlist=> l_parameter_list);
470: END IF;

Line 475: oe_order_import_wf.call_wf_purge(p_itemtype => 'OESO',

471: END IF;
472:
473: /* Not needed now with unique itemkey, remove after testing
474: -- Purge any existing workflow with the same itemkey/itemtype
475: oe_order_import_wf.call_wf_purge(p_itemtype => 'OESO',
476: p_itemkey => l_itemkey);
477: */
478: -- Raise the event with no XML document, if an XML
479: -- document is required to be generated, the Generate Function

Line 492: If l_itemtype <> OE_ORDER_IMPORT_WF.G_WFI_PROC AND

488:
489: l_parameter_list.DELETE;
490:
491: -- Up to your own code to commit the transaction
492: If l_itemtype <> OE_ORDER_IMPORT_WF.G_WFI_PROC AND
493: p_commit_flag = 'Y' then
494: IF l_debug_level > 0 THEN
495: oe_debug_pub.add( 'BEFORE COMMIT' ) ;
496: END IF;

Line 1082: p_itemtype IN VARCHAR2 := OE_ORDER_IMPORT_WF.G_WFI_ORDER_ACK,

1078: p_header_id IN NUMBER := NULL,
1079: p_line_id IN NUMBER := NULL,
1080: p_msg_id IN NUMBER := NULL,
1081: p_request_id IN NUMBER := NULL,
1082: p_itemtype IN VARCHAR2 := OE_ORDER_IMPORT_WF.G_WFI_ORDER_ACK,
1083: p_start_from_flow IN VARCHAR2 := OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,
1084: p_transaction_type IN VARCHAR2 := NULL,
1085: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1086: )

Line 1083: p_start_from_flow IN VARCHAR2 := OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,

1079: p_line_id IN NUMBER := NULL,
1080: p_msg_id IN NUMBER := NULL,
1081: p_request_id IN NUMBER := NULL,
1082: p_itemtype IN VARCHAR2 := OE_ORDER_IMPORT_WF.G_WFI_ORDER_ACK,
1083: p_start_from_flow IN VARCHAR2 := OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,
1084: p_transaction_type IN VARCHAR2 := NULL,
1085: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1086: )
1087: IS

Line 1318: If p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_PROC Then

1314: --retrieving seeded header status in case of 3a6 generated from PROC
1315: If p_transaction_type = G_TRANSACTION_SSO Or p_transaction_type = G_TRANSACTION_CSO Then
1316:
1317:
1318: If p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_PROC Then
1319:
1320: Select last_ack_code
1321: into l_header_last_ack_code
1322: from oe_header_acks

Line 1366: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_POI)

1362: END IF;
1363:
1364: Begin
1365: If (p_start_from_flow = Oe_Globals.G_WFI_LIN And p_line_id Is Not Null)
1366: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_POI)
1367: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_POI)
1368: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_SSO)
1369: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_CSO) Then
1370: IF l_debug_level > 0 THEN

Line 1367: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_POI)

1363:
1364: Begin
1365: If (p_start_from_flow = Oe_Globals.G_WFI_LIN And p_line_id Is Not Null)
1366: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_POI)
1367: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_POI)
1368: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_SSO)
1369: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_CSO) Then
1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( 'IN IF STATEMENT' ) ;

Line 1368: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_SSO)

1364: Begin
1365: If (p_start_from_flow = Oe_Globals.G_WFI_LIN And p_line_id Is Not Null)
1366: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_POI)
1367: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_POI)
1368: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_SSO)
1369: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_CSO) Then
1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( 'IN IF STATEMENT' ) ;
1372: oe_debug_pub.add( P_START_FROM_FLOW || ' FLOW , WITH LINE_ID => ' || P_LINE_ID ) ;

Line 1369: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_CSO) Then

1365: If (p_start_from_flow = Oe_Globals.G_WFI_LIN And p_line_id Is Not Null)
1366: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_POI)
1367: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_POI)
1368: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_SSO)
1369: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_CSO) Then
1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( 'IN IF STATEMENT' ) ;
1372: oe_debug_pub.add( P_START_FROM_FLOW || ' FLOW , WITH LINE_ID => ' || P_LINE_ID ) ;
1373: oe_debug_pub.add( 'TRANSACTION_TYPE ' || P_TRANSACTION_TYPE ) ;

Line 1401: If (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_CPO)

1397: -- Start line query for 3A9
1398: -- Send all the lines if the Order is Cancelled or else send only the Partially cancelled lines
1399: -- We reuse same logic for 3a8 i.e. only ack back the changed lines, which are derived using the request id
1400: -- so we pick all lines which have the same request id as the header because we know these were changed last
1401: If (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_CPO)
1402: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_CPO)
1403: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_CHO)
1404: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_CHO) Then
1405: IF l_debug_level > 0 THEN

Line 1402: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_CPO)

1398: -- Send all the lines if the Order is Cancelled or else send only the Partially cancelled lines
1399: -- We reuse same logic for 3a8 i.e. only ack back the changed lines, which are derived using the request id
1400: -- so we pick all lines which have the same request id as the header because we know these were changed last
1401: If (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_CPO)
1402: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_CPO)
1403: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_CHO)
1404: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_CHO) Then
1405: IF l_debug_level > 0 THEN
1406: oe_debug_pub.add( 'IN IF STATEMENT WITH TRANSACTION TYPE = '|| p_transaction_type ) ;

Line 1403: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_CHO)

1399: -- We reuse same logic for 3a8 i.e. only ack back the changed lines, which are derived using the request id
1400: -- so we pick all lines which have the same request id as the header because we know these were changed last
1401: If (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_CPO)
1402: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_CPO)
1403: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_CHO)
1404: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_CHO) Then
1405: IF l_debug_level > 0 THEN
1406: oe_debug_pub.add( 'IN IF STATEMENT WITH TRANSACTION TYPE = '|| p_transaction_type ) ;
1407: END IF;

Line 1404: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_CHO) Then

1400: -- so we pick all lines which have the same request id as the header because we know these were changed last
1401: If (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_CPO)
1402: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_CPO)
1403: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_CHO)
1404: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_CHO) Then
1405: IF l_debug_level > 0 THEN
1406: oe_debug_pub.add( 'IN IF STATEMENT WITH TRANSACTION TYPE = '|| p_transaction_type ) ;
1407: END IF;
1408: Begin

Line 1452: If p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_PROC Then

1448: End;
1449:
1450: End If;
1451:
1452: If p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_PROC Then
1453: IF l_debug_level > 0 THEN
1454: oe_debug_pub.add( 'G_WFI_PROC FLOW' ) ;
1455: END IF;
1456: -- l_acknowledgment_type := G_TRANSACTION_SSO;

Line 2922: p_itemtype => OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM,

2918: p_orig_sys_document_ref => l_order_rec.orig_sys_document_ref(i),
2919: p_change_sequence => l_order_rec.change_sequence(i),
2920: p_party_id => l_party_id,
2921: p_party_site_id => l_party_site_id,
2922: p_itemtype => OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM,
2923: p_request_id => l_request_id,
2924: p_org_id => l_order_rec.org_id(i),
2925: x_return_status => l_return_status );
2926: IF l_debug_level > 0 THEN