3:
4: /*************************************/
5: /* Function for Transactions Posting */
6: /*************************************/
7: FUNCTION psa_mf_trx_transfer(p_trx_rec in PSA_MFAR_UTILS.trx_rec)
8: RETURN varchar2;
9:
10: /*************************************/
11: /* Function for Adjustments Posting */
9:
10: /*************************************/
11: /* Function for Adjustments Posting */
12: /*************************************/
13: FUNCTION psa_mf_adj_transfer(p_adj_rec in PSA_MFAR_UTILS.adj_rec)
14: RETURN varchar2;
15:
16: /*************************************/
17: /* Function for Receipts Posting */
15:
16: /*************************************/
17: /* Function for Receipts Posting */
18: /*************************************/
19: FUNCTION psa_mf_rct_transfer(p_rct_rec in PSA_MFAR_UTILS.rct_rec)
20: RETURN varchar2;
21:
22: /******************************************************/
23: /* Function to Insert TRX additionalMFAR jes into GL Interface */
21:
22: /******************************************************/
23: /* Function to Insert TRX additionalMFAR jes into GL Interface */
24: /******************************************************/
25: FUNCTION psa_mf_MFAR_trx_jes(p_trx_rec in PSA_MFAR_UTILS.trx_rec)
26: return varchar2;
27:
28: /******************************************************/
29: /* Function to Insert ADJ additionalMFAR jes into GL Interface */
27:
28: /******************************************************/
29: /* Function to Insert ADJ additionalMFAR jes into GL Interface */
30: /******************************************************/
31: FUNCTION psa_mf_MFAR_adj_jes(p_adj_rec in PSA_MFAR_UTILS.adj_rec)
32: RETURN varchar2;
33:
34: /*****************************************************/
35: /* Function to Insert RCT additionalMFAR jes into GL Interface */
33:
34: /*****************************************************/
35: /* Function to Insert RCT additionalMFAR jes into GL Interface */
36: /*****************************************************/
37: FUNCTION psa_mf_MFAR_rct_jes(p_rct_rec in PSA_MFAR_UTILS.rct_rec)
38: RETURN varchar2;
39:
40:
41:
60:
61: function get_entered_cr_crm (p_lookup_code in number, p_amount in number)
62: return number ;
63:
64: user_adj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Adjustment');
65: user_cb_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Chargebacks');
66: user_cmapp_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memo Applications');
67: user_cm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memos');
68: user_dm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Debit Memos');
61: function get_entered_cr_crm (p_lookup_code in number, p_amount in number)
62: return number ;
63:
64: user_adj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Adjustment');
65: user_cb_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Chargebacks');
66: user_cmapp_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memo Applications');
67: user_cm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memos');
68: user_dm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Debit Memos');
69: user_mcr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Misc Receipts');
62: return number ;
63:
64: user_adj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Adjustment');
65: user_cb_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Chargebacks');
66: user_cmapp_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memo Applications');
67: user_cm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memos');
68: user_dm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Debit Memos');
69: user_mcr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Misc Receipts');
70: user_radj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Rate Adjustments');
63:
64: user_adj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Adjustment');
65: user_cb_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Chargebacks');
66: user_cmapp_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memo Applications');
67: user_cm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memos');
68: user_dm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Debit Memos');
69: user_mcr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Misc Receipts');
70: user_radj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Rate Adjustments');
71: user_inv_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Sales Invoices');
64: user_adj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Adjustment');
65: user_cb_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Chargebacks');
66: user_cmapp_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memo Applications');
67: user_cm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memos');
68: user_dm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Debit Memos');
69: user_mcr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Misc Receipts');
70: user_radj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Rate Adjustments');
71: user_inv_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Sales Invoices');
72: user_rct_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Trade Receipts');
65: user_cb_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Chargebacks');
66: user_cmapp_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memo Applications');
67: user_cm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memos');
68: user_dm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Debit Memos');
69: user_mcr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Misc Receipts');
70: user_radj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Rate Adjustments');
71: user_inv_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Sales Invoices');
72: user_rct_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Trade Receipts');
73: user_ccr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Cross Currency');
66: user_cmapp_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memo Applications');
67: user_cm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memos');
68: user_dm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Debit Memos');
69: user_mcr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Misc Receipts');
70: user_radj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Rate Adjustments');
71: user_inv_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Sales Invoices');
72: user_rct_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Trade Receipts');
73: user_ccr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Cross Currency');
74: user_br_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Bills Receivable');
67: user_cm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Credit Memos');
68: user_dm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Debit Memos');
69: user_mcr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Misc Receipts');
70: user_radj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Rate Adjustments');
71: user_inv_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Sales Invoices');
72: user_rct_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Trade Receipts');
73: user_ccr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Cross Currency');
74: user_br_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Bills Receivable');
75:
68: user_dm_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Debit Memos');
69: user_mcr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Misc Receipts');
70: user_radj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Rate Adjustments');
71: user_inv_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Sales Invoices');
72: user_rct_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Trade Receipts');
73: user_ccr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Cross Currency');
74: user_br_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Bills Receivable');
75:
76:
69: user_mcr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Misc Receipts');
70: user_radj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Rate Adjustments');
71: user_inv_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Sales Invoices');
72: user_rct_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Trade Receipts');
73: user_ccr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Cross Currency');
74: user_br_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Bills Receivable');
75:
76:
77: END PSA_MF_GL_TRANSFER_PKG;
70: user_radj_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Rate Adjustments');
71: user_inv_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Sales Invoices');
72: user_rct_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Trade Receipts');
73: user_ccr_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Cross Currency');
74: user_br_cat_name varchar2(25) := PSA_MFAR_UTILS.get_user_category_name ('Bills Receivable');
75:
76:
77: END PSA_MF_GL_TRANSFER_PKG;
78: