DBA Data[Home] [Help]

APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_DEALS

Line 4: procedure TRANSFER_NI_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,

1: PACKAGE XTR_NI_TRANSFERS_PKG AUTHID CURRENT_USER AS
2: /* $Header: xtrimnis.pls 120.2 2005/06/29 10:21:01 csutaria noship $*/
3:
4: procedure TRANSFER_NI_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
5: user_error OUT NOCOPY BOOLEAN,
6: mandatory_error OUT NOCOPY BOOLEAN,
7: validation_error OUT NOCOPY BOOLEAN,
8: limit_error OUT NOCOPY BOOLEAN);

Line 10: procedure TRANSFER_NI_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,

6: mandatory_error OUT NOCOPY BOOLEAN,
7: validation_error OUT NOCOPY BOOLEAN,
8: limit_error OUT NOCOPY BOOLEAN);
9:
10: procedure TRANSFER_NI_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
11: user_error OUT NOCOPY BOOLEAN,
12: mandatory_error OUT NOCOPY BOOLEAN,
13: validation_error OUT NOCOPY BOOLEAN,
14: limit_error OUT NOCOPY BOOLEAN,

Line 17: procedure CHECK_MANDATORY_FIELDS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,

13: validation_error OUT NOCOPY BOOLEAN,
14: limit_error OUT NOCOPY BOOLEAN,
15: deal_num OUT NOCOPY NUMBER);
16:
17: procedure CHECK_MANDATORY_FIELDS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
18: error OUT NOCOPY BOOLEAN);
19:
20: procedure VALIDATE_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
21: error OUT NOCOPY BOOLEAN);

Line 20: procedure VALIDATE_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,

16:
17: procedure CHECK_MANDATORY_FIELDS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
18: error OUT NOCOPY BOOLEAN);
19:
20: procedure VALIDATE_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
21: error OUT NOCOPY BOOLEAN);
22:
23: procedure CALC_RATES(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
24: error OUT NOCOPY boolean);

Line 23: procedure CALC_RATES(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,

19:
20: procedure VALIDATE_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
21: error OUT NOCOPY BOOLEAN);
22:
23: procedure CALC_RATES(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
24: error OUT NOCOPY boolean);
25:
26: procedure CHECK_VALIDITY(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
27: error OUT NOCOPY BOOLEAN) ;

Line 26: procedure CHECK_VALIDITY(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,

22:
23: procedure CALC_RATES(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
24: error OUT NOCOPY boolean);
25:
26: procedure CHECK_VALIDITY(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
27: error OUT NOCOPY BOOLEAN) ;
28:
29: FUNCTION val_deal_date (p_date_a IN date) return BOOLEAN;
30:

Line 114: PROCEDURE CHECK_ACCRUAL_REVAL(ARec_interface IN xtr_deals_interface%ROWTYPE);

110:
111: FUNCTION val_serial_number(p_serial_number IN VARCHAR2,
112: p_parcel_count IN NUMBER) return BOOLEAN;
113:
114: PROCEDURE CHECK_ACCRUAL_REVAL(ARec_interface IN xtr_deals_interface%ROWTYPE);
115:
116: PROCEDURE copy_from_interface_to_ni(ARec_Interface IN xtr_deals_interface%rowtype );
117:
118: PROCEDURE CALC_TOTAL_SPLITS(p_user_deal_type in VARCHAR2,p_error OUT NOCOPY boolean);

Line 116: PROCEDURE copy_from_interface_to_ni(ARec_Interface IN xtr_deals_interface%rowtype );

112: p_parcel_count IN NUMBER) return BOOLEAN;
113:
114: PROCEDURE CHECK_ACCRUAL_REVAL(ARec_interface IN xtr_deals_interface%ROWTYPE);
115:
116: PROCEDURE copy_from_interface_to_ni(ARec_Interface IN xtr_deals_interface%rowtype );
117:
118: PROCEDURE CALC_TOTAL_SPLITS(p_user_deal_type in VARCHAR2,p_error OUT NOCOPY boolean);
119:
120: PROCEDURE CALC_HCE_AMOUNTS (p_user_deal_type IN VARCHAR2, p_error OUT NOCOPY BOOLEAN);

Line 134: g_ni_main_rec xtr_deals%rowtype;

130: type g_ni_trans_flex_type is table of xtr_transactions_interface%rowtype index by binary_integer;
131:
132: type NUMBER_TABLE_TYPE is table of number index by binary_integer;
133:
134: g_ni_main_rec xtr_deals%rowtype;
135: g_ni_parcel_rec g_ni_parcel_rec_type;
136: g_user_id Number Default 0;
137: g_num_parcels Number Default 0;
138: g_curr_date Date;

Line 139: g_ni_deal_type Xtr_Deals.Deal_Type%Type Default 'NI';

135: g_ni_parcel_rec g_ni_parcel_rec_type;
136: g_user_id Number Default 0;
137: g_num_parcels Number Default 0;
138: g_curr_date Date;
139: g_ni_deal_type Xtr_Deals.Deal_Type%Type Default 'NI';
140: g_ni_deal_subtype Xtr_Deals.Deal_Subtype%Type;
141: g_no_of_days Xtr_Deals.No_Of_Days%Type;
142: g_year_basis Xtr_Deals.Year_Basis%Type;
143: g_ni_trans_flex g_ni_trans_flex_type;

Line 140: g_ni_deal_subtype Xtr_Deals.Deal_Subtype%Type;

136: g_user_id Number Default 0;
137: g_num_parcels Number Default 0;
138: g_curr_date Date;
139: g_ni_deal_type Xtr_Deals.Deal_Type%Type Default 'NI';
140: g_ni_deal_subtype Xtr_Deals.Deal_Subtype%Type;
141: g_no_of_days Xtr_Deals.No_Of_Days%Type;
142: g_year_basis Xtr_Deals.Year_Basis%Type;
143: g_ni_trans_flex g_ni_trans_flex_type;
144: g_prn_tax_settle_method xtr_tax_brokerage_setup_v.tax_settle_method%type;

Line 141: g_no_of_days Xtr_Deals.No_Of_Days%Type;

137: g_num_parcels Number Default 0;
138: g_curr_date Date;
139: g_ni_deal_type Xtr_Deals.Deal_Type%Type Default 'NI';
140: g_ni_deal_subtype Xtr_Deals.Deal_Subtype%Type;
141: g_no_of_days Xtr_Deals.No_Of_Days%Type;
142: g_year_basis Xtr_Deals.Year_Basis%Type;
143: g_ni_trans_flex g_ni_trans_flex_type;
144: g_prn_tax_settle_method xtr_tax_brokerage_setup_v.tax_settle_method%type;
145: g_prn_tax_calc_type xtr_tax_brokerage_setup_v.calc_type%type;

Line 142: g_year_basis Xtr_Deals.Year_Basis%Type;

138: g_curr_date Date;
139: g_ni_deal_type Xtr_Deals.Deal_Type%Type Default 'NI';
140: g_ni_deal_subtype Xtr_Deals.Deal_Subtype%Type;
141: g_no_of_days Xtr_Deals.No_Of_Days%Type;
142: g_year_basis Xtr_Deals.Year_Basis%Type;
143: g_ni_trans_flex g_ni_trans_flex_type;
144: g_prn_tax_settle_method xtr_tax_brokerage_setup_v.tax_settle_method%type;
145: g_prn_tax_calc_type xtr_tax_brokerage_setup_v.calc_type%type;
146: g_int_tax_settle_method xtr_tax_brokerage_setup_v.tax_settle_method%type;