APPS.IGI_BUD dependencies on IGI_BUD_PROFILE_DEFAULTS

Line 582: This proceedure updates or inserts into igi_bud_profile_defaults

578: RETURN (r_where_list);
579: END; -- Of flexsql_range
580:
581: /* ==================================================================
582: This proceedure updates or inserts into igi_bud_profile_defaults
583: Parameters: Valid Code Combination ID
584: Valid Set of Books ID
585: Valid Profile Code */
586:

Line 596: UPDATE igi_bud_profile_defaults

592: IS
593: err_msg VARCHAR2(240);
594: BEGIN
595: IF p_new_profile_code is NOT NULL THEN
596: UPDATE igi_bud_profile_defaults
597: SET latest_profile_code = p_new_profile_code
598: WHERE code_combination_id = p_code_combination_id
599: AND set_of_books_id = p_set_of_books_id;
600:

Line 602: INSERT INTO igi_bud_profile_defaults

598: WHERE code_combination_id = p_code_combination_id
599: AND set_of_books_id = p_set_of_books_id;
600:
601: IF SQL%NOTFOUND THEN -- No row to update so
602: INSERT INTO igi_bud_profile_defaults
603: ( code_combination_id
604: , set_of_books_id
605: , primary_profile_code
606: , latest_profile_code