DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on WF_NOTIFICATION

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

1525:
1526:
1527: --get notification id from wf_engine context
1528: l_nid := WF_ENGINE.CONTEXT_NID;
1529: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1530:
1531: IF l_ntf_result = 'NO' THEN
1532: l_sts_code := 'REJECTED';
1533: l_rjn_code := 'CUST';

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

1530:
1531: IF l_ntf_result = 'NO' THEN
1532: l_sts_code := 'REJECTED';
1533: l_rjn_code := 'CUST';
1534: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1535: ELSIF l_ntf_result = 'YES' THEN
1536: l_sts_code := 'CUSTAPPR';
1537: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1538: END IF;

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

1533: l_rjn_code := 'CUST';
1534: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1535: ELSIF l_ntf_result = 'YES' THEN
1536: l_sts_code := 'CUSTAPPR';
1537: -- l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1538: END IF;
1539:
1540:
1541: l_tcnv_rec.id := l_trx_id;

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

1661:
1662:
1663: --get notification id from wf_engine context
1664: l_nid := WF_ENGINE.CONTEXT_NID;
1665: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1666:
1667: --rkuttiya changed for bug#5149488
1668: IF l_ntf_result = 'VND_REJECTED' THEN
1669: l_sts_code := 'REJECTED';

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

1667: --rkuttiya changed for bug#5149488
1668: IF l_ntf_result = 'VND_REJECTED' THEN
1669: l_sts_code := 'REJECTED';
1670: l_rjn_code := 'VND';
1671: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1672: ELSIF l_ntf_result = 'VND_APPROVED' THEN
1673: l_sts_code := 'VENDAPPR';
1674: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1675: END IF;

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

1670: l_rjn_code := 'VND';
1671: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1672: ELSIF l_ntf_result = 'VND_APPROVED' THEN
1673: l_sts_code := 'VENDAPPR';
1674: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
1675: END IF;
1676:
1677:
1678: l_tcnv_rec.id := l_trx_id;

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

2133:
2134:
2135: --get notification id from wf_engine context
2136: l_nid := WF_ENGINE.CONTEXT_NID;
2137: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2138:
2139: IF l_ntf_result = 'CREDIT_REJECTED' THEN
2140: l_sts_code := 'REJECTED';
2141: l_rjn_code := 'CRDPT';

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

2138:
2139: IF l_ntf_result = 'CREDIT_REJECTED' THEN
2140: l_sts_code := 'REJECTED';
2141: l_rjn_code := 'CRDPT';
2142: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2143:
2144: ELSIF l_ntf_result = 'CREDIT_APPROVED' THEN
2145: l_sts_code := 'CREDAPPR';
2146: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');

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

2142: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2143:
2144: ELSIF l_ntf_result = 'CREDIT_APPROVED' THEN
2145: l_sts_code := 'CREDAPPR';
2146: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2147: END IF;
2148:
2149:
2150: l_tcnv_rec.id := l_trx_id;

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

2307:
2308:
2309: --get notification id from wf_engine context
2310: l_nid := WF_ENGINE.CONTEXT_NID;
2311: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2312:
2313: IF l_ntf_result = 'COLLECTIONS_REJECTED' THEN
2314: l_sts_code := 'REJECTED';
2315: l_rjn_code := 'CODPT';

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

2312:
2313: IF l_ntf_result = 'COLLECTIONS_REJECTED' THEN
2314: l_sts_code := 'REJECTED';
2315: l_rjn_code := 'CODPT';
2316: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2317: ELSE
2318: l_sts_code := 'COLLAPPR';
2319: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2320: END IF;

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

2315: l_rjn_code := 'CODPT';
2316: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2317: ELSE
2318: l_sts_code := 'COLLAPPR';
2319: l_ntf_comments := wf_notification.GetAttrText(l_nid,'COMMENTS');
2320: END IF;
2321:
2322:
2323: l_tcnv_rec.id := l_trx_id;

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

3240:
3241: IF (funcmode = 'RESPOND') THEN
3242: --get notification id from wf_engine context
3243: l_nid := WF_ENGINE.CONTEXT_NID;
3244: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3245:
3246: resultout := 'COMPLETE:'|| l_ntf_result;
3247:
3248: --Run Mode

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

3289:
3290: IF (funcmode = 'RESPOND') THEN
3291: --get notification id from wf_engine context
3292: l_nid := WF_ENGINE.CONTEXT_NID;
3293: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3294:
3295: resultout := 'COMPLETE:'|| l_ntf_result;
3296:
3297: --Run Mode

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

3541:
3542: IF (funcmode = 'RESPOND') THEN
3543: --get notification id from wf_engine context
3544: l_nid := WF_ENGINE.CONTEXT_NID;
3545: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3546:
3547: resultout := 'COMPLETE:'|| l_ntf_result;
3548:
3549: --Run Mode