DBA Data[Home] [Help]

APPS.OE_APPROVALS_WF dependencies on OE_SYS_PARAMETERS

Line 908: IF nvl(OE_SYS_PARAMETERS.value('NO_RESPONSE_FROM_APPROVER'), 'CONTINUE') ='CONTINUE' THEN

904: oe_debug_pub.add('Approval_Timeout.. ', 1) ;
905: END IF;
906:
907:
908: IF nvl(OE_SYS_PARAMETERS.value('NO_RESPONSE_FROM_APPROVER'), 'CONTINUE') ='CONTINUE' THEN
909:
910: -- If the current approver is the last in the list, then still reject it.
911: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
912: l_sales_document_type_code := wf_engine.GetItemAttrText(

Line 1515: IF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'),

1511: END IF ;
1512: EXCEPTION
1513: WHEN OTHERS
1514: THEN
1515: IF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'),
1516: 'REJECTION'
1517: ) = 'APPROVAL'
1518: THEN
1519: resultout := 'COMPLETE:NO_NEXT_APPROVER';

Line 1521: ELSIF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'),

1517: ) = 'APPROVAL'
1518: THEN
1519: resultout := 'COMPLETE:NO_NEXT_APPROVER';
1520: RETURN;
1521: ELSIF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'),
1522: 'REJECTION'
1523: ) = 'REJECTION'
1524: THEN
1525: resultout := 'COMPLETE:INVALID_APPROVER';

Line 1549: IF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'),

1545: );
1546: EXCEPTION
1547: WHEN OTHERS
1548: THEN
1549: IF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'),
1550: 'REJECTION'
1551: ) = 'APPROVAL'
1552: THEN
1553: resultout := 'COMPLETE:NO_NEXT_APPROVER';

Line 1555: ELSIF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'),

1551: ) = 'APPROVAL'
1552: THEN
1553: resultout := 'COMPLETE:NO_NEXT_APPROVER';
1554: RETURN;
1555: ELSIF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'),
1556: 'REJECTION'
1557: ) = 'REJECTION'
1558: THEN
1559: resultout := 'COMPLETE:INVALID_APPROVER';

Line 2186: IF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'), 'REJECTION') =

2182: IF l_debug_level >0 THEN
2183: oe_debug_pub.ADD ('Inside treat_ame_exception_as');
2184: END IF ;
2185:
2186: IF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'), 'REJECTION') =
2187: 'APPROVAL'
2188: THEN
2189: resultout := 'COMPLETE:APPROVAL';
2190: IF l_debug_level > 0 THEN

Line 2195: ELSIF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'), 'REJECTION') =

2191: oe_debug_pub.ADD ('Treating as approval');
2192: END IF ;
2193: oe_standard_wf.clear_msg_context;
2194: RETURN;
2195: ELSIF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'), 'REJECTION') =
2196: 'REJECTION'
2197: THEN
2198: FOR i IN get_all_children
2199: LOOP

Line 3536: IF NVL (oe_sys_parameters.VALUE ('NO_RESPONSE_FROM_APPROVER'),

3532: THEN
3533: oe_debug_pub.ADD ('Approval_Timeout ame.. ', 1);
3534: END IF;
3535:
3536: IF NVL (oe_sys_parameters.VALUE ('NO_RESPONSE_FROM_APPROVER'),
3537: 'CONTINUE'
3538: ) = 'CONTINUE'
3539: THEN
3540: --just check the sys param value for AME. Last approver concept is not applicable here