DBA Data[Home] [Help]

APPS.AK_CUSTOM2_PVT dependencies on AK_CUSTOM_PUB

Line 88: l_custom_rec AK_CUSTOM_PUB.Custom_Rec_Type;

84: l_user_id1 NUMBER;
85: l_user_id2 NUMBER;
86: l_update1 DATE;
87: l_update2 DATE;
88: l_custom_rec AK_CUSTOM_PUB.Custom_Rec_Type;
89: l_custom_tbl AK_CUSTOM_PUB.Custom_Tbl_Type;
90: l_cust_region_index NUMBER := 0;
91: l_cust_region_rec AK_CUSTOM_PUB.Cust_Region_Rec_Type;
92: l_cust_region_tbl AK_CUSTOM_PUB.Cust_Region_Tbl_Type;

Line 89: l_custom_tbl AK_CUSTOM_PUB.Custom_Tbl_Type;

85: l_user_id2 NUMBER;
86: l_update1 DATE;
87: l_update2 DATE;
88: l_custom_rec AK_CUSTOM_PUB.Custom_Rec_Type;
89: l_custom_tbl AK_CUSTOM_PUB.Custom_Tbl_Type;
90: l_cust_region_index NUMBER := 0;
91: l_cust_region_rec AK_CUSTOM_PUB.Cust_Region_Rec_Type;
92: l_cust_region_tbl AK_CUSTOM_PUB.Cust_Region_Tbl_Type;
93: l_cust_reg_item_index NUMBER := 0;

Line 91: l_cust_region_rec AK_CUSTOM_PUB.Cust_Region_Rec_Type;

87: l_update2 DATE;
88: l_custom_rec AK_CUSTOM_PUB.Custom_Rec_Type;
89: l_custom_tbl AK_CUSTOM_PUB.Custom_Tbl_Type;
90: l_cust_region_index NUMBER := 0;
91: l_cust_region_rec AK_CUSTOM_PUB.Cust_Region_Rec_Type;
92: l_cust_region_tbl AK_CUSTOM_PUB.Cust_Region_Tbl_Type;
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;

Line 92: l_cust_region_tbl AK_CUSTOM_PUB.Cust_Region_Tbl_Type;

88: l_custom_rec AK_CUSTOM_PUB.Custom_Rec_Type;
89: l_custom_tbl AK_CUSTOM_PUB.Custom_Tbl_Type;
90: l_cust_region_index NUMBER := 0;
91: l_cust_region_rec AK_CUSTOM_PUB.Cust_Region_Rec_Type;
92: l_cust_region_tbl AK_CUSTOM_PUB.Cust_Region_Tbl_Type;
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;

Line 94: l_cust_reg_item_rec AK_CUSTOM_PUB.Cust_Reg_Item_Rec_Type;

90: l_cust_region_index NUMBER := 0;
91: l_cust_region_rec AK_CUSTOM_PUB.Cust_Region_Rec_Type;
92: l_cust_region_tbl AK_CUSTOM_PUB.Cust_Region_Tbl_Type;
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;

Line 95: l_cust_reg_item_tbl AK_CUSTOM_PUB.Cust_Reg_Item_Tbl_Type;

91: l_cust_region_rec AK_CUSTOM_PUB.Cust_Region_Rec_Type;
92: l_cust_region_tbl AK_CUSTOM_PUB.Cust_Region_Tbl_Type;
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;

Line 99: l_criteria_tbl AK_CUSTOM_PUB.Criteria_Tbl_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
103: --dbms_output.put_line('Started region upload: ' ||

Line 213: l_custom_rec := AK_CUSTOM_PUB.G_MISS_CUSTOM_REC;

209: end if;
210: elsif (l_state = 1) then
211: if (l_token = 'CUSTOMIZATION') then
212: --== Clear out previous column data ==--
213: l_custom_rec := AK_CUSTOM_PUB.G_MISS_CUSTOM_REC;
214: l_state := 2;
215: else
216: -- Found the beginning of a non-custom object,
217: -- rebuild last line and pass it back to the caller

Line 396: l_cust_region_rec := AK_CUSTOM_PUB.G_MISS_CUST_REGION_REC;

392: elsif (l_state = 13) then
393: if (l_token = 'CUSTOM_REGION') then
394: --== Clear out previous region item column data ==--
395: -- and load region key values into record --
396: l_cust_region_rec := AK_CUSTOM_PUB.G_MISS_CUST_REGION_REC;
397: l_cust_region_rec.customization_appl_id := l_custom_rec.customization_appl_id;
398: l_cust_region_rec.customization_code := l_custom_rec.customization_code;
399: l_cust_region_rec.region_appl_id := l_custom_rec.region_appl_id;
400: l_cust_region_rec.region_code := l_custom_rec.region_code;

Line 405: l_cust_reg_item_rec := AK_CUSTOM_PUB.G_MISS_CUST_REG_ITEM_REC;

401: l_state := 20;
402: elsif ( l_token = 'CUSTOM_REGION_ITEM') then
403: -- clear out previous custom region item column data --
404: -- and load customization key values into record --
405: l_cust_reg_item_rec := AK_CUSTOM_PUB.G_MISS_CUST_REG_ITEM_REC;
406: l_cust_reg_item_rec.customization_appl_id := l_custom_rec.customization_appl_id;
407: l_cust_reg_item_rec.customization_code := l_custom_rec.customization_code;
408: l_cust_reg_item_rec.region_appl_id := l_custom_rec.region_appl_id;
409: l_cust_reg_item_rec.region_code := l_custom_rec.region_code;