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 2052: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;

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

Line 2111: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;

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

Line 2163: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;

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

Line 2172: from AMS_CATEGORIES_VL

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

Line 2225: l_category_id AMS_CATEGORIES_VL.CATEGORY_ID%TYPE;

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