1682: CURSOR Get_IdAndDate_csr IS
1683: select
1684: AMV_C_CHL_ITEM_MATCH_S.nextval,
1685: sysdate
1686: from dual;
1687: --
1688: CURSOR Get_Resourceid_csr IS
1689: select owner_id
1690: from jtf_amv_items_b
2027: CURSOR Get_IdAndDate_csr IS
2028: select
2029: AMV_C_CHL_ITEM_MATCH_S.nextval,
2030: sysdate
2031: from dual;
2032: --
2033: BEGIN
2034: SAVEPOINT Do_ItemChannelMatch_Pvt;
2035: IF NOT FND_API.Compatible_API_Call (
2402: CURSOR Get_IdAndDate_csr IS
2403: select
2404: AMV_C_CHL_ITEM_MATCH_S.nextval,
2405: sysdate
2406: from dual;
2407: --
2408: BEGIN
2409: SAVEPOINT Remove_ItemChannelMatch_PVT;
2410: IF NOT FND_API.Compatible_API_Call (