APPS.AMS_CATEGORY_PVT dependencies on AMS_CATEGORIES_VL

Line 1043: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;

1039:
1040: -- Status Local Variables
1041: l_return_status VARCHAR2(1); -- Return value from procedures
1042: l_category_rec category_rec_type := p_category_rec;
1043: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;
1044:
1045: BEGIN
1046: ----------------------- initialize --------------------
1047: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1666: -- This procedure is to validate cross entity AMS_CATEGORIES_VL items

1662: -- NAME
1663: -- Validate_Category_Cross_Entity
1664: --
1665: -- PURPOSE
1666: -- This procedure is to validate cross entity AMS_CATEGORIES_VL items
1667: --
1668: -- NOTES
1669: --CATEGORY_ID
1670: --

Line 1973: FROM ams_categories_vl

1969: ) IS
1970:
1971: CURSOR c_cat IS
1972: SELECT *
1973: FROM ams_categories_vl
1974: WHERE category_id = p_category_rec.category_id;
1975:
1976: l_category_rec c_cat%ROWTYPE;
1977:

Line 2054: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;

2050: l_act_category_rec category_rec_type;
2051: l_return_status VARCHAR2(1);
2052: l_msg_count NUMBER;
2053: l_msg_data VARCHAR2(200);
2054: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;
2055:
2056: l_category_req_item_rec category_rec_type;
2057: l_Category_validate_item_rec category_rec_type;
2058: l_Category_default_item_rec category_rec_type;

Line 2113: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;

2109: l_category_rec category_rec_type;
2110: l_return_status VARCHAR2(1);
2111: l_msg_count NUMBER;
2112: l_msg_data VARCHAR2(200);
2113: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;
2114:
2115: l_Category_req_item_rec category_rec_type;
2116: l_Category_validate_item_rec category_rec_type;
2117: l_Category_default_item_rec category_rec_type;

Line 2165: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;

2161: l_category_rec category_rec_type;
2162: l_return_status VARCHAR2(1);
2163: l_msg_count NUMBER;
2164: l_msg_data VARCHAR2(200);
2165: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;
2166:
2167: l_Category_req_item_rec category_rec_type;
2168: l_Category_validate_item_rec category_rec_type;
2169: l_Category_default_item_rec category_rec_type;

Line 2174: from AMS_CATEGORIES_VL

2170: l_Category_validate_row_rec category_rec_type;
2171:
2172: cursor C(my_category_id NUMBER) is
2173: select *
2174: from AMS_CATEGORIES_VL
2175: WHERE CATEGORY_ID = my_category_id;
2176: BEGIN
2177:
2178: -- turned on debug mode

Line 2227: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;

2223: l_category_rec category_rec_type;
2224: l_return_status VARCHAR2(1);
2225: l_msg_count NUMBER;
2226: l_msg_data VARCHAR2(200);
2227: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;
2228:
2229: l_Category_req_item_rec category_rec_type;
2230: l_Category_validate_item_rec category_rec_type;
2231: l_Category_default_item_rec category_rec_type;