eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_CHANNEL_PVT dependencies on AMV_UTILITY_PVT

Line 117: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN

113: -- Must pass category id to identify by channel name
114: x_error_msg := 'AMV_CHN_CAT_ID_MISS';
115: RAISE FND_API.G_EXC_ERROR;
116: ELSE
117: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119: OPEN Get_ChannelStatusByName;
120: FETCH Get_ChannelStatusByName INTO x_channel_id;
121: IF Get_ChannelStatusByName%FOUND THEN

Line 142: IF AMV_UTILITY_PVT.Is_ChannelIdValid(p_channel_id) THEN

138: END IF;
139: END IF;
140: ELSE
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142: IF AMV_UTILITY_PVT.Is_ChannelIdValid(p_channel_id) THEN
143: x_exist_flag := FND_API.G_TRUE;
144: x_channel_id := p_channel_id;
145: x_error_msg := 'AMV_CHN_ID_EXISTS';
146: x_error_token := p_channel_id;

Line 532: AMV_UTILITY_PVT.Get_UserInfo(

528: IF FND_API.To_Boolean (p_init_msg_list) THEN
529: FND_MSG_PUB.initialize;
530: END IF;
531: -- Get the current (login) user id.
532: AMV_UTILITY_PVT.Get_UserInfo(
533: x_resource_id => l_resource_id,
534: x_user_id => l_user_id,
535: x_login_id => l_login_user_id,
536: x_user_status => l_login_user_status

Line 590: l_channel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;

586: -- default values settings for inconsistant types
587: l_channel_obj := p_channel_record;
588:
589: IF (p_channel_record.status = FND_API.G_MISS_CHAR) THEN
590: l_channel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;
591: END IF;
592:
593: IF (p_channel_record.effective_start_date = FND_API.G_MISS_DATE) THEN
594: l_channel_obj.effective_start_date := sysdate;

Line 909: AMV_UTILITY_PVT.Get_UserInfo(

905: IF FND_API.To_Boolean (p_init_msg_list) THEN
906: FND_MSG_PUB.initialize;
907: END IF;
908: -- Get the current (login) user id.
909: AMV_UTILITY_PVT.Get_UserInfo(
910: x_resource_id => l_resource_id,
911: x_user_id => l_user_id,
912: x_login_id => l_login_user_id,
913: x_user_status => l_login_user_status

Line 952: IF p_channel_record.channel_type = AMV_UTILITY_PVT.G_CONTENT THEN

948: );
949:
950: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
951: IF (l_setup_result = FND_API.G_TRUE) THEN
952: IF p_channel_record.channel_type = AMV_UTILITY_PVT.G_CONTENT THEN
953: IF p_channel_record.access_level_type =
954: AMV_UTILITY_PVT.G_PUBLIC THEN
955: -- create the channel
956: AMV_CHANNEL_PVT.Add_Channel (

Line 954: AMV_UTILITY_PVT.G_PUBLIC THEN

950: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
951: IF (l_setup_result = FND_API.G_TRUE) THEN
952: IF p_channel_record.channel_type = AMV_UTILITY_PVT.G_CONTENT THEN
953: IF p_channel_record.access_level_type =
954: AMV_UTILITY_PVT.G_PUBLIC THEN
955: -- create the channel
956: AMV_CHANNEL_PVT.Add_Channel (
957: p_api_version => l_api_version,
958: p_init_msg_list => FND_API.G_FALSE,

Line 1164: AMV_UTILITY_PVT.Get_UserInfo(

1160: IF FND_API.To_Boolean (p_init_msg_list) THEN
1161: FND_MSG_PUB.initialize;
1162: END IF;
1163: -- Get the current (login) user id.
1164: AMV_UTILITY_PVT.Get_UserInfo(
1165: x_resource_id => l_resource_id,
1166: x_user_id => l_user_id,
1167: x_login_id => l_login_user_id,
1168: x_user_status => l_login_user_status

Line 1207: IF p_channel_record.channel_type = AMV_UTILITY_PVT.G_CONTENT THEN

1203: );
1204:
1205: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1206: IF (l_setup_result = FND_API.G_TRUE) THEN
1207: IF p_channel_record.channel_type = AMV_UTILITY_PVT.G_CONTENT THEN
1208: IF p_channel_record.access_level_type =
1209: AMV_UTILITY_PVT.G_PROTECTED THEN
1210: -- create the channel
1211: AMV_CHANNEL_PVT.Add_Channel (

Line 1209: AMV_UTILITY_PVT.G_PROTECTED THEN

1205: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1206: IF (l_setup_result = FND_API.G_TRUE) THEN
1207: IF p_channel_record.channel_type = AMV_UTILITY_PVT.G_CONTENT THEN
1208: IF p_channel_record.access_level_type =
1209: AMV_UTILITY_PVT.G_PROTECTED THEN
1210: -- create the channel
1211: AMV_CHANNEL_PVT.Add_Channel (
1212: p_api_version => l_api_version,
1213: p_init_msg_list => FND_API.G_FALSE,

Line 1418: AMV_UTILITY_PVT.Get_UserInfo(

1414: IF FND_API.To_Boolean (p_init_msg_list) THEN
1415: FND_MSG_PUB.initialize;
1416: END IF;
1417: -- Get the current (login) user id.
1418: AMV_UTILITY_PVT.Get_UserInfo(
1419: x_resource_id => l_resource_id,
1420: x_user_id => l_user_id,
1421: x_login_id => l_login_user_id,
1422: x_user_status => l_login_user_status

Line 1446: IF p_channel_record.channel_type = AMV_UTILITY_PVT.G_CONTENT THEN

1442: -- Initialize API return status to sucess
1443: x_return_status := FND_API.G_RET_STS_SUCCESS;
1444:
1445: --
1446: IF p_channel_record.channel_type = AMV_UTILITY_PVT.G_CONTENT THEN
1447: IF p_channel_record.access_level_type =
1448: AMV_UTILITY_PVT.G_PRIVATE THEN
1449: -- create the channel
1450: AMV_CHANNEL_PVT.Add_Channel (

Line 1448: AMV_UTILITY_PVT.G_PRIVATE THEN

1444:
1445: --
1446: IF p_channel_record.channel_type = AMV_UTILITY_PVT.G_CONTENT THEN
1447: IF p_channel_record.access_level_type =
1448: AMV_UTILITY_PVT.G_PRIVATE THEN
1449: -- create the channel
1450: AMV_CHANNEL_PVT.Add_Channel (
1451: p_api_version => l_api_version,
1452: p_init_msg_list => FND_API.G_FALSE,

Line 1470: l_mychannel_obj.user_or_group_type :=AMV_UTILITY_PVT.G_USER;

1466: l_mychannel_obj.channel_type := FND_API.G_MISS_CHAR;
1467: l_mychannel_obj.access_level_type := FND_API.G_MISS_CHAR;
1468: l_mychannel_obj.user_or_group_id :=
1469: p_channel_record.default_approver_user_id;
1470: l_mychannel_obj.user_or_group_type :=AMV_UTILITY_PVT.G_USER;
1471: l_mychannel_obj.subscribing_to_id := x_channel_id;
1472: l_mychannel_obj.subscribing_to_type :=AMV_UTILITY_PVT.G_CHANNEL;
1473: l_mychannel_obj.subscription_reason_type:=
1474: AMV_UTILITY_PVT.G_ENFORCED;

Line 1472: l_mychannel_obj.subscribing_to_type :=AMV_UTILITY_PVT.G_CHANNEL;

1468: l_mychannel_obj.user_or_group_id :=
1469: p_channel_record.default_approver_user_id;
1470: l_mychannel_obj.user_or_group_type :=AMV_UTILITY_PVT.G_USER;
1471: l_mychannel_obj.subscribing_to_id := x_channel_id;
1472: l_mychannel_obj.subscribing_to_type :=AMV_UTILITY_PVT.G_CHANNEL;
1473: l_mychannel_obj.subscription_reason_type:=
1474: AMV_UTILITY_PVT.G_ENFORCED;
1475: l_mychannel_obj.order_number := FND_API.G_MISS_NUM;
1476: l_mychannel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;

Line 1474: AMV_UTILITY_PVT.G_ENFORCED;

1470: l_mychannel_obj.user_or_group_type :=AMV_UTILITY_PVT.G_USER;
1471: l_mychannel_obj.subscribing_to_id := x_channel_id;
1472: l_mychannel_obj.subscribing_to_type :=AMV_UTILITY_PVT.G_CHANNEL;
1473: l_mychannel_obj.subscription_reason_type:=
1474: AMV_UTILITY_PVT.G_ENFORCED;
1475: l_mychannel_obj.order_number := FND_API.G_MISS_NUM;
1476: l_mychannel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;
1477: l_mychannel_obj.notify_flag := FND_API.G_FALSE;
1478: l_mychannel_obj.notification_interval_type:= FND_API.G_MISS_CHAR;

Line 1476: l_mychannel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;

1472: l_mychannel_obj.subscribing_to_type :=AMV_UTILITY_PVT.G_CHANNEL;
1473: l_mychannel_obj.subscription_reason_type:=
1474: AMV_UTILITY_PVT.G_ENFORCED;
1475: l_mychannel_obj.order_number := FND_API.G_MISS_NUM;
1476: l_mychannel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;
1477: l_mychannel_obj.notify_flag := FND_API.G_FALSE;
1478: l_mychannel_obj.notification_interval_type:= FND_API.G_MISS_CHAR;
1479: /*
1480: l_mychannel_obj := amv_my_channel_obj_type(

Line 1485: AMV_UTILITY_PVT.G_USER,

1481: FND_API.G_MISS_NUM,
1482: FND_API.G_MISS_CHAR,
1483: FND_API.G_MISS_CHAR,
1484: p_channel_record.default_approver_user_id,
1485: AMV_UTILITY_PVT.G_USER,
1486: x_channel_id,
1487: AMV_UTILITY_PVT.G_CHANNEL,
1488: AMV_UTILITY_PVT.G_ENFORCED,
1489: FND_API.G_MISS_NUM,

Line 1487: AMV_UTILITY_PVT.G_CHANNEL,

1483: FND_API.G_MISS_CHAR,
1484: p_channel_record.default_approver_user_id,
1485: AMV_UTILITY_PVT.G_USER,
1486: x_channel_id,
1487: AMV_UTILITY_PVT.G_CHANNEL,
1488: AMV_UTILITY_PVT.G_ENFORCED,
1489: FND_API.G_MISS_NUM,
1490: AMV_UTILITY_PVT.G_ACTIVE,
1491: FND_API.G_FALSE,

Line 1488: AMV_UTILITY_PVT.G_ENFORCED,

1484: p_channel_record.default_approver_user_id,
1485: AMV_UTILITY_PVT.G_USER,
1486: x_channel_id,
1487: AMV_UTILITY_PVT.G_CHANNEL,
1488: AMV_UTILITY_PVT.G_ENFORCED,
1489: FND_API.G_MISS_NUM,
1490: AMV_UTILITY_PVT.G_ACTIVE,
1491: FND_API.G_FALSE,
1492: FND_API.G_MISS_CHAR);

Line 1490: AMV_UTILITY_PVT.G_ACTIVE,

1486: x_channel_id,
1487: AMV_UTILITY_PVT.G_CHANNEL,
1488: AMV_UTILITY_PVT.G_ENFORCED,
1489: FND_API.G_MISS_NUM,
1490: AMV_UTILITY_PVT.G_ACTIVE,
1491: FND_API.G_FALSE,
1492: FND_API.G_MISS_CHAR);
1493: */
1494: -- add subscription

Line 1683: AMV_UTILITY_PVT.Get_UserInfo(

1679: IF FND_API.To_Boolean (p_init_msg_list) THEN
1680: FND_MSG_PUB.initialize;
1681: END IF;
1682: -- Get the current (login) user id.
1683: AMV_UTILITY_PVT.Get_UserInfo(
1684: x_resource_id => l_resource_id,
1685: x_user_id => l_user_id,
1686: x_login_id => l_login_user_id,
1687: x_user_status => l_login_user_status

Line 1735: IF p_channel_record.channel_type = AMV_UTILITY_PVT.G_GROUP THEN

1731: l_channel_obj.channel_name := l_group_name;
1732: l_channel_obj.description := 'Group Channel for '||l_group_name;
1733:
1734: --
1735: IF p_channel_record.channel_type = AMV_UTILITY_PVT.G_GROUP THEN
1736: -- create the channel
1737: AMV_CHANNEL_PVT.Add_Channel (
1738: p_api_version => l_api_version,
1739: p_init_msg_list => FND_API.G_FALSE,

Line 1758: l_mychannel_obj.user_or_group_type :=AMV_UTILITY_PVT.G_GROUP;

1754: l_mychannel_obj.my_channel_id := FND_API.G_MISS_NUM;
1755: l_mychannel_obj.channel_type := FND_API.G_MISS_CHAR;
1756: l_mychannel_obj.access_level_type := FND_API.G_MISS_CHAR;
1757: l_mychannel_obj.user_or_group_id := p_group_id;
1758: l_mychannel_obj.user_or_group_type :=AMV_UTILITY_PVT.G_GROUP;
1759: l_mychannel_obj.subscribing_to_id := x_channel_id;
1760: l_mychannel_obj.subscribing_to_type :=AMV_UTILITY_PVT.G_CHANNEL;
1761: l_mychannel_obj.subscription_reason_type:=
1762: AMV_UTILITY_PVT.G_ENFORCED;

Line 1760: l_mychannel_obj.subscribing_to_type :=AMV_UTILITY_PVT.G_CHANNEL;

1756: l_mychannel_obj.access_level_type := FND_API.G_MISS_CHAR;
1757: l_mychannel_obj.user_or_group_id := p_group_id;
1758: l_mychannel_obj.user_or_group_type :=AMV_UTILITY_PVT.G_GROUP;
1759: l_mychannel_obj.subscribing_to_id := x_channel_id;
1760: l_mychannel_obj.subscribing_to_type :=AMV_UTILITY_PVT.G_CHANNEL;
1761: l_mychannel_obj.subscription_reason_type:=
1762: AMV_UTILITY_PVT.G_ENFORCED;
1763: l_mychannel_obj.order_number := FND_API.G_MISS_NUM;
1764: l_mychannel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;

Line 1762: AMV_UTILITY_PVT.G_ENFORCED;

1758: l_mychannel_obj.user_or_group_type :=AMV_UTILITY_PVT.G_GROUP;
1759: l_mychannel_obj.subscribing_to_id := x_channel_id;
1760: l_mychannel_obj.subscribing_to_type :=AMV_UTILITY_PVT.G_CHANNEL;
1761: l_mychannel_obj.subscription_reason_type:=
1762: AMV_UTILITY_PVT.G_ENFORCED;
1763: l_mychannel_obj.order_number := FND_API.G_MISS_NUM;
1764: l_mychannel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;
1765: l_mychannel_obj.notify_flag := FND_API.G_FALSE;
1766: l_mychannel_obj.notification_interval_type:= FND_API.G_MISS_CHAR;

Line 1764: l_mychannel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;

1760: l_mychannel_obj.subscribing_to_type :=AMV_UTILITY_PVT.G_CHANNEL;
1761: l_mychannel_obj.subscription_reason_type:=
1762: AMV_UTILITY_PVT.G_ENFORCED;
1763: l_mychannel_obj.order_number := FND_API.G_MISS_NUM;
1764: l_mychannel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;
1765: l_mychannel_obj.notify_flag := FND_API.G_FALSE;
1766: l_mychannel_obj.notification_interval_type:= FND_API.G_MISS_CHAR;
1767: /*
1768: l_mychannel_obj := amv_my_channel_obj_type(

Line 1773: AMV_UTILITY_PVT.G_GROUP,

1769: FND_API.G_MISS_NUM,
1770: FND_API.G_MISS_CHAR,
1771: FND_API.G_MISS_CHAR,
1772: p_group_id,
1773: AMV_UTILITY_PVT.G_GROUP,
1774: x_channel_id,
1775: AMV_UTILITY_PVT.G_CHANNEL,
1776: AMV_UTILITY_PVT.G_ENFORCED,
1777: FND_API.G_MISS_NUM,

Line 1775: AMV_UTILITY_PVT.G_CHANNEL,

1771: FND_API.G_MISS_CHAR,
1772: p_group_id,
1773: AMV_UTILITY_PVT.G_GROUP,
1774: x_channel_id,
1775: AMV_UTILITY_PVT.G_CHANNEL,
1776: AMV_UTILITY_PVT.G_ENFORCED,
1777: FND_API.G_MISS_NUM,
1778: AMV_UTILITY_PVT.G_ACTIVE,
1779: FND_API.G_FALSE,

Line 1776: AMV_UTILITY_PVT.G_ENFORCED,

1772: p_group_id,
1773: AMV_UTILITY_PVT.G_GROUP,
1774: x_channel_id,
1775: AMV_UTILITY_PVT.G_CHANNEL,
1776: AMV_UTILITY_PVT.G_ENFORCED,
1777: FND_API.G_MISS_NUM,
1778: AMV_UTILITY_PVT.G_ACTIVE,
1779: FND_API.G_FALSE,
1780: FND_API.G_MISS_CHAR);

Line 1778: AMV_UTILITY_PVT.G_ACTIVE,

1774: x_channel_id,
1775: AMV_UTILITY_PVT.G_CHANNEL,
1776: AMV_UTILITY_PVT.G_ENFORCED,
1777: FND_API.G_MISS_NUM,
1778: AMV_UTILITY_PVT.G_ACTIVE,
1779: FND_API.G_FALSE,
1780: FND_API.G_MISS_CHAR);
1781: */
1782: -- add subscription

Line 1951: AMV_UTILITY_PVT.Get_UserInfo(

1947: IF FND_API.To_Boolean (p_init_msg_list) THEN
1948: FND_MSG_PUB.initialize;
1949: END IF;
1950: -- Get the current (login) user id.
1951: AMV_UTILITY_PVT.Get_UserInfo(
1952: x_resource_id => l_resource_id,
1953: x_user_id => l_user_id,
1954: x_login_id => l_login_user_id,
1955: x_user_status => l_login_user_status

Line 2018: IF (AMV_UTILITY_PVT.Get_DeleteChannelStatus( l_channel_id,

2014: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2015: IF (l_setup_result = FND_API.G_TRUE) THEN
2016: l_delete_channel_flag := FND_API.G_TRUE;
2017: ELSE
2018: IF (AMV_UTILITY_PVT.Get_DeleteChannelStatus( l_channel_id,
2019: l_resource_id,
2020: AMV_UTILITY_PVT.G_USER) )
2021: THEN
2022: l_delete_channel_flag := FND_API.G_TRUE;

Line 2020: AMV_UTILITY_PVT.G_USER) )

2016: l_delete_channel_flag := FND_API.G_TRUE;
2017: ELSE
2018: IF (AMV_UTILITY_PVT.Get_DeleteChannelStatus( l_channel_id,
2019: l_resource_id,
2020: AMV_UTILITY_PVT.G_USER) )
2021: THEN
2022: l_delete_channel_flag := FND_API.G_TRUE;
2023: ELSE
2024: -- user does not have privilege to create public channel

Line 2052: AND subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL;

2048: IF l_delete_channel_flag = FND_API.G_TRUE THEN
2049: -- Remove channel from mychannels
2050: DELETE FROM amv_u_my_channels
2051: WHERE subscribing_to_id = l_channel_id
2052: AND subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL;
2053:
2054: -- Remove access given to this channel
2055: DELETE FROM amv_u_access
2056: WHERE access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL

Line 2056: WHERE access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL

2052: AND subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL;
2053:
2054: -- Remove access given to this channel
2055: DELETE FROM amv_u_access
2056: WHERE access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
2057: AND access_to_table_record_id = l_channel_id;
2058:
2059: -- Remove channel from authors
2060: DELETE FROM amv_c_authors

Line 2227: AMV_UTILITY_PVT.Get_UserInfo(

2223: IF FND_API.To_Boolean (p_init_msg_list) THEN
2224: FND_MSG_PUB.initialize;
2225: END IF;
2226: -- Get the current (login) user id.
2227: AMV_UTILITY_PVT.Get_UserInfo(
2228: x_resource_id => l_resource_id,
2229: x_user_id => l_user_id,
2230: x_login_id => l_login_user_id,
2231: x_user_status => l_login_user_status

Line 2295: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(

2291: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2292: IF (l_setup_result = FND_API.G_TRUE) THEN
2293: l_update_channel_flag := FND_API.G_TRUE;
2294: ELSE
2295: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
2296: l_channel_id,
2297: l_resource_id,
2298: AMV_UTILITY_PVT.G_USER) )
2299: THEN

Line 2298: AMV_UTILITY_PVT.G_USER) )

2294: ELSE
2295: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
2296: l_channel_id,
2297: l_resource_id,
2298: AMV_UTILITY_PVT.G_USER) )
2299: THEN
2300: l_update_channel_flag := FND_API.G_TRUE;
2301: ELSE
2302: -- user does not have privilege to create public channel

Line 2748: AMV_UTILITY_PVT.Get_UserInfo(

2744: IF FND_API.To_Boolean (p_init_msg_list) THEN
2745: FND_MSG_PUB.initialize;
2746: END IF;
2747: -- Get the current (login) user id.
2748: AMV_UTILITY_PVT.Get_UserInfo(
2749: x_resource_id => l_resource_id,
2750: x_user_id => l_user_id,
2751: x_login_id => l_login_user_id,
2752: x_user_status => l_login_user_status

Line 2938: AMV_UTILITY_PVT.Get_UserInfo(

2934: IF FND_API.To_Boolean (p_init_msg_list) THEN
2935: FND_MSG_PUB.initialize;
2936: END IF;
2937: -- Get the current (login) user id.
2938: AMV_UTILITY_PVT.Get_UserInfo(
2939: x_resource_id => l_resource_id,
2940: x_user_id => l_user_id,
2941: x_login_id => l_login_user_id,
2942: x_user_status => l_login_user_status

Line 3004: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(

3000: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3001: IF (l_setup_result = FND_API.G_TRUE) THEN
3002: l_update_channel_flag := FND_API.G_TRUE;
3003: ELSE
3004: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
3005: l_channel_id,
3006: l_resource_id,
3007: AMV_UTILITY_PVT.G_USER) )
3008: THEN

Line 3007: AMV_UTILITY_PVT.G_USER) )

3003: ELSE
3004: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
3005: l_channel_id,
3006: l_resource_id,
3007: AMV_UTILITY_PVT.G_USER) )
3008: THEN
3009: l_update_channel_flag := FND_API.G_TRUE;
3010: ELSE
3011: -- user does not have privilege to create public channel

Line 3243: AMV_UTILITY_PVT.Get_UserInfo(

3239: IF FND_API.To_Boolean (p_init_msg_list) THEN
3240: FND_MSG_PUB.initialize;
3241: END IF;
3242: -- Get the current (login) user id.
3243: AMV_UTILITY_PVT.Get_UserInfo(
3244: x_resource_id => l_resource_id,
3245: x_user_id => l_user_id,
3246: x_login_id => l_login_user_id,
3247: x_user_status => l_login_user_status

Line 3442: AMV_UTILITY_PVT.Get_UserInfo(

3438: IF FND_API.To_Boolean (p_init_msg_list) THEN
3439: FND_MSG_PUB.initialize;
3440: END IF;
3441: -- Get the current (login) user id.
3442: AMV_UTILITY_PVT.Get_UserInfo(
3443: x_resource_id => l_resource_id,
3444: x_user_id => l_user_id,
3445: x_login_id => l_login_user_id,
3446: x_user_status => l_login_user_status

Line 3508: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(

3504: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3505: IF (l_setup_result = FND_API.G_TRUE) THEN
3506: l_update_channel_flag := FND_API.G_TRUE;
3507: ELSE
3508: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
3509: l_channel_id,
3510: l_resource_id,
3511: AMV_UTILITY_PVT.G_USER) )
3512: THEN

Line 3511: AMV_UTILITY_PVT.G_USER) )

3507: ELSE
3508: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
3509: l_channel_id,
3510: l_resource_id,
3511: AMV_UTILITY_PVT.G_USER) )
3512: THEN
3513: l_update_channel_flag := FND_API.G_TRUE;
3514: ELSE
3515: -- user does not have privilege to create public channel

Line 3746: AMV_UTILITY_PVT.Get_UserInfo(

3742: IF FND_API.To_Boolean (p_init_msg_list) THEN
3743: FND_MSG_PUB.initialize;
3744: END IF;
3745: -- Get the current (login) user id.
3746: AMV_UTILITY_PVT.Get_UserInfo(
3747: x_resource_id => l_resource_id,
3748: x_user_id => l_user_id,
3749: x_login_id => l_login_user_id,
3750: x_user_status => l_login_user_status

Line 3945: AMV_UTILITY_PVT.Get_UserInfo(

3941: IF FND_API.To_Boolean (p_init_msg_list) THEN
3942: FND_MSG_PUB.initialize;
3943: END IF;
3944: -- Get the current (login) user id.
3945: AMV_UTILITY_PVT.Get_UserInfo(
3946: x_resource_id => l_resource_id,
3947: x_user_id => l_user_id,
3948: x_login_id => l_login_user_id,
3949: x_user_status => l_login_user_status

Line 4011: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(

4007: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
4008: IF (l_setup_result = FND_API.G_TRUE) THEN
4009: l_update_channel_flag := FND_API.G_TRUE;
4010: ELSE
4011: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
4012: l_channel_id,
4013: l_resource_id,
4014: AMV_UTILITY_PVT.G_USER) )
4015: THEN

Line 4014: AMV_UTILITY_PVT.G_USER) )

4010: ELSE
4011: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
4012: l_channel_id,
4013: l_resource_id,
4014: AMV_UTILITY_PVT.G_USER) )
4015: THEN
4016: l_update_channel_flag := FND_API.G_TRUE;
4017: ELSE
4018: -- user does not have privilege to create public channel

Line 4248: AMV_UTILITY_PVT.Get_UserInfo(

4244: IF FND_API.To_Boolean (p_init_msg_list) THEN
4245: FND_MSG_PUB.initialize;
4246: END IF;
4247: -- Get the current (login) user id.
4248: AMV_UTILITY_PVT.Get_UserInfo(
4249: x_resource_id => l_resource_id,
4250: x_user_id => l_user_id,
4251: x_login_id => l_login_user_id,
4252: x_user_status => l_login_user_status

Line 4448: AMV_UTILITY_PVT.Get_UserInfo(

4444: IF FND_API.To_Boolean (p_init_msg_list) THEN
4445: FND_MSG_PUB.initialize;
4446: END IF;
4447: -- Get the current (login) user id.
4448: AMV_UTILITY_PVT.Get_UserInfo(
4449: x_resource_id => l_resource_id,
4450: x_user_id => l_user_id,
4451: x_login_id => l_login_user_id,
4452: x_user_status => l_login_user_status

Line 4514: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(

4510: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
4511: IF (l_setup_result = FND_API.G_TRUE) THEN
4512: l_update_channel_flag := FND_API.G_TRUE;
4513: ELSE
4514: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
4515: l_channel_id,
4516: l_resource_id,
4517: AMV_UTILITY_PVT.G_USER) )
4518: THEN

Line 4517: AMV_UTILITY_PVT.G_USER) )

4513: ELSE
4514: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
4515: l_channel_id,
4516: l_resource_id,
4517: AMV_UTILITY_PVT.G_USER) )
4518: THEN
4519: l_update_channel_flag := FND_API.G_TRUE;
4520: ELSE
4521: -- user does not have privilege to create public channel

Line 4751: AMV_UTILITY_PVT.Get_UserInfo(

4747: IF FND_API.To_Boolean (p_init_msg_list) THEN
4748: FND_MSG_PUB.initialize;
4749: END IF;
4750: -- Get the current (login) user id.
4751: AMV_UTILITY_PVT.Get_UserInfo(
4752: x_resource_id => l_resource_id,
4753: x_user_id => l_user_id,
4754: x_login_id => l_login_user_id,
4755: x_user_status => l_login_user_status

Line 4951: AMV_UTILITY_PVT.Get_UserInfo(

4947: IF FND_API.To_Boolean (p_init_msg_list) THEN
4948: FND_MSG_PUB.initialize;
4949: END IF;
4950: -- Get the current (login) user id.
4951: AMV_UTILITY_PVT.Get_UserInfo(
4952: x_resource_id => l_resource_id,
4953: x_user_id => l_user_id,
4954: x_login_id => l_login_user_id,
4955: x_user_status => l_login_user_status

Line 5017: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(

5013: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5014: IF (l_setup_result = FND_API.G_TRUE) THEN
5015: l_update_channel_flag := FND_API.G_TRUE;
5016: ELSE
5017: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
5018: l_channel_id,
5019: l_resource_id,
5020: AMV_UTILITY_PVT.G_USER) )
5021: THEN

Line 5020: AMV_UTILITY_PVT.G_USER) )

5016: ELSE
5017: IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
5018: l_channel_id,
5019: l_resource_id,
5020: AMV_UTILITY_PVT.G_USER) )
5021: THEN
5022: l_update_channel_flag := FND_API.G_TRUE;
5023: ELSE
5024: -- user does not have privilege to create public channel

Line 5253: AMV_UTILITY_PVT.Get_UserInfo(

5249: IF FND_API.To_Boolean (p_init_msg_list) THEN
5250: FND_MSG_PUB.initialize;
5251: END IF;
5252: -- Get the current (login) user id.
5253: AMV_UTILITY_PVT.Get_UserInfo(
5254: x_resource_id => l_resource_id,
5255: x_user_id => l_user_id,
5256: x_login_id => l_login_user_id,
5257: x_user_status => l_login_user_status

Line 5406: p_item_status IN VARCHAR2 := AMV_UTILITY_PVT.G_APPROVED,

5402: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
5403: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
5404: p_channel_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
5405: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
5406: p_item_status IN VARCHAR2 := AMV_UTILITY_PVT.G_APPROVED,
5407: p_subset_request_rec IN AMV_REQUEST_OBJ_TYPE,
5408: x_subset_return_rec OUT NOCOPY AMV_RETURN_OBJ_TYPE,
5409: x_document_id_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
5410: )

Line 5439: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE

5435: from amv_c_chl_item_match cim
5436: , jtf_amv_items_vl ib
5437: where cim.channel_id = p_channel_id
5438: and cim.approval_status_type = p_item_status
5439: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
5440: and cim.available_for_channel_date <= sysdate
5441: and cim.item_id = ib.item_id;
5442:
5443: CURSOR Get_PendingItems IS

Line 5449: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE

5445: from amv_c_chl_item_match cim
5446: , jtf_amv_items_vl ib
5447: where cim.channel_id = p_channel_id
5448: and cim.approval_status_type = p_item_status
5449: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
5450: and cim.item_id = ib.item_id
5451: order by ib.effective_start_date;
5452:
5453: CURSOR C_TotalItmCount IS

Line 5459: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE

5455: from amv_c_chl_item_match cim
5456: , jtf_amv_items_vl ib
5457: where cim.channel_id = p_channel_id
5458: and cim.approval_status_type = p_item_status
5459: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
5460: and cim.available_for_channel_date <= sysdate
5461: and cim.item_id = ib.item_id
5462: and nvl(ib.effective_start_date, sysdate) <= sysdate + 1
5463: and nvl(ib.expiration_date, sysdate) >= sysdate;

Line 5471: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE

5467: from amv_c_chl_item_match cim
5468: , jtf_amv_items_vl ib
5469: where cim.channel_id = p_channel_id
5470: and cim.approval_status_type = p_item_status
5471: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
5472: and cim.available_for_channel_date <= sysdate
5473: and cim.item_id = ib.item_id
5474: and nvl(ib.effective_start_date, sysdate) <= sysdate + 1
5475: and nvl(ib.expiration_date, sysdate) >= sysdate

Line 5501: AMV_UTILITY_PVT.Get_UserInfo(

5497: IF FND_API.To_Boolean (p_init_msg_list) THEN
5498: FND_MSG_PUB.initialize;
5499: END IF;
5500: -- Get the current (login) user id.
5501: AMV_UTILITY_PVT.Get_UserInfo(
5502: x_resource_id => l_resource_id,
5503: x_user_id => l_user_id,
5504: x_login_id => l_login_user_id,
5505: x_user_status => l_login_user_status

Line 5560: IF p_item_status = AMV_UTILITY_PVT.G_APPROVED THEN

5556: ELSE
5557: x_return_status := FND_API.G_RET_STS_SUCCESS;
5558: --get the total items count:
5559: IF (p_subset_request_rec.return_total_count_flag = FND_API.G_TRUE) THEN
5560: IF p_item_status = AMV_UTILITY_PVT.G_APPROVED THEN
5561: OPEN C_TotalItmCount;
5562: FETCH C_TotalItmCount INTO l_total_record_count;
5563: CLOSE C_TotalItmCount;
5564: ELSE

Line 5575: IF p_item_status = AMV_UTILITY_PVT.G_APPROVED THEN

5571: IF (p_subset_request_rec.start_record_position IS NOT NULL) THEN
5572: l_start_with := p_subset_request_rec.start_record_position;
5573: END IF;
5574: -- fetch approved items
5575: IF p_item_status = AMV_UTILITY_PVT.G_APPROVED THEN
5576: OPEN Get_Items;
5577: x_document_id_array := AMV_NUMBER_VARRAY_TYPE();
5578: LOOP
5579: FETCH Get_Items INTO l_document_id;

Line 5760: AMV_UTILITY_PVT.Get_UserInfo(

5756: IF FND_API.To_Boolean (p_init_msg_list) THEN
5757: FND_MSG_PUB.initialize;
5758: END IF;
5759: -- Get the current (login) user id.
5760: AMV_UTILITY_PVT.Get_UserInfo(
5761: x_resource_id => l_resource_id,
5762: x_user_id => l_user_id,
5763: x_login_id => l_login_user_id,
5764: x_user_status => l_login_user_status

Line 5996: AMV_UTILITY_PVT.Get_UserInfo(

5992: IF FND_API.To_Boolean (p_init_msg_list) THEN
5993: FND_MSG_PUB.initialize;
5994: END IF;
5995: -- Get the current (login) user id.
5996: AMV_UTILITY_PVT.Get_UserInfo(
5997: x_resource_id => l_resource_id,
5998: x_user_id => l_user_id,
5999: x_login_id => l_login_user_id,
6000: x_user_status => l_login_user_status