DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on WF_NOTIFICATION

Line 1520: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');

1516:
1517:
1518: --get notification id from wf_engine context
1519: l_nid := WF_ENGINE.CONTEXT_NID;
1520: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1521:
1522: IF l_ntf_result = 'NO' THEN
1523: l_sts_code := 'REJECTED';
1524: l_rjn_code := 'CUST';

Line 1525: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');

1521:
1522: IF l_ntf_result = 'NO' THEN
1523: l_sts_code := 'REJECTED';
1524: l_rjn_code := 'CUST';
1525: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1526: ELSIF l_ntf_result = 'YES' THEN
1527: l_sts_code := 'CUSTAPPR';
1528: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1529: END IF;

Line 1528: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');

1524: l_rjn_code := 'CUST';
1525: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1526: ELSIF l_ntf_result = 'YES' THEN
1527: l_sts_code := 'CUSTAPPR';
1528: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1529: END IF;
1530:
1531:
1532: l_tcnv_rec.id := l_trx_id;

Line 1656: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');

1652:
1653:
1654: --get notification id from wf_engine context
1655: l_nid := WF_ENGINE.CONTEXT_NID;
1656: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1657:
1658: --rkuttiya changed for bug#5149488
1659: IF l_ntf_result = 'VND_REJECTED' THEN
1660: l_sts_code := 'REJECTED';

Line 1662: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');

1658: --rkuttiya changed for bug#5149488
1659: IF l_ntf_result = 'VND_REJECTED' THEN
1660: l_sts_code := 'REJECTED';
1661: l_rjn_code := 'VND';
1662: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1663: ELSIF l_ntf_result = 'VND_APPROVED' THEN
1664: l_sts_code := 'VENDAPPR';
1665: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1666: END IF;

Line 1665: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');

1661: l_rjn_code := 'VND';
1662: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1663: ELSIF l_ntf_result = 'VND_APPROVED' THEN
1664: l_sts_code := 'VENDAPPR';
1665: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1666: END IF;
1667:
1668:
1669: l_tcnv_rec.id := l_trx_id;

Line 2128: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');

2124:
2125:
2126: --get notification id from wf_engine context
2127: l_nid := WF_ENGINE.CONTEXT_NID;
2128: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2129:
2130: IF l_ntf_result = 'CREDIT_REJECTED' THEN
2131: l_sts_code := 'REJECTED';
2132: l_rjn_code := 'CRDPT';

Line 2133: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');

2129:
2130: IF l_ntf_result = 'CREDIT_REJECTED' THEN
2131: l_sts_code := 'REJECTED';
2132: l_rjn_code := 'CRDPT';
2133: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2134:
2135: ELSIF l_ntf_result = 'CREDIT_APPROVED' THEN
2136: l_sts_code := 'CREDAPPR';
2137: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');

Line 2137: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');

2133: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2134:
2135: ELSIF l_ntf_result = 'CREDIT_APPROVED' THEN
2136: l_sts_code := 'CREDAPPR';
2137: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2138: END IF;
2139:
2140:
2141: l_tcnv_rec.id := l_trx_id;

Line 2302: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');

2298:
2299:
2300: --get notification id from wf_engine context
2301: l_nid := WF_ENGINE.CONTEXT_NID;
2302: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2303:
2304: IF l_ntf_result = 'COLLECTIONS_REJECTED' THEN
2305: l_sts_code := 'REJECTED';
2306: l_rjn_code := 'CODPT';

Line 2307: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');

2303:
2304: IF l_ntf_result = 'COLLECTIONS_REJECTED' THEN
2305: l_sts_code := 'REJECTED';
2306: l_rjn_code := 'CODPT';
2307: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2308: ELSE
2309: l_sts_code := 'COLLAPPR';
2310: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2311: END IF;

Line 2310: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');

2306: l_rjn_code := 'CODPT';
2307: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2308: ELSE
2309: l_sts_code := 'COLLAPPR';
2310: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2311: END IF;
2312:
2313:
2314: l_tcnv_rec.id := l_trx_id;

Line 3235: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');

3231:
3232: IF (funcmode = 'RESPOND') THEN
3233: --get notification id from wf_engine context
3234: l_nid := WF_ENGINE.CONTEXT_NID;
3235: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3236:
3237: resultout := 'COMPLETE:'|| l_ntf_result;
3238:
3239: --Run Mode

Line 3284: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');

3280:
3281: IF (funcmode = 'RESPOND') THEN
3282: --get notification id from wf_engine context
3283: l_nid := WF_ENGINE.CONTEXT_NID;
3284: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3285:
3286: resultout := 'COMPLETE:'|| l_ntf_result;
3287:
3288: --Run Mode

Line 3536: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');

3532:
3533: IF (funcmode = 'RESPOND') THEN
3534: --get notification id from wf_engine context
3535: l_nid := WF_ENGINE.CONTEXT_NID;
3536: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3537:
3538: resultout := 'COMPLETE:'|| l_ntf_result;
3539:
3540: --Run Mode