APPS.FV_FACTS_TRX_REGISTER dependencies on FV_BE_TRX_DTLS

Line 85: g_transfer_dept_id fv_be_trx_dtls.dept_id%TYPE ;

81: g_balance_type_val VARCHAR2(1) ;
82: g_advance_type_val VARCHAR2(1) ;
83: g_transfer_ind VARCHAR2(1) ;
84: g_year_budget_auth VARCHAR2(6) ;
85: g_transfer_dept_id fv_be_trx_dtls.dept_id%TYPE ;
86: g_transfer_main_acct fv_be_trx_dtls.main_account%TYPE ;
87: g_availability_val VARCHAR2(6) ;
88: g_prn_num VARCHAR2(3);
89: g_prn_txt VARCHAR2(25);

Line 86: g_transfer_main_acct fv_be_trx_dtls.main_account%TYPE ;

82: g_advance_type_val VARCHAR2(1) ;
83: g_transfer_ind VARCHAR2(1) ;
84: g_year_budget_auth VARCHAR2(6) ;
85: g_transfer_dept_id fv_be_trx_dtls.dept_id%TYPE ;
86: g_transfer_main_acct fv_be_trx_dtls.main_account%TYPE ;
87: g_availability_val VARCHAR2(6) ;
88: g_prn_num VARCHAR2(3);
89: g_prn_txt VARCHAR2(25);
90:

Line 855: l_tran_type fv_be_trx_dtls.transaction_type_id%TYPE;

851: l_cbs_num VARCHAR2(3);
852:
853: l_exists VARCHAR2(1);
854: i NUMBER := 0;
855: l_tran_type fv_be_trx_dtls.transaction_type_id%TYPE;
856:
857: l_pl_code_col VARCHAR2(25);
858: l_advance_type_col VARCHAR2(25);
859: l_tr_dept_id_col VARCHAR2(25);

Line 2434: FROM fv_be_trx_dtls

2430: ELSIF l_source = 'Budgetary Transaction' THEN
2431: DECLARE
2432: CURSOR dept_cur IS
2433: SELECT dept_id||main_account
2434: FROM fv_be_trx_dtls
2435: WHERE transaction_id = to_number(l_reference_1);
2436: BEGIN
2437: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2438: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BUDGETARY TRANSACTION');

Line 2589: FROM fv_be_trx_dtls

2585: THEN
2586: BEGIN
2587: SELECT public_law_code
2588: INTO g_public_law_code_val
2589: FROM fv_be_trx_dtls
2590: WHERE transaction_id = to_number(l_reference_1)
2591: AND set_of_books_id = g_set_of_books_id ;
2592: EXCEPTION
2593: WHEN NO_DATA_FOUND THEN NULL;

Line 2623: FROM Fv_be_trx_dtls

2619: IF g_legis_Ind_flag = 'Y' THEN
2620: BEGIN
2621: SELECT transaction_type_id
2622: INTO l_tran_type
2623: FROM Fv_be_trx_dtls
2624: WHERE transaction_id = to_number(l_reference_1)
2625: AND set_of_books_id = g_set_of_books_id ;
2626:
2627: -- Get the Legislation Indicator Value from

Line 2653: FROM fv_be_trx_dtls

2649: THEN
2650: BEGIN
2651: SELECT advance_type
2652: INTO g_advance_type_val
2653: FROM fv_be_trx_dtls
2654: WHERE transaction_id = to_number(l_reference_1)
2655: AND set_of_books_id = g_set_of_books_id ;
2656: -- IF the advance_type value is null then set it to 'X'
2657: IF g_advance_type_val IS NULL THEN

Line 2697: FROM fv_be_trx_dtls

2693: SELECT dept_id,
2694: main_account
2695: INTO g_transfer_dept_id,
2696: g_transfer_main_acct
2697: FROM fv_be_trx_dtls
2698: WHERE transaction_id = to_number(l_reference_1)
2699: AND set_of_books_id = g_set_of_books_id ;
2700:
2701: -- IF the Transfer values are null then set default values

Line 3103: FROM fv_be_trx_dtls d, fv_be_trx_hdrs h

3099: AND api.invoice_id = apip.invoice_id;
3100: CURSOR Budget_Transac IS
3101: SELECT h.doc_number, d.gl_date, d.creation_date,
3102: d.created_by
3103: FROM fv_be_trx_dtls d, fv_be_trx_hdrs h
3104: WHERE d.transaction_id = to_number(p_reference1)
3105: AND h.doc_id = d.doc_id;
3106: /*
3107: CURSOR Pur_Req IS