APPS.FV_CGAC_CRT_TAS dependencies on FV_BUDGET_DISTRIBUTION_HDR

Line 89: SELECT * FROM fv_budget_distribution_hdr

85: AND set_of_books_id = p_ledger_id;
86: --AND auto_create='Y';
87:
88: CURSOR c_budget_distribution_hdr(p_treasury_symbol_id NUMBER, p_fund_value VARCHAR2) IS
89: SELECT * FROM fv_budget_distribution_hdr
90: WHERE treasury_symbol_id = p_treasury_symbol_id
91: AND set_of_books_id = p_ledger_id
92: AND fund_value = p_fund_value;
93:

Line 111: bud_distr_hdr_record FV_BUDGET_DISTRIBUTION_HDR%ROWTYPE;

107:
108: -- RECORD DEFINITIONS
109: treasury_symbol_record FV_TREASURY_SYMBOLS%ROWTYPE;
110: fund_values_record FV_FUND_PARAMETERS%ROWTYPE;
111: bud_distr_hdr_record FV_BUDGET_DISTRIBUTION_HDR%ROWTYPE;
112: bud_distr_dtl_record FV_BUDGET_DISTRIBUTION_DTL%ROWTYPE;
113: cgac_crttas_record FV_CGAC_CRT_TAS_TEMP%ROWTYPE;
114:
115: l_max_period GL_PERIODS.PERIOD_NUM%TYPE;

Line 123: l_bud_distribution_id FV_BUDGET_DISTRIBUTION_HDR.distribution_id%TYPE;

119: l_cancellation_date FV_TREASURY_SYMBOLS.CANCELLATION_DATE%TYPE;
120: l_ts_str VARCHAR2(100);
121: l_treasury_symbol_id FV_TREASURY_SYMBOLS.treasury_symbol_id%TYPE;
122: l_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE;
123: l_bud_distribution_id FV_BUDGET_DISTRIBUTION_HDR.distribution_id%TYPE;
124: l_bud_distribution_dtl_id FV_BUDGET_DISTRIBUTION_DTL.distribution_dtl_id%TYPE;
125: l_treasury_acct_code FV_FACTS_FEDERAL_ACCOUNTS.treasury_acct_code%TYPE;
126: l_treasury_dept_code FV_FACTS_FEDERAL_ACCOUNTS.treasury_dept_code%TYPE;
127:

Line 161: l_auto_create_dist FV_BUDGET_DISTRIBUTION_HDR.auto_create_flag%TYPE;

157: l_auto_create_flag_betc FV_TREASURY_SYMBOLS.auto_create_flag_betc%TYPE;
158: l_auto_create_flag FV_TP_TREASURY_SYMBOLS.auto_create_flag%TYPE;
159: l_auto_create_flag_tas FV_TREASURY_SYMBOLS.auto_create%TYPE;
160: l_auto_create_fund FV_FUND_PARAMETERS.auto_create%TYPE;
161: l_auto_create_dist FV_BUDGET_DISTRIBUTION_HDR.auto_create_flag%TYPE;
162:
163: bal_seg_suffix NUMBER;
164: bfy_seg_suffix NUMBER;
165: v_default_segment VARCHAR2(1000);

Line 788: SELECT auto_create_flag into l_auto_create_dist FROM fv_budget_distribution_hdr

784: END IF;
785: END IF;
786:
787: BEGIN
788: SELECT auto_create_flag into l_auto_create_dist FROM fv_budget_distribution_hdr
789: WHERE treasury_symbol_id = l_treasury_symbol_id
790: AND set_of_books_id = p_ledger_id
791: AND fund_value = l_fund_value;
792: cgac_crttas_record.auto_dist := l_auto_create_dist;

Line 822: -- INSERT INTO fv_budget_distribution_hdr VALUES budget_distribution_hdr_record;

818: budget_distribution_hdr_record.last_updated_by := l_user_id;
819:
820: IF p_run_mode = 'F' THEN
821: -- Commented for GSCC error
822: -- INSERT INTO fv_budget_distribution_hdr VALUES budget_distribution_hdr_record;
823: INSERT INTO fv_budget_distribution_hdr
824: (DISTRIBUTION_ID,
825: FUND_VALUE,
826: TREASURY_SYMBOL,

Line 823: INSERT INTO fv_budget_distribution_hdr

819:
820: IF p_run_mode = 'F' THEN
821: -- Commented for GSCC error
822: -- INSERT INTO fv_budget_distribution_hdr VALUES budget_distribution_hdr_record;
823: INSERT INTO fv_budget_distribution_hdr
824: (DISTRIBUTION_ID,
825: FUND_VALUE,
826: TREASURY_SYMBOL,
827: SET_OF_BOOKS_ID,