378: FND_MSG_PUB.initialize;
379: END IF;
380:
381: -- Api body starts
382: l_user_id := NVL(fnd_global.USER_ID, -1);
383: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
384:
385:
386: g_updated_ids := JTF_NUMBER_TABLE();
379: END IF;
380:
381: -- Api body starts
382: l_user_id := NVL(fnd_global.USER_ID, -1);
383: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
384:
385:
386: g_updated_ids := JTF_NUMBER_TABLE();
387:
678: FND_MSG_PUB.initialize;
679: END IF;
680:
681: -- Api body starts
682: l_user_id := NVL(fnd_global.USER_ID, -1);
683: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
684:
685: g_updated_ids := JTF_NUMBER_TABLE();
686:
679: END IF;
680:
681: -- Api body starts
682: l_user_id := NVL(fnd_global.USER_ID, -1);
683: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
684:
685: g_updated_ids := JTF_NUMBER_TABLE();
686:
687: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
972: FND_MSG_PUB.initialize;
973: END IF;
974:
975: -- Api body starts
976: l_user_id := NVL(fnd_global.USER_ID, -1);
977: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
978:
979: g_updated_ids := JTF_NUMBER_TABLE();
980:
973: END IF;
974:
975: -- Api body starts
976: l_user_id := NVL(fnd_global.USER_ID, -1);
977: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
978:
979: g_updated_ids := JTF_NUMBER_TABLE();
980:
981: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
1277: FND_MSG_PUB.initialize;
1278: END IF;
1279:
1280: -- Api body starts
1281: l_user_id := NVL(fnd_global.USER_ID, -1);
1282: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1283:
1284: g_updated_ids := JTF_NUMBER_TABLE();
1285:
1278: END IF;
1279:
1280: -- Api body starts
1281: l_user_id := NVL(fnd_global.USER_ID, -1);
1282: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1283:
1284: g_updated_ids := JTF_NUMBER_TABLE();
1285:
1286: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
1599: FND_MSG_PUB.initialize;
1600: END IF;
1601:
1602: -- Api body starts
1603: l_user_id := NVL(fnd_global.USER_ID, -1);
1604: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1605:
1606: g_updated_ids := JTF_NUMBER_TABLE();
1607:
1600: END IF;
1601:
1602: -- Api body starts
1603: l_user_id := NVL(fnd_global.USER_ID, -1);
1604: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1605:
1606: g_updated_ids := JTF_NUMBER_TABLE();
1607:
1608: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
1910: FND_MSG_PUB.initialize;
1911: END IF;
1912:
1913: -- Api body starts
1914: l_user_id := NVL(fnd_global.USER_ID, -1);
1915: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1916:
1917: g_updated_ids := JTF_NUMBER_TABLE();
1918:
1911: END IF;
1912:
1913: -- Api body starts
1914: l_user_id := NVL(fnd_global.USER_ID, -1);
1915: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1916:
1917: g_updated_ids := JTF_NUMBER_TABLE();
1918:
1919: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
2213: FND_MSG_PUB.initialize;
2214: END IF;
2215:
2216: -- Api body starts
2217: l_user_id := NVL(fnd_global.USER_ID, -1);
2218: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
2219:
2220: g_updated_ids := JTF_NUMBER_TABLE();
2221:
2214: END IF;
2215:
2216: -- Api body starts
2217: l_user_id := NVL(fnd_global.USER_ID, -1);
2218: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
2219:
2220: g_updated_ids := JTF_NUMBER_TABLE();
2221:
2222: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
2515: FND_MSG_PUB.initialize;
2516: END IF;
2517:
2518: -- Api body starts
2519: l_user_id := NVL(fnd_global.USER_ID, -1);
2520: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
2521:
2522: g_updated_ids := JTF_NUMBER_TABLE();
2523:
2516: END IF;
2517:
2518: -- Api body starts
2519: l_user_id := NVL(fnd_global.USER_ID, -1);
2520: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
2521:
2522: g_updated_ids := JTF_NUMBER_TABLE();
2523:
2524: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
2819: FND_MSG_PUB.initialize;
2820: END IF;
2821:
2822: -- Api body starts
2823: l_user_id := NVL(fnd_global.USER_ID, -1);
2824: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
2825:
2826: g_updated_ids := JTF_NUMBER_TABLE();
2827:
2820: END IF;
2821:
2822: -- Api body starts
2823: l_user_id := NVL(fnd_global.USER_ID, -1);
2824: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
2825:
2826: g_updated_ids := JTF_NUMBER_TABLE();
2827:
2828: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
3123: FND_MSG_PUB.initialize;
3124: END IF;
3125:
3126: -- Api body starts
3127: l_user_id := NVL(fnd_global.USER_ID, -1);
3128: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
3129:
3130: g_updated_ids := JTF_NUMBER_TABLE();
3131:
3124: END IF;
3125:
3126: -- Api body starts
3127: l_user_id := NVL(fnd_global.USER_ID, -1);
3128: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
3129:
3130: g_updated_ids := JTF_NUMBER_TABLE();
3131:
3132: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
3427: FND_MSG_PUB.initialize;
3428: END IF;
3429:
3430: -- Api body starts
3431: l_user_id := NVL(fnd_global.USER_ID, -1);
3432: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
3433:
3434: g_updated_ids := JTF_NUMBER_TABLE();
3435:
3428: END IF;
3429:
3430: -- Api body starts
3431: l_user_id := NVL(fnd_global.USER_ID, -1);
3432: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
3433:
3434: g_updated_ids := JTF_NUMBER_TABLE();
3435:
3436: MERGE INTO CSD_SO_ORCHESTRATION soo USING (