DBA Data[Home] [Help]

APPS.AMV_MATCH_PVT dependencies on AMV_C_CHL_ITEM_MATCH_S

Line 1677: AMV_C_CHL_ITEM_MATCH_S.nextval,

1673: CURSOR Get_ChannelInfo_csr IS
1674: select
1675: pub_need_approval_flag,
1676: channel_category_id,
1677: AMV_C_CHL_ITEM_MATCH_S.nextval,
1678: sysdate
1679: from amv_c_channels_b
1680: Where channel_id = p_channel_id;
1681: --

Line 1684: AMV_C_CHL_ITEM_MATCH_S.nextval,

1680: Where channel_id = p_channel_id;
1681: --
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

Line 2022: AMV_C_CHL_ITEM_MATCH_S.nextval,

2018: CURSOR Get_ChannelInfo_csr IS
2019: select
2020: pub_need_approval_flag,
2021: channel_category_id,
2022: AMV_C_CHL_ITEM_MATCH_S.nextval,
2023: sysdate
2024: from amv_c_channels_b
2025: Where channel_id = p_channel_id;
2026: --

Line 2029: AMV_C_CHL_ITEM_MATCH_S.nextval,

2025: Where channel_id = p_channel_id;
2026: --
2027: CURSOR Get_IdAndDate_csr IS
2028: select
2029: AMV_C_CHL_ITEM_MATCH_S.nextval,
2030: sysdate
2031: from dual;
2032: --
2033: BEGIN

Line 2397: AMV_C_CHL_ITEM_MATCH_S.nextval,

2393: CURSOR Get_ChannelInfo_csr IS
2394: select
2395: pub_need_approval_flag,
2396: channel_category_id,
2397: AMV_C_CHL_ITEM_MATCH_S.nextval,
2398: sysdate
2399: from amv_c_channels_b
2400: Where channel_id = p_channel_id;
2401: --

Line 2404: AMV_C_CHL_ITEM_MATCH_S.nextval,

2400: Where channel_id = p_channel_id;
2401: --
2402: CURSOR Get_IdAndDate_csr IS
2403: select
2404: AMV_C_CHL_ITEM_MATCH_S.nextval,
2405: sysdate
2406: from dual;
2407: --
2408: BEGIN