APPS.FV_SLA_AR_PROCESSING_PKG dependencies on FV_AR_ACC_CATEGORY_MAP_HDR

Line 64: p_rec_attribute_type IN fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE,

60:
61: PROCEDURE get_ar_transaction_category
62: (
63: p_org_id IN NUMBER,
64: p_rec_attribute_type IN fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE,
65: p_rec_atrribute_id IN fv_ar_acc_category_map_dtl.receivable_attribute_id%TYPE,
66: p_rec_attribute_cat OUT NOCOPY fv_ar_acc_category_map_dtl.transaction_category%TYPE,
67: p_error_code OUT NOCOPY NUMBER,
68: p_error_desc OUT NOCOPY VARCHAR2

Line 98: FROM fv_ar_acc_category_map_hdr h,

94: */
95: BEGIN
96: SELECT d.transaction_category
97: INTO p_rec_attribute_cat
98: FROM fv_ar_acc_category_map_hdr h,
99: fv_ar_acc_category_map_dtl d
100: WHERE h.fv_sla_map_hdr_id = d.fv_sla_map_hdr_id
101: AND NVL(h.org_id, -1) = NVL(p_org_id, -1)
102: AND h.receivable_attribute_type = p_rec_attribute_type

Line 140: p_rec_attribute_type OUT NOCOPY fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE,

136: p_transcation_id IN NUMBER,
137: p_org_id OUT NOCOPY NUMBER,
138: p_customer_id OUT NOCOPY NUMBER,
139: p_rec_atrribute_id OUT NOCOPY NUMBER,
140: p_rec_attribute_type OUT NOCOPY fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE,
141: p_error_code OUT NOCOPY NUMBER,
142: p_error_desc OUT NOCOPY VARCHAR2
143: )
144: IS

Line 197: p_rec_attribute_type OUT NOCOPY fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE,

193: p_transcation_id IN NUMBER,
194: p_org_id OUT NOCOPY NUMBER,
195: p_customer_id OUT NOCOPY NUMBER,
196: p_rec_atrribute_id OUT NOCOPY NUMBER,
197: p_rec_attribute_type OUT NOCOPY fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE,
198: p_error_code OUT NOCOPY NUMBER,
199: p_error_desc OUT NOCOPY VARCHAR2
200: )
201: IS

Line 273: p_rec_attribute_type OUT NOCOPY fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE,

269: p_transcation_id IN NUMBER,
270: p_org_id OUT NOCOPY NUMBER,
271: p_customer_id OUT NOCOPY NUMBER,
272: p_rec_atrribute_id OUT NOCOPY NUMBER,
273: p_rec_attribute_type OUT NOCOPY fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE,
274: p_error_code OUT NOCOPY NUMBER,
275: p_error_desc OUT NOCOPY VARCHAR2
276: )
277: IS

Line 354: p_rec_attribute_type OUT NOCOPY fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE,

350: p_event_id IN NUMBER,
351: p_org_id OUT NOCOPY NUMBER,
352: p_customer_id OUT NOCOPY NUMBER,
353: p_rec_atrribute_id OUT NOCOPY NUMBER,
354: p_rec_attribute_type OUT NOCOPY fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE,
355: p_error_code OUT NOCOPY NUMBER,
356: p_error_desc OUT NOCOPY VARCHAR2
357: )
358: IS

Line 461: l_rec_attribute_type fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE;

457: IS
458: l_procedure_name VARCHAR2(100) :='.get_receipt_info_for_pr';
459: l_org_id NUMBER;
460: l_rec_atrribute_id NUMBER;
461: l_rec_attribute_type fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE;
462: l_cash_receipt_id ar_receivable_applications_all.cash_receipt_id%TYPE;
463: l_payment_set_id ar_receivable_applications_all.payment_set_id%TYPE;
464: l_stmt VARCHAR2(2000);
465: BEGIN

Line 577: l_rec_attribute_type fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE;

573: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;
574: l_direct_or_reimb VARCHAR2(1);
575: l_fund_type fv_treasury_symbols.fund_type%TYPE;
576: l_rec_atrribute_id NUMBER;
577: l_rec_attribute_type fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE;
578: l_org_id NUMBER;
579: l_customer_id NUMBER;
580: l_fed_non_fed_ind VARCHAR2(1);
581: