eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_REC_CALC_PKG dependencies on PN_REC_PERIOD_BILL_ALL

Line 3751: | Create records in the PN_REC_PERIOD_BILL_ALL table

Line 3763: | NOTES : Create records in the PN_REC_PERIOD_BILL_ALL

3759: | OUT:
3760: |
3761: | RETURNS : None
3762: |
3763: | NOTES : Create records in the PN_REC_PERIOD_BILL_ALL
3764: |
3765: | MODIFICATION HISTORY
3766: |
3767: | 21-MAY-2003 Daniel Thota o Created

Line 3783: SELECT ROWID FROM PN_REC_PERIOD_BILL_ALL

3779: ,X_LAST_UPDATED_BY IN NUMBER
3780: ,X_LAST_UPDATE_LOGIN IN NUMBER
3781: ) is
3782: CURSOR C is
3783: SELECT ROWID FROM PN_REC_PERIOD_BILL_ALL
3784: WHERE PERIOD_BILLREC_ID = X_PERIOD_BILLREC_ID;
3785:
3786: CURSOR org_cur IS
3787: SELECT org_id

Line 3814: INSERT INTO PN_REC_PERIOD_BILL_ALL (

3810: IF l_org_ID IS NULL THEN
3811: l_org_ID := pn_mo_cache_utils.get_current_org_id;
3812: END IF;
3813:
3814: INSERT INTO PN_REC_PERIOD_BILL_ALL (
3815: PERIOD_BILLREC_ID
3816: ,REC_AGREEMENT_ID
3817: ,REC_AGR_LINE_ID
3818: ,REC_CALC_PERIOD_ID

Line 3858: | Update records in the PN_REC_PERIOD_BILL_ALL table

Line 3870: | NOTES : Update records in the PN_REC_PERIOD_BILL_ALL

3866: | OUT:
3867: |
3868: | RETURNS : None
3869: |
3870: | NOTES : Update records in the PN_REC_PERIOD_BILL_ALL
3871: |
3872: | MODIFICATION HISTORY
3873: |
3874: | 21-MAY-2003 Daniel Thota o Created

Line 3891: update PN_REC_PERIOD_BILL_ALL set

3887: BEGIN
3888:
3889: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_BILLREC_ROW (+)');
3890:
3891: update PN_REC_PERIOD_BILL_ALL set
3892: REC_AGR_LINE_ID = X_REC_AGR_LINE_ID
3893: ,REC_AGREEMENT_ID = X_REC_AGREEMENT_ID
3894: ,REC_CALC_PERIOD_ID = X_REC_CALC_PERIOD_ID
3895: ,AMOUNT = X_AMOUNT

Line 3916: | Delete records in the PN_REC_PERIOD_BILL_ALL table

Line 3928: | NOTES : Delete records in the PN_REC_PERIOD_BILL_ALL

3924: | OUT:
3925: |
3926: | RETURNS : None
3927: |
3928: | NOTES : Delete records in the PN_REC_PERIOD_BILL_ALL
3929: |
3930: | MODIFICATION HISTORY
3931: |
3932: | 21-MAY-2003 Daniel Thota o Created

Line 3942: delete from PN_REC_PERIOD_BILL_ALL

3938: BEGIN
3939:
3940: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_BILLREC_ROW (+)');
3941:
3942: delete from PN_REC_PERIOD_BILL_ALL
3943: where PERIOD_BILLREC_ID = X_PERIOD_BILLREC_ID;
3944:
3945: if (sql%notfound) then
3946: raise no_data_found;

Line 4026: l_period_billrec_id PN_REC_PERIOD_BILL_all.period_billrec_id%TYPE:= NULL;

4022: l_frequency pn_payment_terms.frequency_code%type;
4023: l_schedule_day pn_payment_terms.schedule_day%type;
4024: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
4025: l_context varchar2(2000);
4026: l_period_billrec_id PN_REC_PERIOD_BILL_all.period_billrec_id%TYPE:= NULL;
4027: l_payment_amount pn_payment_terms.actual_amount%type;
4028: l_period_bill_record period_bill_record;
4029: l_is_r12 BOOLEAN := pn_r12_util_pkg.is_r12;
4030: l_dummy VARCHAR2(30);

Line 4586: p_rec_agreement_id PN_REC_PERIOD_BILL_all.period_billrec_id%TYPE

4582: | and cursors get_distributions_exist_cons
4583: | Fix for bug # 3142328
4584: +===========================================================================*/
4585: FUNCTION find_if_rec_payterm_exists(
4586: p_rec_agreement_id PN_REC_PERIOD_BILL_all.period_billrec_id%TYPE
4587: ,p_rec_agr_line_id PN_REC_PERIOD_BILL_all.rec_agr_line_id%TYPE
4588: ,p_rec_calc_period_id PN_REC_PERIOD_BILL_all.rec_calc_period_id%TYPE
4589: ,p_consolidate VARCHAR2
4590: )

Line 4587: ,p_rec_agr_line_id PN_REC_PERIOD_BILL_all.rec_agr_line_id%TYPE

4583: | Fix for bug # 3142328
4584: +===========================================================================*/
4585: FUNCTION find_if_rec_payterm_exists(
4586: p_rec_agreement_id PN_REC_PERIOD_BILL_all.period_billrec_id%TYPE
4587: ,p_rec_agr_line_id PN_REC_PERIOD_BILL_all.rec_agr_line_id%TYPE
4588: ,p_rec_calc_period_id PN_REC_PERIOD_BILL_all.rec_calc_period_id%TYPE
4589: ,p_consolidate VARCHAR2
4590: )
4591: RETURN period_bill_record IS

Line 4588: ,p_rec_calc_period_id PN_REC_PERIOD_BILL_all.rec_calc_period_id%TYPE

4584: +===========================================================================*/
4585: FUNCTION find_if_rec_payterm_exists(
4586: p_rec_agreement_id PN_REC_PERIOD_BILL_all.period_billrec_id%TYPE
4587: ,p_rec_agr_line_id PN_REC_PERIOD_BILL_all.rec_agr_line_id%TYPE
4588: ,p_rec_calc_period_id PN_REC_PERIOD_BILL_all.rec_calc_period_id%TYPE
4589: ,p_consolidate VARCHAR2
4590: )
4591: RETURN period_bill_record IS
4592:

Line 4640: FROM PN_REC_PERIOD_BILL_all

4636:
4637: IF (p_consolidate = 'N') THEN
4638: SELECT period_billrec_id
4639: INTO l_period_bill_record.period_billrec_id
4640: FROM PN_REC_PERIOD_BILL_all
4641: WHERE rec_agreement_id = p_rec_agreement_id
4642: AND rec_agr_line_id = p_rec_agr_line_id
4643: AND rec_calc_period_id = p_rec_calc_period_id;
4644: ELSIF (p_consolidate = 'Y') THEN

Line 4647: FROM PN_REC_PERIOD_BILL_all

4643: AND rec_calc_period_id = p_rec_calc_period_id;
4644: ELSIF (p_consolidate = 'Y') THEN
4645: SELECT period_billrec_id
4646: INTO l_period_bill_record.period_billrec_id
4647: FROM PN_REC_PERIOD_BILL_all
4648: WHERE rec_agreement_id = p_rec_agreement_id
4649: AND rec_calc_period_id = p_rec_calc_period_id;
4650: END IF;
4651:

Line 5055: ,pn_rec_period_bill_all bill

5051: period.end_date as end_date ,
5052: period.as_of_date as as_of_date ,
5053: agrlines.rec_agr_line_id as rec_agr_line_id
5054: from pn_payment_terms_all term
5055: ,pn_rec_period_bill_all bill
5056: ,pn_rec_calc_periods_all period
5057: ,pn_rec_agr_lines_all agrlines
5058: ,pn_rec_agreements_all agr
5059: where term.payment_term_id = p_payment_term_id

Line 5077: ,pn_rec_period_bill_all bill

5073: period.end_date as end_date ,
5074: period.as_of_date as as_of_date ,
5075: agrlines.rec_agr_line_id as rec_agr_line_id
5076: from pn_payment_terms_all term
5077: ,pn_rec_period_bill_all bill
5078: ,pn_rec_calc_periods_all period
5079: ,pn_rec_agr_lines_all agrlines
5080: ,pn_rec_agreements_all agr
5081: where term.payment_term_id = p_payment_term_id