DBA Data[Home] [Help]

APPS.FV_SLA_AR_PROCESSING_PKG dependencies on FV_AR_ACC_CATEGORY_MAP_DTL

Line 18: TYPE ARCategoryTabType IS TABLE OF fv_ar_acc_category_map_dtl.transaction_category%TYPE INDEX BY BINARY_INTEGER;

14: C_STATE_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: C_PROC_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
16:
17: --AR Attribute Category
18: TYPE ARCategoryTabType IS TABLE OF fv_ar_acc_category_map_dtl.transaction_category%TYPE INDEX BY BINARY_INTEGER;
19: g_ar_category_tab ARCategoryTabType;
20:
21: PROCEDURE trace
22: (

Line 65: p_rec_atrribute_id IN fv_ar_acc_category_map_dtl.receivable_attribute_id%TYPE,

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
69: )

Line 66: p_rec_attribute_cat OUT NOCOPY fv_ar_acc_category_map_dtl.transaction_category%TYPE,

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
69: )
70: IS

Line 99: fv_ar_acc_category_map_dtl d

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
103: AND d.receivable_attribute_id = p_rec_atrribute_id;

Line 450: p_rec_attribute_cat OUT NOCOPY fv_ar_acc_category_map_dtl.transaction_category%TYPE,

446:
447: PROCEDURE get_receipt_info_for_pr
448: (
449: p_transcation_id IN NUMBER,
450: p_rec_attribute_cat OUT NOCOPY fv_ar_acc_category_map_dtl.transaction_category%TYPE,
451: p_advance_required OUT NOCOPY VARCHAR2,
452: p_advance_amount OUT NOCOPY NUMBER,
453: p_customer_id OUT NOCOPY NUMBER,
454: p_error_code OUT NOCOPY NUMBER,

Line 570: l_rec_attribute_cat fv_ar_acc_category_map_dtl.transaction_category%TYPE;

566: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
567: l_fund_category fv_fund_parameters.fund_category%TYPE;
568: l_fund_status VARCHAR2(100);
569: l_fund_time_frame fv_treasury_symbols.time_frame%TYPE;
570: l_rec_attribute_cat fv_ar_acc_category_map_dtl.transaction_category%TYPE;
571: l_pya VARCHAR2(1);
572: l_pya_type VARCHAR2(20);
573: l_no_pya_acct_flag fv_treasury_symbols.no_pya_acct_flag%TYPE;
574: l_direct_or_reimb VARCHAR2(1);