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 3836: | Create records in the PN_REC_PERIOD_BILL_ALL table

Line 3848: | NOTES : Create records in the PN_REC_PERIOD_BILL_ALL

3844: | OUT:
3845: |
3846: | RETURNS : None
3847: |
3848: | NOTES : Create records in the PN_REC_PERIOD_BILL_ALL
3849: |
3850: | MODIFICATION HISTORY
3851: |
3852: | 21-MAY-2003 Daniel Thota o Created

Line 3868: SELECT ROWID FROM PN_REC_PERIOD_BILL_ALL

3864: ,X_LAST_UPDATED_BY IN NUMBER
3865: ,X_LAST_UPDATE_LOGIN IN NUMBER
3866: ) is
3867: CURSOR C is
3868: SELECT ROWID FROM PN_REC_PERIOD_BILL_ALL
3869: WHERE PERIOD_BILLREC_ID = X_PERIOD_BILLREC_ID;
3870:
3871: CURSOR org_cur IS
3872: SELECT org_id

Line 3899: INSERT INTO PN_REC_PERIOD_BILL_ALL (

3895: IF l_org_ID IS NULL THEN
3896: l_org_ID := pn_mo_cache_utils.get_current_org_id;
3897: END IF;
3898:
3899: INSERT INTO PN_REC_PERIOD_BILL_ALL (
3900: PERIOD_BILLREC_ID
3901: ,REC_AGREEMENT_ID
3902: ,REC_AGR_LINE_ID
3903: ,REC_CALC_PERIOD_ID

Line 3943: | Update records in the PN_REC_PERIOD_BILL_ALL table

Line 3955: | NOTES : Update records in the PN_REC_PERIOD_BILL_ALL

3951: | OUT:
3952: |
3953: | RETURNS : None
3954: |
3955: | NOTES : Update records in the PN_REC_PERIOD_BILL_ALL
3956: |
3957: | MODIFICATION HISTORY
3958: |
3959: | 21-MAY-2003 Daniel Thota o Created

Line 3976: update PN_REC_PERIOD_BILL_ALL set

3972: BEGIN
3973:
3974: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_BILLREC_ROW (+)');
3975:
3976: update PN_REC_PERIOD_BILL_ALL set
3977: REC_AGR_LINE_ID = X_REC_AGR_LINE_ID
3978: ,REC_AGREEMENT_ID = X_REC_AGREEMENT_ID
3979: ,REC_CALC_PERIOD_ID = X_REC_CALC_PERIOD_ID
3980: ,AMOUNT = X_AMOUNT

Line 4001: | Delete records in the PN_REC_PERIOD_BILL_ALL table

Line 4013: | NOTES : Delete records in the PN_REC_PERIOD_BILL_ALL

4009: | OUT:
4010: |
4011: | RETURNS : None
4012: |
4013: | NOTES : Delete records in the PN_REC_PERIOD_BILL_ALL
4014: |
4015: | MODIFICATION HISTORY
4016: |
4017: | 21-MAY-2003 Daniel Thota o Created

Line 4027: delete from PN_REC_PERIOD_BILL_ALL

4023: BEGIN
4024:
4025: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_BILLREC_ROW (+)');
4026:
4027: delete from PN_REC_PERIOD_BILL_ALL
4028: where PERIOD_BILLREC_ID = X_PERIOD_BILLREC_ID;
4029:
4030: if (sql%notfound) then
4031: raise no_data_found;

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

4107: l_frequency pn_payment_terms.frequency_code%type;
4108: l_schedule_day pn_payment_terms.schedule_day%type;
4109: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
4110: l_context varchar2(2000);
4111: l_period_billrec_id PN_REC_PERIOD_BILL_all.period_billrec_id%TYPE:= NULL;
4112: l_payment_amount pn_payment_terms.actual_amount%type;
4113: l_period_bill_record period_bill_record;
4114: l_is_r12 BOOLEAN := pn_r12_util_pkg.is_r12;
4115: l_dummy VARCHAR2(30);

Line 4671: p_rec_agreement_id PN_REC_PERIOD_BILL_all.period_billrec_id%TYPE

4667: | and cursors get_distributions_exist_cons
4668: | Fix for bug # 3142328
4669: +===========================================================================*/
4670: FUNCTION find_if_rec_payterm_exists(
4671: p_rec_agreement_id PN_REC_PERIOD_BILL_all.period_billrec_id%TYPE
4672: ,p_rec_agr_line_id PN_REC_PERIOD_BILL_all.rec_agr_line_id%TYPE
4673: ,p_rec_calc_period_id PN_REC_PERIOD_BILL_all.rec_calc_period_id%TYPE
4674: ,p_consolidate VARCHAR2
4675: )

Line 4672: ,p_rec_agr_line_id PN_REC_PERIOD_BILL_all.rec_agr_line_id%TYPE

4668: | Fix for bug # 3142328
4669: +===========================================================================*/
4670: FUNCTION find_if_rec_payterm_exists(
4671: p_rec_agreement_id PN_REC_PERIOD_BILL_all.period_billrec_id%TYPE
4672: ,p_rec_agr_line_id PN_REC_PERIOD_BILL_all.rec_agr_line_id%TYPE
4673: ,p_rec_calc_period_id PN_REC_PERIOD_BILL_all.rec_calc_period_id%TYPE
4674: ,p_consolidate VARCHAR2
4675: )
4676: RETURN period_bill_record IS

Line 4673: ,p_rec_calc_period_id PN_REC_PERIOD_BILL_all.rec_calc_period_id%TYPE

4669: +===========================================================================*/
4670: FUNCTION find_if_rec_payterm_exists(
4671: p_rec_agreement_id PN_REC_PERIOD_BILL_all.period_billrec_id%TYPE
4672: ,p_rec_agr_line_id PN_REC_PERIOD_BILL_all.rec_agr_line_id%TYPE
4673: ,p_rec_calc_period_id PN_REC_PERIOD_BILL_all.rec_calc_period_id%TYPE
4674: ,p_consolidate VARCHAR2
4675: )
4676: RETURN period_bill_record IS
4677:

Line 4725: FROM PN_REC_PERIOD_BILL_all

4721:
4722: IF (p_consolidate = 'N') THEN
4723: SELECT period_billrec_id
4724: INTO l_period_bill_record.period_billrec_id
4725: FROM PN_REC_PERIOD_BILL_all
4726: WHERE rec_agreement_id = p_rec_agreement_id
4727: AND rec_agr_line_id = p_rec_agr_line_id
4728: AND rec_calc_period_id = p_rec_calc_period_id;
4729: ELSIF (p_consolidate = 'Y') THEN

Line 4732: FROM PN_REC_PERIOD_BILL_all

4728: AND rec_calc_period_id = p_rec_calc_period_id;
4729: ELSIF (p_consolidate = 'Y') THEN
4730: SELECT period_billrec_id
4731: INTO l_period_bill_record.period_billrec_id
4732: FROM PN_REC_PERIOD_BILL_all
4733: WHERE rec_agreement_id = p_rec_agreement_id
4734: AND rec_calc_period_id = p_rec_calc_period_id;
4735: END IF;
4736:

Line 5140: ,pn_rec_period_bill_all bill

5136: period.end_date as end_date ,
5137: period.as_of_date as as_of_date ,
5138: agrlines.rec_agr_line_id as rec_agr_line_id
5139: from pn_payment_terms_all term
5140: ,pn_rec_period_bill_all bill
5141: ,pn_rec_calc_periods_all period
5142: ,pn_rec_agr_lines_all agrlines
5143: ,pn_rec_agreements_all agr
5144: where term.payment_term_id = p_payment_term_id

Line 5162: ,pn_rec_period_bill_all bill

5158: period.end_date as end_date ,
5159: period.as_of_date as as_of_date ,
5160: agrlines.rec_agr_line_id as rec_agr_line_id
5161: from pn_payment_terms_all term
5162: ,pn_rec_period_bill_all bill
5163: ,pn_rec_calc_periods_all period
5164: ,pn_rec_agr_lines_all agrlines
5165: ,pn_rec_agreements_all agr
5166: where term.payment_term_id = p_payment_term_id