APPS.FV_WF_BE_APPROVAL dependencies on FV_BE_TRX_DTLS

Line 38: gl_date Fv_Be_Trx_Dtls.gl_date%TYPE,

34:
35: e_invalid EXCEPTION;
36:
37: TYPE be_trx_record IS RECORD (
38: gl_date Fv_Be_Trx_Dtls.gl_date%TYPE,
39: trx_type Fv_Be_Transaction_Types.apprn_transaction_type%TYPE,
40: trx_code Fv_Be_Trx_Dtls.sub_type%TYPE,
41: inc_dec_flag VARCHAR2(15),
42: amount Fv_Be_Trx_Dtls.amount%TYPE,

Line 40: trx_code Fv_Be_Trx_Dtls.sub_type%TYPE,

36:
37: TYPE be_trx_record IS RECORD (
38: gl_date Fv_Be_Trx_Dtls.gl_date%TYPE,
39: trx_type Fv_Be_Transaction_Types.apprn_transaction_type%TYPE,
40: trx_code Fv_Be_Trx_Dtls.sub_type%TYPE,
41: inc_dec_flag VARCHAR2(15),
42: amount Fv_Be_Trx_Dtls.amount%TYPE,
43: fund_dist Fv_Be_Trx_Dtls.budgeting_segments%TYPE );
44:

Line 42: amount Fv_Be_Trx_Dtls.amount%TYPE,

38: gl_date Fv_Be_Trx_Dtls.gl_date%TYPE,
39: trx_type Fv_Be_Transaction_Types.apprn_transaction_type%TYPE,
40: trx_code Fv_Be_Trx_Dtls.sub_type%TYPE,
41: inc_dec_flag VARCHAR2(15),
42: amount Fv_Be_Trx_Dtls.amount%TYPE,
43: fund_dist Fv_Be_Trx_Dtls.budgeting_segments%TYPE );
44:
45:
46: -- BCPSA-BE enhancements

Line 43: fund_dist Fv_Be_Trx_Dtls.budgeting_segments%TYPE );

39: trx_type Fv_Be_Transaction_Types.apprn_transaction_type%TYPE,
40: trx_code Fv_Be_Trx_Dtls.sub_type%TYPE,
41: inc_dec_flag VARCHAR2(15),
42: amount Fv_Be_Trx_Dtls.amount%TYPE,
43: fund_dist Fv_Be_Trx_Dtls.budgeting_segments%TYPE );
44:
45:
46: -- BCPSA-BE enhancements
47:

Line 105: FROM Fv_Be_Trx_Dtls

101: AND set_of_books_id = p_sob_id;
102:
103: CURSOR get_revtotal_csr IS
104: SELECT SUM(amount)
105: FROM Fv_Be_Trx_Dtls
106: WHERE doc_id = p_doc_id
107: AND set_of_books_id = p_sob_id
108: AND revision_num = vl_revision_num;
109:

Line 406: vl_doc_status Fv_Be_Trx_Dtls.transaction_status%TYPE;

402: resultout IN OUT NOCOPY VARCHAR2 ) IS
403: l_module_name VARCHAR2(200) := g_module_name || 'VerifyStatus';
404: l_errbuf VARCHAR2(1024);
405:
406: vl_doc_status Fv_Be_Trx_Dtls.transaction_status%TYPE;
407: vl_doc_status_desc VARCHAR2(80);
408:
409: CURSOR get_transtat_cur IS
410: SELECT doc_status

Line 654: UPDATE Fv_Be_Trx_Dtls

650: WHERE doc_id = p_doc_id
651: AND set_of_books_id = p_sob_id;
652:
653: -- Update the Details table
654: UPDATE Fv_Be_Trx_Dtls
655: SET transaction_status = p_doc_status
656: WHERE doc_id = p_doc_id
657: AND set_of_books_id = p_sob_id
658: AND transaction_status = 'IP';

Line 921: FROM Fv_Be_Trx_Dtls

917: l_errbuf VARCHAR2(1024);
918:
919: CURSOR get_revnum_cur IS
920: SELECT MAX(revision_num)
921: FROM Fv_Be_Trx_Dtls
922: WHERE set_of_books_id = sob_id
923: AND doc_id = doc_id
924: AND transaction_status = 'IP';
925:

Line 926: vl_rev_num Fv_Be_Trx_Dtls.revision_num%TYPE;

922: WHERE set_of_books_id = sob_id
923: AND doc_id = doc_id
924: AND transaction_status = 'IP';
925:
926: vl_rev_num Fv_Be_Trx_Dtls.revision_num%TYPE;
927:
928: BEGIN
929:
930: -- Get the revision number for doc_id

Line 1109: FROM Fv_Be_Trx_Dtls D, Fv_Be_Transaction_Types T

1105: D.sub_type ,
1106: decode(D.increase_decrease_flag,'I','Increase','Decrease') ,
1107: D.amount ,
1108: D.budgeting_segments
1109: FROM Fv_Be_Trx_Dtls D, Fv_Be_Transaction_Types T
1110: WHERE D.set_of_books_id = vg_sob_id
1111: AND D.doc_id = vg_doc_id
1112: AND D.transaction_type_id = T.be_tt_id
1113: AND D.revision_num = (SELECT MAX(revision_num)