APPS.PSA_MFAR_ADJUSTMENTS dependencies on PSA_MF_ADJ_DIST_ALL

Line 121: psa_mf_adj_dist_all C

117: C.prev_mf_adjustment_ccid prev_mf_adj_ccid,
118: C.prev_cust_trx_line_id prev_cust_trx_line_id
119: From ra_cust_trx_line_gl_dist A,
120: psa_mf_trx_dist_all B,
121: psa_mf_adj_dist_all C
122: Where C.adjustment_id = g_adjustment_id
123: And A.customer_trx_id = g_customer_trx_id
124: And A.CUST_TRX_LINE_GL_DIST_ID = B.CUST_TRX_LINE_GL_DIST_ID
125: And B.cust_trx_line_gl_dist_id = C.cust_trx_line_gl_dist_id

Line 265: DELETE FROM psa_mf_adj_dist_all

261: -- ========================= FND LOG ===========================
262: psa_utils.debug_other_string(g_state_level,l_full_path, ' Inside IF ');
263: -- ========================= FND LOG ===========================
264:
265: DELETE FROM psa_mf_adj_dist_all
266: WHERE adjustment_id = g_adjustment_id;
267:
268: -- ========================= FND LOG ===========================
269: psa_utils.debug_other_string(g_state_level,l_full_path, ' DELETE FROM psa_mf_adj_dist_all --> ' || SQL%ROWCOUNT);

Line 269: psa_utils.debug_other_string(g_state_level,l_full_path, ' DELETE FROM psa_mf_adj_dist_all --> ' || SQL%ROWCOUNT);

265: DELETE FROM psa_mf_adj_dist_all
266: WHERE adjustment_id = g_adjustment_id;
267:
268: -- ========================= FND LOG ===========================
269: psa_utils.debug_other_string(g_state_level,l_full_path, ' DELETE FROM psa_mf_adj_dist_all --> ' || SQL%ROWCOUNT);
270: -- ========================= FND LOG ===========================
271:
272: IF NOT (GENERATE_ADJ_DIST ( ERRBUF => l_errbuf, -- OUT
273: RETCODE => l_retcode, -- OUT

Line 396: p_ccid psa_mf_adj_dist_all.mf_adjustment_ccid%type;

392: AND a.adjustment_id = g_adjustment_id;
393:
394:
395: l_mf_adjustments_rec c_mf_adjustments%rowtype;
396: p_ccid psa_mf_adj_dist_all.mf_adjustment_ccid%type;
397: l_temp_adj_type ar_adjustments_all.type%type;
398: l_flexbuild_error_reason VARCHAR2(2000);
399: l_total_amount_due NUMBER;
400: l_row_id VARCHAR2(100);

Line 706: -- Insert into psa_mf_adj_dist_all

702: END IF;
703:
704:
705: --
706: -- Insert into psa_mf_adj_dist_all
707: --
708:
709: -- ========================= FND LOG ===========================
710: psa_utils.debug_other_string(g_state_level,l_full_path, ' Calling PSA_MF_ADJ_DIST_ALL_PKG.INSERT_ROW ');

Line 710: psa_utils.debug_other_string(g_state_level,l_full_path, ' Calling PSA_MF_ADJ_DIST_ALL_PKG.INSERT_ROW ');

706: -- Insert into psa_mf_adj_dist_all
707: --
708:
709: -- ========================= FND LOG ===========================
710: psa_utils.debug_other_string(g_state_level,l_full_path, ' Calling PSA_MF_ADJ_DIST_ALL_PKG.INSERT_ROW ');
711: -- ========================= FND LOG ===========================
712:
713: PSA_MF_ADJ_DIST_ALL_PKG.INSERT_ROW
714: ( X_ROWID => l_row_id,

Line 713: PSA_MF_ADJ_DIST_ALL_PKG.INSERT_ROW

709: -- ========================= FND LOG ===========================
710: psa_utils.debug_other_string(g_state_level,l_full_path, ' Calling PSA_MF_ADJ_DIST_ALL_PKG.INSERT_ROW ');
711: -- ========================= FND LOG ===========================
712:
713: PSA_MF_ADJ_DIST_ALL_PKG.INSERT_ROW
714: ( X_ROWID => l_row_id,
715: X_ADJUSTMENT_ID => g_adjustment_id,
716: X_CUST_TRX_LINE_GL_DIST_ID => ccid_info(i).cust_trx_line_gl_dist_id,
717: X_MF_ADJUSTMENT_CCID => p_ccid,

Line 726: psa_utils.debug_other_string(g_state_level,l_full_path, ' Calling PSA_MF_ADJ_DIST_ALL_PKG.INSERT_ROW --> ' || SQL%ROWCOUNT);

722: X_POSTING_CONTROL_ID => -3,
723: X_MODE => 'R' );
724:
725: -- ========================= FND LOG ===========================
726: psa_utils.debug_other_string(g_state_level,l_full_path, ' Calling PSA_MF_ADJ_DIST_ALL_PKG.INSERT_ROW --> ' || SQL%ROWCOUNT);
727: -- ========================= FND LOG ===========================
728:
729: END IF;
730: END LOOP;