APPS.IGC_CC_APPROVAL_WF_PKG dependencies on DUAL

Line 1392: FROM dual;

1388: 'E','PRINN',
1389: 'F','PRINN'
1390: )
1391: INTO l_new_state
1392: FROM dual;
1393: ELSIF l_total_state='PRINP' THEN
1394: SELECT decode(p_action,
1395: 'A','PRAPP',
1396: 'R','PRRJP',

Line 1400: FROM dual;

1396: 'R','PRRJP',
1397: 'E','PRINP'
1398: ) -- No Failed action
1399: INTO l_new_state
1400: FROM dual;
1401: ELSIF l_total_state='PRRRN' THEN
1402: SELECT decode(p_action,
1403: 'A','PRAP'||decode(g_bc_reqired,'Y','P','N'),
1404: 'R','PRRJN',

Line 1409: FROM dual;

1405: 'E','PRRRN',
1406: 'F','PRRRN'
1407: )
1408: INTO l_new_state
1409: FROM dual;
1410: ELSIF l_total_state='PRRRP' THEN
1411: SELECT decode(p_action,
1412: 'A','PRAPP',
1413: 'R','PRRJP',

Line 1417: FROM dual;

1413: 'R','PRRJP',
1414: 'E','PRRRP'
1415: ) -- No Failed action
1416: INTO l_new_state
1417: FROM dual;
1418: ELSIF l_total_state='CMINN' THEN --5
1419: SELECT decode(p_action,
1420: 'A','CMAP'||decode(g_bc_reqired,'Y','C','N'),
1421: 'R','PRRRN',

Line 1426: FROM dual;

1422: 'E','CMINN',
1423: 'F','CMRJN'
1424: )
1425: INTO l_new_state
1426: FROM dual;
1427: ELSIF l_total_state='CMINT' THEN --6
1428: SELECT decode(p_action,
1429: 'A','CMAPC',
1430: 'R','PRRRP',

Line 1435: FROM dual;

1431: 'E','CMINT',
1432: 'F','CMRJT'
1433: )
1434: INTO l_new_state
1435: FROM dual;
1436:
1437: IF p_action = 'R' THEN --Rollback to provisional enc needed
1438: g_restore_enc :=TRUE;
1439: END IF;

Line 1448: FROM dual;

1444: 'R','CMRJC',
1445: 'E','CMINC'
1446: )
1447: INTO l_new_state
1448: FROM dual;
1449: ELSIF l_total_state='CMRRN' THEN --8
1450: SELECT decode(p_action,
1451: 'A','CMAP'||decode(g_bc_reqired,'Y','C','N'),
1452: 'R','CMRJN',

Line 1457: FROM dual;

1453: 'E','CMRRN',
1454: 'F','CMRRN'
1455: )
1456: INTO l_new_state
1457: FROM dual;
1458: ELSIF l_total_state='CMRRC' THEN --9
1459: SELECT decode(p_action,
1460: 'A','CMAPC',
1461: 'R','CMRJC',

Line 1465: FROM dual;

1461: 'R','CMRJC',
1462: 'E','CMRRC'
1463: )
1464: INTO l_new_state
1465: FROM dual;
1466: ELSIF l_total_state='CLINN' THEN --10
1467: -- l_old_appr_status:= Get old status from history
1468: l_old_appr_status:= Get_Last_App_status;
1469: SELECT decode(p_action,

Line 1475: FROM dual;

1471: 'R','PR'||l_old_appr_status||'N',
1472: 'E','CLINN'
1473: )
1474: INTO l_new_state
1475: FROM dual;
1476: ELSIF l_total_state='CLINP' THEN --11
1477: -- Get old status from history
1478: l_old_appr_status:= Get_Last_App_status;
1479: SELECT decode(p_action,

Line 1485: FROM dual;

1481: 'R','PR'||l_old_appr_status||'P',
1482: 'E','CLINP'
1483: )
1484: INTO l_new_state
1485: FROM dual;
1486:
1487: ELSIF l_total_state='CTINC' THEN --12
1488: SELECT decode(p_action,
1489: 'A','CTAPN',

Line 1495: FROM dual;

1491: 'E','CTINC',
1492: 'F','CTINC'
1493: )
1494: INTO l_new_state
1495: FROM dual;
1496: ELSIF l_total_state='CTINNC' THEN --13
1497: SELECT decode(p_action,
1498: 'A','CTAPN',
1499: 'R','CMAPN',

Line 1503: FROM dual;

1499: 'R','CMAPN',
1500: 'E','CTINN'
1501: )
1502: INTO l_new_state
1503: FROM dual;
1504: ELSIF g_cc_appr_status ='RJ' AND g_cc_state IN ('PR','CM') THEN
1505: SELECT decode(p_action,
1506: 'A',g_cc_state||'AP'||decode(g_bc_reqired,'N',g_cc_enc_status,decode(g_cc_state,'PR','P','C')),
1507: 'R',g_cc_state||'RJ'||g_cc_enc_status,

Line 1512: FROM dual;

1508: 'E',g_cc_state||'RJ'||g_cc_enc_status,
1509: 'F',g_cc_state||'RJ'||'N'
1510: )
1511: INTO l_new_state
1512: FROM dual;
1513:
1514: ELSE
1515: --Generate error message, unhandled situation
1516:

Line 1545: FROM dual;

1541: 'E',substr(g_error_text,1,240),
1542: 'A',substr(g_reject_note,1,240),
1543: 'R',substr(g_reject_note,1,240))
1544: INTO g_action_notes
1545: FROM dual;
1546:
1547: --Getting the new statuses and states
1548: g_cc_new_state :=substr(l_new_state,1,2);
1549: g_cc_new_appr_status:=substr(l_new_state,3,2);