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.XTR_IG_TRANSFERS_PKG dependencies on XTR_DEALS_INTERFACE

Line 910: procedure COPY_FROM_INTERFACE_TO_IG(ARec_Interface IN XTR_DEALS_INTERFACE%rowtype ) is

906:
907:
908: -----------------------------------------------------------------------------------------------------
909: --* procedure to copy the values from interface record to Ig Record
910: procedure COPY_FROM_INTERFACE_TO_IG(ARec_Interface IN XTR_DEALS_INTERFACE%rowtype ) is
911: -----------------------------------------------------------------------------------------------------
912: begin
913:
914: G_Ig_Main_Rec.ACCUM_INTEREST_BF := 0 ;

Line 1307: procedure CALCULATE_VALUES (ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,

1303: -----------------------------------------------------------------------------------------------------
1304: -- Local procedure to calculate interest amount, num of days for each
1305: -- transfer. Also determine that this is the latest date for a transfer
1306: -- to or from this account.
1307: procedure CALCULATE_VALUES (ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,
1308: p_err_limit OUT NOCOPY VARCHAR2) is
1309: -----------------------------------------------------------------------------------------------------
1310: begin
1311:

Line 1345: procedure CHECK_MANDATORY_FIELDS(ARec_Interface IN XTR_DEALS_INTERFACE%rowtype, p_error OUT NOCOPY BOOLEAN) is

1341: end;
1342:
1343:
1344: -----------------------------------------------------------------------------------------------------
1345: procedure CHECK_MANDATORY_FIELDS(ARec_Interface IN XTR_DEALS_INTERFACE%rowtype, p_error OUT NOCOPY BOOLEAN) is
1346: -----------------------------------------------------------------------------------------------------
1347: begin
1348:
1349: p_error := FALSE;

Line 1502: procedure VALIDATE_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%rowtype, p_error OUT NOCOPY BOOLEAN) is

1498: end; /* CHECK_MANDATORY_FIELDS */
1499:
1500:
1501: -----------------------------------------------------------------------------------------------------
1502: procedure VALIDATE_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%rowtype, p_error OUT NOCOPY BOOLEAN) is
1503: -----------------------------------------------------------------------------------------------------
1504: l_err_segment VARCHAR2(30);
1505: l_err_cparty BOOLEAN := FALSE;
1506: l_err_currency BOOLEAN := FALSE;

