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 199: l_start_from_flow := OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM;

195:
196: l_event_name := 'oracle.apps.ont.oi.po_ack.create';
197:
198: If l_start_from_flow is null then
199: l_start_from_flow := OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM;
200: End If;
201:
202: IF l_debug_level > 0 THEN
203: oe_debug_pub.add( 'L_START_FROM_FLOW = '||L_START_FROM_FLOW ) ;

Line 287: If l_itemtype <> OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM then

283:
284: l_parameter_list.DELETE;
285:
286: -- Up to your own code to commit the transaction
287: If l_itemtype <> OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM then
288: IF l_debug_level > 0 THEN
289: oe_debug_pub.add( 'BEFORE COMMIT' ) ;
290: END IF;
291: Commit;

Line 458: l_itemtype := OE_ORDER_IMPORT_WF.G_WFI_PROC;

454: oe_debug_pub.add( 'AFTER ADD PARAMETERS' ) ;
455: END IF;
456:
457: If p_itemtype Is Null Then
458: l_itemtype := OE_ORDER_IMPORT_WF.G_WFI_PROC;
459: Else
460: l_itemtype := p_itemtype;
461: End If;
462: wf_event.AddParameterToList(p_name=> 'START_FROM_FLOW',

Line 471: IF l_itemtype = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM THEN

467: oe_debug_pub.add( 'start_from_flow:' || l_itemtype) ;
468: END IF;
469:
470: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
471: IF l_itemtype = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM THEN
472: wf_event.AddParameterToList(p_name=> 'REQ_ID',
473: p_value=> p_request_id,
474: p_parameterlist=> l_parameter_list);
475: END IF;

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

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

Line 497: If l_itemtype <> OE_ORDER_IMPORT_WF.G_WFI_PROC AND

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

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

1083: p_header_id IN NUMBER := NULL,
1084: p_line_id IN NUMBER := NULL,
1085: p_msg_id IN NUMBER := NULL,
1086: p_request_id IN NUMBER := NULL,
1087: p_itemtype IN VARCHAR2 := OE_ORDER_IMPORT_WF.G_WFI_ORDER_ACK,
1088: p_start_from_flow IN VARCHAR2 := OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,
1089: p_transaction_type IN VARCHAR2 := NULL,
1090: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1091: )

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

1084: p_line_id IN NUMBER := NULL,
1085: p_msg_id IN NUMBER := NULL,
1086: p_request_id IN NUMBER := NULL,
1087: p_itemtype IN VARCHAR2 := OE_ORDER_IMPORT_WF.G_WFI_ORDER_ACK,
1088: p_start_from_flow IN VARCHAR2 := OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,
1089: p_transaction_type IN VARCHAR2 := NULL,
1090: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1091: )
1092: IS

Line 1323: If p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_PROC Then

1319: --retrieving seeded header status in case of 3a6 generated from PROC
1320: If p_transaction_type = G_TRANSACTION_SSO Or p_transaction_type = G_TRANSACTION_CSO Then
1321:
1322:
1323: If p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_PROC Then
1324:
1325: Select last_ack_code
1326: into l_header_last_ack_code
1327: from oe_header_acks

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

1367: END IF;
1368:
1369: Begin
1370: If (p_start_from_flow = Oe_Globals.G_WFI_LIN And p_line_id Is Not Null)
1371: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT And p_transaction_type = G_TRANSACTION_POI)
1372: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM And p_transaction_type = G_TRANSACTION_POI)
1373: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_SSO)
1374: Or (p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM And p_transaction_type = G_TRANSACTION_CSO) Then
1375: IF l_debug_level > 0 THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1457: If p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_PROC Then

1453: End;
1454:
1455: End If;
1456:
1457: If p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_PROC Then
1458: IF l_debug_level > 0 THEN
1459: oe_debug_pub.add( 'G_WFI_PROC FLOW' ) ;
1460: END IF;
1461: -- l_acknowledgment_type := G_TRANSACTION_SSO;

Line 3038: p_itemtype => OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM,

3034: p_orig_sys_document_ref => l_order_rec.orig_sys_document_ref(i),
3035: p_change_sequence => l_order_rec.change_sequence(i),
3036: p_party_id => l_party_id,
3037: p_party_site_id => l_party_site_id,
3038: p_itemtype => OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM,
3039: p_request_id => l_request_id,
3040: p_org_id => l_order_rec.org_id(i),
3041: x_return_status => l_return_status );
3042: IF l_debug_level > 0 THEN