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_CATEGORY_PVT dependencies on AMV_UTILITY_PVT

Line 123: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN

119: -- passed both id and name. id taken by default.
120: x_error_msg:='AMV_CAT_ID_AND_NAME_PASSED';
121: END IF;
122: x_return_status := FND_API.G_RET_STS_SUCCESS;
123: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
124: -- Category Id exists
125: x_exist_flag := FND_API.G_TRUE;
126: x_category_id := p_category_id;
127: x_error_msg:='AMV_CAT_ID_EXISTS';

Line 184: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_parent_category_id) THEN

180: -- passed both id and name. id taken by default.
181: x_error_msg := 'AMV_CAT_ID_AND_NAME_PASSED';
182: END IF;
183: -- check if parent category id is valid
184: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_parent_category_id) THEN
185: x_category_id :=Get_CategoryId( p_category_name,
186: p_parent_category_id);
187: IF x_category_id <> FND_API.G_MISS_NUM THEN
188: x_exist_flag := FND_API.G_TRUE;

Line 413: if AMV_UTILITY_PVT.Is_CategoryIdValid(l_cat_id) then

409: l_cat_name);
410: */
411: l_cat_hr := l_cat_hr + 1;
412:
413: if AMV_UTILITY_PVT.Is_CategoryIdValid(l_cat_id) then
414: open scat_id;
415: loop
416: fetch scat_id into l_cat_id, l_temp_cat_name;
417: exit when scat_id%notfound;

Line 479: if AMV_UTILITY_PVT.Is_CategoryIdValid(l_cat_id) then

475: */
476:
477: l_cat_hr := l_cat_hr + 1;
478:
479: if AMV_UTILITY_PVT.Is_CategoryIdValid(l_cat_id) then
480: open get_parent;
481: fetch get_parent into l_cat_id;
482: if l_cat_id is not null then
483: Get_CategoryParents(l_cat_id, l_cat_hr, p_category_hierarchy);

Line 507: -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)

503: -- Default = FND_API.G_FALSE
504: -- p_validation_level IN NUMBER Optional
505: -- Default = FND_API.G_VALID_LEVEL_FULL
506: -- p_application_id IN NUMBER Optional
507: -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)
508: -- p_category_name IN VARCHAR2 Required
509: -- the channel (sub)category name. Have to be unique.
510: -- p_description IN VARCHAR2 Optional
511: -- the channel (sub)category description.

Line 541: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,