Line 2698: procedure TRANSFER_IG_DEALS( ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,

2694:
2695: -----------------------------------------------------------------------------------------------------
2696: --* Main procedure for Import Deal Record that calls all the validation APIs
2697: --* stub for backwards compatibility
2698: procedure TRANSFER_IG_DEALS( ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,
2699: p_source IN VARCHAR2,
2700: user_error OUT NOCOPY BOOLEAN,
2701: mandatory_error OUT NOCOPY BOOLEAN,
2702: validation_error OUT NOCOPY BOOLEAN,

Line 2723: procedure TRANSFER_IG_DEALS( ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,

2719:
2720: --*****************************************************************************************************************
2721: -- 3800146 backwards compatibility ******************************************************************************
2722: --*****************************************************************************************************************
2723: procedure TRANSFER_IG_DEALS( ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,
2724: p_source IN VARCHAR2,
2725: user_error OUT NOCOPY BOOLEAN,
2726: mandatory_error OUT NOCOPY BOOLEAN,
2727: validation_error OUT NOCOPY BOOLEAN,

Line 2744: procedure TRANSFER_IG_DEALS( ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,

2740:
2741: -----------------------------------------------------------------------------------------------------
2742: --* Main procedure for Import Deal Record that calls all the validation APIs
2743: --* and then finally calls the Insert Table Handler.
2744: procedure TRANSFER_IG_DEALS( ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,
2745: p_source IN VARCHAR2,
2746: user_error OUT NOCOPY BOOLEAN,
2747: mandatory_error OUT NOCOPY BOOLEAN,
2748: validation_error OUT NOCOPY BOOLEAN,

Line 2782: temp_Interface_rate_a XTR_DEALS_INTERFACE.RATE_A%TYPE;

2778: from xtr_parties_v
2779: where party_type = 'C'
2780: and party_code = l_comp;
2781: /*
2782: temp_Interface_rate_a XTR_DEALS_INTERFACE.RATE_A%TYPE;
2783: temp_Interface_Rounding_Type XTR_DEALS_INTERFACE.ROUNDING_TYPE%TYPE;
2784: temp_Interface_Day_Count_Type XTR_DEALS_INTERFACE.DAY_COUNT_TYPE%TYPE;
2785: temp_Interface_pricing_model XTR_DEALS_INTERFACE.PRICING_MODEL%TYPE;
2786: temp_Interface_mirror_pricing XTR_DEALS_INTERFACE.PRICING_MODEL%TYPE;

Line 2783: temp_Interface_Rounding_Type XTR_DEALS_INTERFACE.ROUNDING_TYPE%TYPE;

2779: where party_type = 'C'
2780: and party_code = l_comp;
2781: /*
2782: temp_Interface_rate_a XTR_DEALS_INTERFACE.RATE_A%TYPE;
2783: temp_Interface_Rounding_Type XTR_DEALS_INTERFACE.ROUNDING_TYPE%TYPE;
2784: temp_Interface_Day_Count_Type XTR_DEALS_INTERFACE.DAY_COUNT_TYPE%TYPE;
2785: temp_Interface_pricing_model XTR_DEALS_INTERFACE.PRICING_MODEL%TYPE;
2786: temp_Interface_mirror_pricing XTR_DEALS_INTERFACE.PRICING_MODEL%TYPE;
2787: */

Line 2784: temp_Interface_Day_Count_Type XTR_DEALS_INTERFACE.DAY_COUNT_TYPE%TYPE;

2780: and party_code = l_comp;
2781: /*
2782: temp_Interface_rate_a XTR_DEALS_INTERFACE.RATE_A%TYPE;
2783: temp_Interface_Rounding_Type XTR_DEALS_INTERFACE.ROUNDING_TYPE%TYPE;
2784: temp_Interface_Day_Count_Type XTR_DEALS_INTERFACE.DAY_COUNT_TYPE%TYPE;
2785: temp_Interface_pricing_model XTR_DEALS_INTERFACE.PRICING_MODEL%TYPE;
2786: temp_Interface_mirror_pricing XTR_DEALS_INTERFACE.PRICING_MODEL%TYPE;
2787: */
2788:

Line 2785: temp_Interface_pricing_model XTR_DEALS_INTERFACE.PRICING_MODEL%TYPE;

2781: /*
2782: temp_Interface_rate_a XTR_DEALS_INTERFACE.RATE_A%TYPE;
2783: temp_Interface_Rounding_Type XTR_DEALS_INTERFACE.ROUNDING_TYPE%TYPE;
2784: temp_Interface_Day_Count_Type XTR_DEALS_INTERFACE.DAY_COUNT_TYPE%TYPE;
2785: temp_Interface_pricing_model XTR_DEALS_INTERFACE.PRICING_MODEL%TYPE;
2786: temp_Interface_mirror_pricing XTR_DEALS_INTERFACE.PRICING_MODEL%TYPE;
2787: */
2788:
2789: begin

Line 2786: temp_Interface_mirror_pricing XTR_DEALS_INTERFACE.PRICING_MODEL%TYPE;

2782: temp_Interface_rate_a XTR_DEALS_INTERFACE.RATE_A%TYPE;
2783: temp_Interface_Rounding_Type XTR_DEALS_INTERFACE.ROUNDING_TYPE%TYPE;
2784: temp_Interface_Day_Count_Type XTR_DEALS_INTERFACE.DAY_COUNT_TYPE%TYPE;
2785: temp_Interface_pricing_model XTR_DEALS_INTERFACE.PRICING_MODEL%TYPE;
2786: temp_Interface_mirror_pricing XTR_DEALS_INTERFACE.PRICING_MODEL%TYPE;
2787: */
2788:
2789: begin
2790:

Line 3326: delete from xtr_deals_interface

3322: --******************************************************************************************************
3323: -- 3800146 Not necessary for ZBA/CL *****************************************************************
3324: --******************************************************************************************************
3325: if G_Ig_Source is null and nvl(G_Ig_External_Source,'@@@') not in (C_ZBA,C_CL) then
3326: delete from xtr_deals_interface
3327: where external_deal_id = ARec_Interface.external_deal_id
3328: and deal_type = ARec_Interface.deal_type;
3329: end if;
3330:

Line 3336: update xtr_deals_interface

3332: --******************************************************************************************************
3333: -- 3800146 Not necessary for ZBA/CL *****************************************************************
3334: --******************************************************************************************************
3335: if G_Ig_Source is null and nvl(G_Ig_External_Source,'@@@') not in (C_ZBA,C_CL) then
3336: update xtr_deals_interface
3337: set load_status_code = 'DUPLICATE_DEAL_ID',
3338: last_update_date = G_Ig_SysDate,
3339: last_Updated_by = G_Ig_user_id
3340: where external_deal_id = ARec_Interface.external_deal_id

Line 3357: update xtr_deals_interface

3353: --******************************************************************************************************
3354: -- 3800146 Not necessary for ZBA/CL *****************************************************************
3355: --******************************************************************************************************
3356: if G_Ig_Source is null and nvl(G_Ig_External_Source,'@@@') not in (C_ZBA,C_CL) then
3357: update xtr_deals_interface
3358: set load_status_code = 'ERROR',
3359: last_update_date = G_Ig_SysDate,
3360: last_Updated_by = G_Ig_user_id
3361: where external_deal_id = ARec_Interface.external_deal_id