6322:
6323: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
6324: FROM dual;
6325:
6326: IF (JTF_USR_HKS.ok_to_execute
6327: (
6328: 'JTF_ASSIGN_PUB',
6329: 'GET_ASSIGN_DR_RESOURCES',
6330: 'W',
6354: END IF;
6355: END IF;
6356:
6357:
6358: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
6359:
6360: JTF_USR_HKS.WrkFlowLaunch
6361: (
6362: 'JTF_ASSIGN_WF',
6356:
6357:
6358: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
6359:
6360: JTF_USR_HKS.WrkFlowLaunch
6361: (
6362: 'JTF_ASSIGN_WF',
6363: l_workflow_profile,
6364: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
6365: l_bind_data_id,
6366: l_return_code
6367: );
6368:
6369: JTF_USR_HKS.purge_bind_data
6370: (
6371: l_bind_data_id,
6372: 'W'
6373: );
6386: END IF;
6387:
6388: END IF; -- End of JTF_ASSIGN_CUHK
6389:
6390: END IF; -- End of JTF_USR_HKS
6391:
6392:
6393: /* Standard call to get message count and
6394: the message information */
7016:
7017: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7018: FROM dual;
7019:
7020: IF (JTF_USR_HKS.ok_to_execute
7021: (
7022: 'JTF_ASSIGN_PUB',
7023: 'GET_ASSIGN_OPPR_RESOURCES',
7024: 'W',
7046: RAISE fnd_api.g_exc_unexpected_error;
7047: END IF;
7048: END IF;
7049:
7050: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
7051:
7052: JTF_USR_HKS.WrkFlowLaunch
7053: (
7054: 'JTF_ASSIGN_WF',
7048: END IF;
7049:
7050: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
7051:
7052: JTF_USR_HKS.WrkFlowLaunch
7053: (
7054: 'JTF_ASSIGN_WF',
7055: l_workflow_profile,
7056: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
7057: l_bind_data_id,
7058: l_return_code
7059: );
7060:
7061: JTF_USR_HKS.purge_bind_data
7062: (
7063: l_bind_data_id,
7064: 'W'
7065: );
7077: END IF;
7078:
7079: END IF; -- End of JTF_ASSIGN_CUHK
7080:
7081: END IF; -- End of JTF_USR_HKS
7082:
7083:
7084:
7085:
7604:
7605: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7606: FROM dual;
7607:
7608: IF (JTF_USR_HKS.ok_to_execute
7609: (
7610: 'JTF_ASSIGN_PUB',
7611: 'GET_ASSIGN_LEAD_RESOURCES',
7612: 'W',
7634: RAISE fnd_api.g_exc_unexpected_error;
7635: END IF;
7636: END IF;
7637:
7638: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
7639:
7640: JTF_USR_HKS.WrkFlowLaunch
7641: (
7642: 'JTF_ASSIGN_WF',
7636: END IF;
7637:
7638: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
7639:
7640: JTF_USR_HKS.WrkFlowLaunch
7641: (
7642: 'JTF_ASSIGN_WF',
7643: l_workflow_profile,
7644: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
7645: l_bind_data_id,
7646: l_return_code
7647: );
7648:
7649: JTF_USR_HKS.purge_bind_data
7650: (
7651: l_bind_data_id,
7652: 'W'
7653: );
7665: END IF;
7666:
7667: END IF; -- End of JTF_ASSIGN_CUHK
7668:
7669: END IF; -- End of JTF_USR_HKS
7670:
7671:
7672:
7673:
8216:
8217: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8218: FROM dual;
8219:
8220: IF (JTF_USR_HKS.ok_to_execute
8221: (
8222: 'JTF_ASSIGN_PUB',
8223: 'GET_ASSIGN_LEAD_RESOURCES',
8224: 'W',
8246: RAISE fnd_api.g_exc_unexpected_error;
8247: END IF;
8248: END IF;
8249:
8250: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
8251:
8252: JTF_USR_HKS.WrkFlowLaunch
8253: (
8254: 'JTF_ASSIGN_WF',
8248: END IF;
8249:
8250: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
8251:
8252: JTF_USR_HKS.WrkFlowLaunch
8253: (
8254: 'JTF_ASSIGN_WF',
8255: l_workflow_profile,
8256: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
8257: l_bind_data_id,
8258: l_return_code
8259: );
8260:
8261: JTF_USR_HKS.purge_bind_data
8262: (
8263: l_bind_data_id,
8264: 'W'
8265: );
8278: END IF;
8279:
8280: END IF; -- End of JTF_ASSIGN_CUHK
8281:
8282: END IF; -- End of JTF_USR_HKS
8283:
8284:
8285:
8286: /* Standard call to get message count and
8864:
8865: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8866: FROM dual;
8867:
8868: IF (JTF_USR_HKS.ok_to_execute
8869: (
8870: 'JTF_ASSIGN_PUB',
8871: 'GET_ASSIGN_ACCOUNT_RESOURCES',
8872: 'W',
8894: RAISE fnd_api.g_exc_unexpected_error;
8895: END IF;
8896: END IF;
8897:
8898: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
8899:
8900: JTF_USR_HKS.WrkFlowLaunch
8901: (
8902: 'JTF_ASSIGN_WF',
8896: END IF;
8897:
8898: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
8899:
8900: JTF_USR_HKS.WrkFlowLaunch
8901: (
8902: 'JTF_ASSIGN_WF',
8903: l_workflow_profile,
8904: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
8905: l_bind_data_id,
8906: l_return_code
8907: );
8908:
8909: JTF_USR_HKS.purge_bind_data
8910: (
8911: l_bind_data_id,
8912: 'W'
8913: );
8925: END IF;
8926:
8927: END IF; -- End of JTF_ASSIGN_CUHK
8928:
8929: END IF; -- End of JTF_USR_HKS
8930:
8931:
8932:
8933:
10386:
10387: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
10388: FROM dual;
10389:
10390: IF (JTF_USR_HKS.ok_to_execute
10391: (
10392: 'JTF_ASSIGN_PUB',
10393: 'GET_ASSIGN_ESC_RESOURCES',
10394: 'W',
10417: END IF;
10418: END IF;
10419:
10420:
10421: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
10422:
10423: JTF_USR_HKS.WrkFlowLaunch
10424: (
10425: 'JTF_ASSIGN_WF',
10419:
10420:
10421: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
10422:
10423: JTF_USR_HKS.WrkFlowLaunch
10424: (
10425: 'JTF_ASSIGN_WF',
10426: l_workflow_profile,
10427: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
10428: l_bind_data_id,
10429: l_return_code
10430: );
10431:
10432: JTF_USR_HKS.purge_bind_data
10433: (
10434: l_bind_data_id,
10435: 'W'
10436: );
10449: END IF;
10450:
10451: END IF; -- End of JTF_ASSIGN_CUHK
10452:
10453: END IF; -- End of JTF_USR_HKS
10454:
10455:
10456:
10457: /* Standard call to get message count and
11891:
11892: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
11893: FROM dual;
11894:
11895: IF (JTF_USR_HKS.ok_to_execute
11896: (
11897: 'JTF_ASSIGN_PUB',
11898: 'GET_ASSIGN_RESOURCES',
11899: 'W',
11923: END IF;
11924: END IF;
11925:
11926:
11927: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
11928:
11929: JTF_USR_HKS.WrkFlowLaunch
11930: (
11931: 'JTF_ASSIGN_WF',
11925:
11926:
11927: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
11928:
11929: JTF_USR_HKS.WrkFlowLaunch
11930: (
11931: 'JTF_ASSIGN_WF',
11932: l_workflow_profile,
11933: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
11934: l_bind_data_id,
11935: l_return_code
11936: );
11937:
11938: JTF_USR_HKS.purge_bind_data
11939: (
11940: l_bind_data_id,
11941: 'W'
11942: );
11955: END IF;
11956:
11957: END IF; -- End of JTF_ASSIGN_CUHK
11958:
11959: END IF; -- End of JTF_USR_HKS
11960:
11961:
11962: /* Standard call to get message count and
11963: the message information */