APPS.FV_CGAC_CRT_TAS dependencies on FV_BUDGET_DISTRIBUTION_DTL

Line 95: SELECT * FROM fv_budget_distribution_dtl

91: AND set_of_books_id = p_ledger_id
92: AND fund_value = p_fund_value;
93:
94: CURSOR c_budget_distribution_dtl(p_distribution_hdr_id NUMBER, p_fund_value VARCHAR2) IS
95: SELECT * FROM fv_budget_distribution_dtl
96: WHERE distribution_id = p_distribution_hdr_id
97: AND fund_value = p_fund_value
98: AND set_of_books_id = p_ledger_id;
99:

Line 112: bud_distr_dtl_record FV_BUDGET_DISTRIBUTION_DTL%ROWTYPE;

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;
116: l_min_period GL_PERIODS.PERIOD_NUM%TYPE;

Line 124: l_bud_distribution_dtl_id FV_BUDGET_DISTRIBUTION_DTL.distribution_dtl_id%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:
128: v_bal_seg_name VARCHAR2(20);

Line 947: select default_segment into v_default_segment from fv_budget_distribution_dtl

943: ROLLBACK;
944: RETURN;
945: END;
946:
947: select default_segment into v_default_segment from fv_budget_distribution_dtl
948: where distribution_dtl_id = l_bud_distribution_dtl_id;
949:
950: bal_seg_suffix := substr(v_bal_seg_name,8);
951: bfy_seg_suffix := substr(v_bfy_Segment,8);

Line 996: INSERT INTO fv_budget_distribution_dtl values budget_distribution_dtl_record;

992: cgac_crttas_record.default_segment := v_default_segment;
993: END IF;
994:
995: IF p_run_mode = 'F' then
996: INSERT INTO fv_budget_distribution_dtl values budget_distribution_dtl_record;
997:
998: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
999: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Inserted new budget header');
1000: END IF;

Line 1002: l_update_query := 'UPDATE fv_budget_distribution_dtl SET '||

998: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
999: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Inserted new budget header');
1000: END IF;
1001:
1002: l_update_query := 'UPDATE fv_budget_distribution_dtl SET '||
1003: v_bal_seg_name||'='''||fund_values_record.fund_value||''' , '|| v_bfy_Segment||' ='||
1004: v_fyr_segment_name||' WHERE distribution_dtl_id = '||budget_distribution_dtl_record.distribution_dtl_id;
1005:
1006: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1055: UPDATE fv_budget_distribution_dtl set default_segment = v_default_segment

1051: ROLLBACK;
1052: RETURN;
1053: END ;
1054:
1055: UPDATE fv_budget_distribution_dtl set default_segment = v_default_segment
1056: WHERE distribution_dtl_id = budget_distribution_dtl_record.distribution_dtl_id;
1057:
1058: SELECT default_segment INTO cgac_crttas_record.default_segment
1059: FROM fv_budget_distribution_dtl

Line 1059: FROM fv_budget_distribution_dtl

1055: UPDATE fv_budget_distribution_dtl set default_segment = v_default_segment
1056: WHERE distribution_dtl_id = budget_distribution_dtl_record.distribution_dtl_id;
1057:
1058: SELECT default_segment INTO cgac_crttas_record.default_segment
1059: FROM fv_budget_distribution_dtl
1060: WHERE distribution_dtl_id = budget_distribution_dtl_record.distribution_dtl_id;
1061: END IF;
1062:
1063: END LOOP;