APPS.IGIRCBJP dependencies on IGI_AR_CASH_BASIS_DISTS

Line 151: | The information is extracted from the igi_ar_cash_basis_dists |

147: | DESCRIPTION |
148: | Populates the TABLE types passed to the procedure with the total |
149: | amounts of a given type (LINE, TAX, FREIGHT, CHARGES, INVOICE) |
150: | that are currently applied to a given payment schedule. |
151: | The information is extracted from the igi_ar_cash_basis_dists |
152: | table, and is returned ordered by source ('GL' then 'ADJ') and |
153: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |
154: | PARAMETERS |
155: | p_ps_id Payment Schedule Id for which current |

Line 198: FROM igi_ar_cash_basis_dists cbd

194: cbd.source Source,
195: cbd.source_id SourceId,
196: NVL(SUM( DECODE(cbd.source,
197: 'UNA', cbd.amount, 0 )),0) UnallocatedAmt
198: FROM igi_ar_cash_basis_dists cbd
199: WHERE cbd.payment_schedule_id = p_ps_id
200: AND cbd.type = p_type
201: AND (cbd.posting_control_id+0 > 0
202: or

Line 535: | igi_ar_cash_basis_dists, and a record into igi_ar_journal_interim |

531: | PRIVATE PROCEDURE |
532: | CreateDistribution |
533: | DESCRIPTION |
534: | Creates a distribution by inserting a record into |
535: | igi_ar_cash_basis_dists, and a record into igi_ar_journal_interim |
536: | PARAMETERS |
537: | |
538: | EXCEPTIONS RAISED |
539: | |

Line 560: CashBasisDistributionId igi_ar_cash_basis_dists.cash_basis_distribution_id%TYPE;

556: p_SourceId IN NUMBER,
557: p_Type IN VARCHAR2,
558: p_Ccid IN NUMBER,
559: p_AccntClass IN VARCHAR2 ) IS
560: CashBasisDistributionId igi_ar_cash_basis_dists.cash_basis_distribution_id%TYPE;
561: BEGIN
562: IF p_Amount = 0 AND p_AcctdAmount = 0 THEN
563: RETURN;
564: END IF;

Line 659: FROM igi_ar_cash_basis_dists cbd

655: p_Trx.CmPsIdFlag,
656: 'Y', 'CMAPP_REC',
657: 'CMAPP_APP' )), -- reference29,
658: 'AR_CASH_BASIS_DISTRIBUTIONS' -- reference30
659: FROM igi_ar_cash_basis_dists cbd
660: WHERE cbd.posting_control_id+0 = p_App.PostingControlId
661: AND cbd.receivable_application_id = p_App.ReceivableApplicationId
662: AND cbd.payment_schedule_id = p_Trx.PaymentScheduleId
663: AND cbd.type = p_Type;

Line 671: SELECT igi_ar_cash_basis_dists_s.NEXTVAL

667: RAISE;
668: END;
669: ELSE
670: --
671: SELECT igi_ar_cash_basis_dists_s.NEXTVAL
672: INTO CashBasisDistributionId
673: FROM dual;
674: --
675: BEGIN

Line 689: INSERT INTO igi_ar_cash_basis_dists

685: WriteToLogFile ( l_state_level, 'CreateDistribution','>> >> p_Sourceid '||p_sourceid );
686: WriteToLogFile ( l_state_level, 'CreateDistribution','>> >> ReqId '||P_report.reqid );
687:
688:
689: INSERT INTO igi_ar_cash_basis_dists
690: (
691: cash_basis_distribution_id,
692: created_by,
693: creation_date,

Line 899: AppToLineThisTime NUMBER; -- the actual amount posted, and stored in igi_ar_cash_basis_dists

895: -- the final NewAppToLine is adjusted
896: -- so that the value of RunningNewAppToLine is equal to
897: -- GrandTotalApplied
898: GrandTotalApplied NUMBER;
899: AppToLineThisTime NUMBER; -- the actual amount posted, and stored in igi_ar_cash_basis_dists
900: AcctdAppToLineThisTime NUMBER;
901: RunningAppToLineThisTime NUMBER := 0;
902: RunningAcctdAppToLineThisTime NUMBER := 0;
903: BEGIN

Line 2190: FROM igi_ar_cash_basis_dists cbd

2186: IF RInt.TableName = 'AR_CASH_BASIS_DISTRIBUTIONS'
2187: THEN
2188: SELECT cbd.receivable_application_id
2189: INTO l_ReceivableApplicationId
2190: FROM igi_ar_cash_basis_dists cbd
2191: WHERE cbd.cash_basis_distribution_id = RInt.Id;
2192: ELSE
2193: l_ReceivableApplicationId := NULL;
2194: END IF;

Line 2219: -- Delete from igi_ar_cash_basis_dists for records inserted

2215: RAISE;
2216: END;
2217: --
2218: --
2219: -- Delete from igi_ar_cash_basis_dists for records inserted
2220: --
2221: /*---------------------------------------------------------------------------*
2222: | PRIVATE PROCEDURE |
2223: | DeleteFromCBD |

Line 2225: | Delete recrods from igi_ar_cash_basis_dists inserted this run |

2221: /*---------------------------------------------------------------------------*
2222: | PRIVATE PROCEDURE |
2223: | DeleteFromCBD |
2224: | DESCRIPTION |
2225: | Delete recrods from igi_ar_cash_basis_dists inserted this run |
2226: | PARAMETERS |
2227: | |
2228: | EXCEPTIONS RAISED |
2229: | |

Line 2242: DELETE FROM igi_ar_cash_basis_dists

2238: *---------------------------------------------------------------------------*/
2239: PROCEDURE DeleteFromCBD( p_Report IN ReportParametersType ) IS
2240: BEGIN
2241: --
2242: DELETE FROM igi_ar_cash_basis_dists
2243: WHERE posting_control_id = - ( p_Report.ReqId +1000 );
2244: --
2245: EXCEPTION
2246: WHEN OTHERS THEN