537: x_return_status OUT NOCOPY VARCHAR2,
538: x_msg_count OUT NOCOPY NUMBER,
539: x_msg_data OUT NOCOPY VARCHAR2,
540: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
541: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
542: p_category_name IN VARCHAR2,
543: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
544: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
545: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 608: AMV_UTILITY_PVT.Get_UserInfo(

604: IF FND_API.To_Boolean (p_init_msg_list) THEN
605: FND_MSG_PUB.initialize;
606: END IF;
607: -- Get the current (login) user id.
608: AMV_UTILITY_PVT.Get_UserInfo(
609: x_resource_id => l_resource_id,
610: x_user_id => l_user_id,
611: x_login_id => l_login_user_id,
612: x_user_status => l_login_user_status

Line 891: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,

887: x_return_status OUT NOCOPY VARCHAR2,
888: x_msg_count OUT NOCOPY NUMBER,
889: x_msg_data OUT NOCOPY VARCHAR2,
890: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
891: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
892: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
893: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
895: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 949: AMV_UTILITY_PVT.Get_UserInfo(

945: IF FND_API.To_Boolean (p_init_msg_list) THEN
946: FND_MSG_PUB.initialize;
947: END IF;
948: -- Get the current (login) user id.
949: AMV_UTILITY_PVT.Get_UserInfo(
950: x_resource_id => l_resource_id,
951: x_user_id => l_user_id,
952: x_login_id => l_login_user_id,
953: x_user_status => l_login_user_status

Line 1018: IF (AMV_UTILITY_PVT.Get_DeleteCategoryStatus(

1014: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1015: IF (l_setup_result = FND_API.G_TRUE) THEN
1016: l_delete_category_flag := FND_API.G_TRUE;
1017: ELSE
1018: IF (AMV_UTILITY_PVT.Get_DeleteCategoryStatus(
1019: l_category_id,
1020: l_resource_id,
1021: AMV_UTILITY_PVT.G_USER) )
1022: THEN

Line 1021: AMV_UTILITY_PVT.G_USER) )

1017: ELSE
1018: IF (AMV_UTILITY_PVT.Get_DeleteCategoryStatus(
1019: l_category_id,
1020: l_resource_id,
1021: AMV_UTILITY_PVT.G_USER) )
1022: THEN
1023: l_delete_category_flag := FND_API.G_TRUE;
1024: ELSE
1025: -- user does not have privilege to create category

Line 1063: AND subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL;

1059:
1060: -- Remove channel from mychannels
1061: DELETE FROM amv_u_my_channels
1062: WHERE subscribing_to_id = l_channel_id
1063: AND subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL;
1064:
1065: -- Remove access given to this channel
1066: DELETE FROM amv_u_access
1067: WHERE access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL

Line 1067: WHERE access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL

1063: AND subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL;
1064:
1065: -- Remove access given to this channel
1066: DELETE FROM amv_u_access
1067: WHERE access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
1068: AND access_to_table_record_id = l_channel_id;
1069:
1070: -- Remove channel from authors
1071: DELETE FROM amv_c_authors

Line 1098: AND subscribing_to_type = AMV_UTILITY_PVT.G_CATEGORY;

1094: -- Remove category from my channels
1095: DELETE FROM amv_u_my_channels
1096: --WHERE subscribing_to_id = l_category_id pls refer the bug# 2626331,2720397
1097: WHERE subscribing_to_id = l_category_hr(i).id
1098: AND subscribing_to_type = AMV_UTILITY_PVT.G_CATEGORY;
1099:
1100: -- Remove channel category
1101: AMV_C_CATEGORIES_PKG.DELETE_ROW(l_category_hr(i).id);
1102: END LOOP;

Line 1207: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,

1203: x_return_status OUT NOCOPY VARCHAR2,
1204: x_msg_count OUT NOCOPY NUMBER,
1205: x_msg_data OUT NOCOPY VARCHAR2,
1206: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1207: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1208: p_sort_order IN VARCHAR2 := AMV_CATEGORY_PVT.G_ASC_ORDER,
1209: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
1210: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
1211: )

Line 1276: AMV_UTILITY_PVT.Get_UserInfo(

1272: IF FND_API.To_Boolean (p_init_msg_list) THEN
1273: FND_MSG_PUB.initialize;
1274: END IF;
1275: -- Get the current (login) user id.
1276: AMV_UTILITY_PVT.Get_UserInfo(
1277: x_resource_id => l_resource_id,
1278: x_user_id => l_user_id,
1279: x_login_id => l_login_user_id,
1280: x_user_status => l_login_user_status

Line 1487: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,

1483: x_return_status OUT NOCOPY VARCHAR2,
1484: x_msg_count OUT NOCOPY NUMBER,
1485: x_msg_data OUT NOCOPY VARCHAR2,
1486: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1487: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1488: p_category_id_array IN AMV_NUMBER_VARRAY_TYPE,
1489: p_category_new_order IN AMV_NUMBER_VARRAY_TYPE
1490: )
1491: IS

Line 1538: AMV_UTILITY_PVT.Get_UserInfo(

1534: IF FND_API.To_Boolean (p_init_msg_list) THEN
1535: FND_MSG_PUB.initialize;
1536: END IF;
1537: -- Get the current (login) user id.
1538: AMV_UTILITY_PVT.Get_UserInfo(
1539: x_resource_id => l_resource_id,
1540: x_user_id => l_user_id,
1541: x_login_id => l_login_user_id,
1542: x_user_status => l_login_user_status

Line 1725: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,

1721: x_msg_count OUT NOCOPY NUMBER,
1722: x_msg_data OUT NOCOPY VARCHAR2,
1723: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1724: p_object_version_number IN NUMBER,
1725: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1726: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
1727: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1728: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
1729: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1799: AMV_UTILITY_PVT.Get_UserInfo(

1795: IF FND_API.To_Boolean (p_init_msg_list) THEN
1796: FND_MSG_PUB.initialize;
1797: END IF;
1798: -- Get the current (login) user id.
1799: AMV_UTILITY_PVT.Get_UserInfo(
1800: x_resource_id => l_resource_id,
1801: x_user_id => l_user_id,
1802: x_login_id => l_login_user_id,
1803: x_user_status => l_login_user_status

Line 1918: IF (AMV_UTILITY_PVT.Get_UpdateCategoryStatus(

1914: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1915: IF (l_setup_result = FND_API.G_TRUE) THEN
1916: l_update_category_flag := FND_API.G_TRUE;
1917: ELSE
1918: IF (AMV_UTILITY_PVT.Get_UpdateCategoryStatus(
1919: l_category_id,
1920: l_resource_id,
1921: AMV_UTILITY_PVT.G_USER) )
1922: THEN

Line 1921: AMV_UTILITY_PVT.G_USER) )

1917: ELSE
1918: IF (AMV_UTILITY_PVT.Get_UpdateCategoryStatus(
1919: l_category_id,
1920: l_resource_id,
1921: AMV_UTILITY_PVT.G_USER) )
1922: THEN
1923: l_update_category_flag := FND_API.G_TRUE;
1924: ELSE
1925: -- user does not have privilege to create category

Line 2092: -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)

2088: -- Default = FND_API.G_FALSE
2089: -- p_validation_level IN NUMBER Optional
2090: -- Default = FND_API.G_VALID_LEVEL_FULL
2091: -- p_application_id IN NUMBER Optional
2092: -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)
2093: -- application creating the channel
2094: -- p_category_name IN VARCHAR2 Optional
2095: -- Search criteria by name. Default = '%' (everything)
2096: -- p_parent_category_id IN NUMBER Optional

Line 2122: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,

2118: x_return_status OUT NOCOPY VARCHAR2,
2119: x_msg_count OUT NOCOPY NUMBER,
2120: x_msg_data OUT NOCOPY VARCHAR2,
2121: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2122: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
2123: p_category_name IN VARCHAR2 := '%',
2124: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
2125: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
2126: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,

Line 2252: AMV_UTILITY_PVT.Get_UserInfo(

2248: IF FND_API.To_Boolean (p_init_msg_list) THEN
2249: FND_MSG_PUB.initialize;
2250: END IF;
2251: -- Get the current (login) user id.
2252: AMV_UTILITY_PVT.Get_UserInfo(
2253: x_resource_id => l_resource_id,
2254: x_user_id => l_user_id,
2255: x_login_id => l_login_user_id,
2256: x_user_status => l_login_user_status

Line 2635: AMV_UTILITY_PVT.Get_UserInfo(

2631: IF FND_API.To_Boolean (p_init_msg_list) THEN
2632: FND_MSG_PUB.initialize;
2633: END IF;
2634: -- Get the current (login) user id.
2635: AMV_UTILITY_PVT.Get_UserInfo(
2636: x_resource_id => l_resource_id,
2637: x_user_id => l_user_id,
2638: x_login_id => l_login_user_id,
2639: x_user_status => l_login_user_status

Line 2663: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN

2659: -- Initialize API return status to sucess
2660: x_return_status := FND_API.G_RET_STS_SUCCESS;
2661:
2662: --
2663: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
2664: x_content_chan_array := AMV_CAT_HIERARCHY_VARRAY_TYPE();
2665: IF p_include_subcats = FND_API.G_FALSE THEN
2666: l_category_id := p_category_id;
2667: OPEN Get_CategoryChannels;

Line 2836: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED

2832: from amv_c_chl_item_match cim
2833: , jtf_amv_items_vl ib
2834: where cim.channel_category_id = l_category_id
2835: and cim.channel_id is null
2836: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED
2837: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
2838: and cim.available_for_channel_date <= sysdate
2839: and cim.item_id = ib.item_id
2840: and nvl(ib.effective_start_date, sysdate) <= sysdate + 1

Line 2837: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE

2833: , jtf_amv_items_vl ib
2834: where cim.channel_category_id = l_category_id
2835: and cim.channel_id is null
2836: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED
2837: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
2838: and cim.available_for_channel_date <= sysdate
2839: and cim.item_id = ib.item_id
2840: and nvl(ib.effective_start_date, sysdate) <= sysdate + 1
2841: and nvl(ib.expiration_date, sysdate) >= sysdate

Line 2867: AMV_UTILITY_PVT.Get_UserInfo(

2863: IF FND_API.To_Boolean (p_init_msg_list) THEN
2864: FND_MSG_PUB.initialize;
2865: END IF;
2866: -- Get the current (login) user id.
2867: AMV_UTILITY_PVT.Get_UserInfo(
2868: x_resource_id => l_resource_id,
2869: x_user_id => l_user_id,
2870: x_login_id => l_login_user_id,
2871: x_user_status => l_login_user_status

Line 2895: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN

2891: -- Initialize API return status to sucess
2892: x_return_status := FND_API.G_RET_STS_SUCCESS;
2893:
2894: --
2895: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
2896: x_items_array := AMV_CAT_HIERARCHY_VARRAY_TYPE();
2897: IF p_include_subcats = FND_API.G_FALSE THEN
2898: l_category_id := p_category_id;
2899: OPEN Get_CategoryItems_csr;

Line 3074: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED

3070: from amv_c_chl_item_match cim
3071: , jtf_amv_items_vl ib
3072: where cim.channel_category_id = l_category_id
3073: and cim.channel_id is null
3074: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED
3075: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
3076: and cim.available_for_channel_date <= sysdate
3077: and cim.item_id = ib.item_id
3078: and nvl(ib.effective_start_date, sysdate) <= sysdate + 1

Line 3075: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE

3071: , jtf_amv_items_vl ib
3072: where cim.channel_category_id = l_category_id
3073: and cim.channel_id is null
3074: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED
3075: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
3076: and cim.available_for_channel_date <= sysdate
3077: and cim.item_id = ib.item_id
3078: and nvl(ib.effective_start_date, sysdate) <= sysdate + 1
3079: and nvl(ib.expiration_date, sysdate) >= sysdate

Line 3088: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED

3084: from amv_c_chl_item_match cim
3085: , jtf_amv_items_vl ib
3086: where cim.channel_category_id = l_category_id
3087: and cim.channel_id is null
3088: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED
3089: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
3090: and cim.available_for_channel_date <= sysdate
3091: and cim.item_id = ib.item_id
3092: and nvl(ib.effective_start_date, sysdate) <= sysdate + 1

Line 3089: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE

3085: , jtf_amv_items_vl ib
3086: where cim.channel_category_id = l_category_id
3087: and cim.channel_id is null
3088: and cim.approval_status_type = AMV_UTILITY_PVT.G_APPROVED
3089: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
3090: and cim.available_for_channel_date <= sysdate
3091: and cim.item_id = ib.item_id
3092: and nvl(ib.effective_start_date, sysdate) <= sysdate + 1
3093: and nvl(ib.expiration_date, sysdate) >= sysdate;

Line 3118: AMV_UTILITY_PVT.Get_UserInfo(

3114: IF FND_API.To_Boolean (p_init_msg_list) THEN
3115: FND_MSG_PUB.initialize;
3116: END IF;
3117: -- Get the current (login) user id.
3118: AMV_UTILITY_PVT.Get_UserInfo(
3119: x_resource_id => l_resource_id,
3120: x_user_id => l_user_id,
3121: x_login_id => l_login_user_id,
3122: x_user_status => l_login_user_status

Line 3146: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN

3142: -- Initialize API return status to sucess
3143: x_return_status := FND_API.G_RET_STS_SUCCESS;
3144:
3145: --
3146: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
3147: x_items_array := AMV_CAT_HIERARCHY_VARRAY_TYPE();
3148: IF p_include_subcats = FND_API.G_FALSE THEN
3149: l_category_id := p_category_id;
3150: IF ( p_category_sort.sort_col = null ) THEN

Line 3341: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,

3337: x_return_status OUT NOCOPY VARCHAR2,
3338: x_msg_count OUT NOCOPY NUMBER,
3339: x_msg_data OUT NOCOPY VARCHAR2,
3340: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
3341: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
3342: p_category_name IN VARCHAR2,
3343: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
3344: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3345: x_category_id OUT NOCOPY NUMBER

Line 3387: AMV_UTILITY_PVT.Get_UserInfo(

3383: IF FND_API.To_Boolean (p_init_msg_list) THEN
3384: FND_MSG_PUB.initialize;
3385: END IF;
3386: -- Get the current (login) user id.
3387: AMV_UTILITY_PVT.Get_UserInfo(
3388: x_resource_id => l_resource_id,
3389: x_user_id => l_user_id,
3390: x_login_id => l_login_user_id,
3391: x_user_status => l_login_user_status

Line 3560: AMV_UTILITY_PVT.Get_UserInfo(

3556: IF FND_API.To_Boolean (p_init_msg_list) THEN
3557: FND_MSG_PUB.initialize;
3558: END IF;
3559: -- Get the current (login) user id.
3560: AMV_UTILITY_PVT.Get_UserInfo(
3561: x_resource_id => l_resource_id,
3562: x_user_id => l_user_id,
3563: x_login_id => l_login_user_id,
3564: x_user_status => l_login_user_status

Line 3588: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN

3584: -- Initialize API return status to sucess
3585: x_return_status := FND_API.G_RET_STS_SUCCESS;
3586:
3587: --
3588: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
3589:
3590: x_category_hierarchy := amv_cat_hierarchy_varray_type();
3591:
3592: Get_CategoryParents(p_category_id,

Line 3731: AMV_UTILITY_PVT.Get_UserInfo(

3727: IF FND_API.To_Boolean (p_init_msg_list) THEN
3728: FND_MSG_PUB.initialize;
3729: END IF;
3730: -- Get the current (login) user id.
3731: AMV_UTILITY_PVT.Get_UserInfo(
3732: x_resource_id => l_resource_id,
3733: x_user_id => l_user_id,
3734: x_login_id => l_login_user_id,
3735: x_user_status => l_login_user_status

Line 3759: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN

3755: -- Initialize API return status to sucess
3756: x_return_status := FND_API.G_RET_STS_SUCCESS;
3757:
3758: --
3759: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
3760:
3761: x_category_hierarchy := amv_cat_hierarchy_varray_type();
3762:
3763: Get_CategoryHierarchy(p_category_id,

Line 3914: AMV_UTILITY_PVT.Get_UserInfo(

3910: IF FND_API.To_Boolean (p_init_msg_list) THEN
3911: FND_MSG_PUB.initialize;
3912: END IF;
3913: -- Get the current (login) user id.
3914: AMV_UTILITY_PVT.Get_UserInfo(
3915: x_resource_id => l_resource_id,
3916: x_user_id => l_user_id,
3917: x_login_id => l_login_user_id,
3918: x_user_status => l_login_user_status

Line 3942: IF AMV_UTILITY_PVT.Is_ChannelIdValid(p_channel_id) THEN

3938: -- Initialize API return status to sucess
3939: x_return_status := FND_API.G_RET_STS_SUCCESS;
3940:
3941: --
3942: IF AMV_UTILITY_PVT.Is_ChannelIdValid(p_channel_id) THEN
3943: OPEN Get_ChannelData;
3944: FETCH Get_ChannelData INTO x_channel_name, l_category_id;
3945: CLOSE Get_ChannelData;
3946:

Line 4115: AMV_UTILITY_PVT.Get_UserInfo(

4111: IF FND_API.To_Boolean (p_init_msg_list) THEN
4112: FND_MSG_PUB.initialize;
4113: END IF;
4114: -- Get the current (login) user id.
4115: AMV_UTILITY_PVT.Get_UserInfo(
4116: x_resource_id => l_resource_id,
4117: x_user_id => l_user_id,
4118: x_login_id => l_login_user_id,
4119: x_user_status => l_login_user_status

Line 4143: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN

4139: -- Initialize API return status to sucess
4140: x_return_status := FND_API.G_RET_STS_SUCCESS;
4141:
4142: --
4143: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
4144: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_parent_category_id) THEN
4145: OPEN Get_ParentId;
4146: FETCH Get_ParentId INTO l_parent_category_id,
4147: l_cat_name,

Line 4144: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_parent_category_id) THEN

4140: x_return_status := FND_API.G_RET_STS_SUCCESS;
4141:
4142: --
4143: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
4144: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_parent_category_id) THEN
4145: OPEN Get_ParentId;
4146: FETCH Get_ParentId INTO l_parent_category_id,
4147: l_cat_name,
4148: l_object_version_number,

Line 4407: AMV_UTILITY_PVT.Get_UserInfo(

4403: IF FND_API.To_Boolean (p_init_msg_list) THEN
4404: FND_MSG_PUB.initialize;
4405: END IF;
4406: -- Get the current (login) user id.
4407: AMV_UTILITY_PVT.Get_UserInfo(
4408: x_resource_id => l_resource_id,
4409: x_user_id => l_user_id,
4410: x_login_id => l_login_user_id,
4411: x_user_status => l_login_user_status

Line 4435: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN

4431: -- Initialize API return status to sucess
4432: x_return_status := FND_API.G_RET_STS_SUCCESS;
4433:
4434: --
4435: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
4436: OPEN Get_ParentId;
4437: FETCH Get_ParentId INTO l_parent_category_id,
4438: l_object_version_number,
4439: l_application_id,