APPS.AK_CUSTOM2_PVT dependencies on AK_CRITERIA

Line 97: l_criteria_rec AK_CRITERIA%ROWTYPE;

93: l_cust_reg_item_index NUMBER := 0;
94: l_cust_reg_item_rec AK_CUSTOM_PUB.Cust_Reg_Item_Rec_Type;
95: l_cust_reg_item_tbl AK_CUSTOM_PUB.Cust_Reg_Item_Tbl_Type;
96: l_criteria_index NUMBER := 0;
97: l_criteria_rec AK_CRITERIA%ROWTYPE;
98: l_empty_criteria_rec AK_CRITERIA%ROWTYPE;
99: l_criteria_tbl AK_CUSTOM_PUB.Criteria_Tbl_Type;
100: l_error_key_info VARCHAR2(500); -- for debug purpose: see EXCEPTION stack
101:

Line 98: l_empty_criteria_rec AK_CRITERIA%ROWTYPE;

94: l_cust_reg_item_rec AK_CUSTOM_PUB.Cust_Reg_Item_Rec_Type;
95: l_cust_reg_item_tbl AK_CUSTOM_PUB.Cust_Reg_Item_Tbl_Type;
96: l_criteria_index NUMBER := 0;
97: l_criteria_rec AK_CRITERIA%ROWTYPE;
98: l_empty_criteria_rec AK_CRITERIA%ROWTYPE;
99: l_criteria_tbl AK_CUSTOM_PUB.Criteria_Tbl_Type;
100: l_error_key_info VARCHAR2(500); -- for debug purpose: see EXCEPTION stack
101:
102: begin

Line 1544: from ak_criteria ac

1540:
1541: -- do not update customized data
1542: select last_updated_by, last_update_date into
1543: l_user_id1, l_update1
1544: from ak_criteria ac
1545: where ac.customization_application_id = l_criteria_tbl(l_index).customization_application_id
1546: and ac.customization_code = l_criteria_tbl(l_index).customization_code
1547: and ac.region_application_id = l_criteria_tbl(l_index).region_application_id
1548: and ac.region_code = l_criteria_tbl(l_index).region_code