APPS.XTR_COF_P dependencies on XTR_INTERGROUP_TRANSFERS

Line 8: table triggers on tables(xtr_Deals,xtr_Rollover_Transactions, xtr_Intergroup_Transfers

4: /*
5: XTR_POSITION_HISTORY holds a daily record of balances and rates for all instuments
6: that were current at that time. Essentially it is a snapshot of xtr_mirror_dda_limit_row.
7: It is maintained automatically through calling package xtr_maintain_history from the relevant
8: table triggers on tables(xtr_Deals,xtr_Rollover_Transactions, xtr_Intergroup_Transfers
9: and xtr_Bank_Balances)
10:
11: All backdating of deals (both updates and new records) are handled and records
12: in xtr_position_history are table trigger on xtr_position_history calls package

Line 28: G_IG_CURR_DEAL_NUMBER XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE;

24: to receive the maturity date. SET/GET_CURR_DEAL_ADDITIONAL_DETAILS are helper functions to set these values.
25: You can only hold one deal at a time per deal type, and once the deal information is used it is cleared.
26: */
27:
28: G_IG_CURR_DEAL_NUMBER XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE;
29: G_IG_CURR_TRANSACTION_NUMBER XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE;
30: G_IG_CURR_MATURITY_DATE DATE;
31:
32: PROCEDURE SET_CURR_IG_DEAL_DETAILS(

Line 29: G_IG_CURR_TRANSACTION_NUMBER XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE;

25: You can only hold one deal at a time per deal type, and once the deal information is used it is cleared.
26: */
27:
28: G_IG_CURR_DEAL_NUMBER XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE;
29: G_IG_CURR_TRANSACTION_NUMBER XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE;
30: G_IG_CURR_MATURITY_DATE DATE;
31:
32: PROCEDURE SET_CURR_IG_DEAL_DETAILS(
33: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,

Line 33: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,

29: G_IG_CURR_TRANSACTION_NUMBER XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE;
30: G_IG_CURR_MATURITY_DATE DATE;
31:
32: PROCEDURE SET_CURR_IG_DEAL_DETAILS(
33: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,
34: P_TRANSACTION_NUMBER IN XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE,
35: P_MATURITY_DATE IN DATE);
36:
37: PROCEDURE GET_CURR_IG_DEAL_DETAILS(

Line 34: P_TRANSACTION_NUMBER IN XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE,

30: G_IG_CURR_MATURITY_DATE DATE;
31:
32: PROCEDURE SET_CURR_IG_DEAL_DETAILS(
33: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,
34: P_TRANSACTION_NUMBER IN XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE,
35: P_MATURITY_DATE IN DATE);
36:
37: PROCEDURE GET_CURR_IG_DEAL_DETAILS(
38: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,

Line 38: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,

34: P_TRANSACTION_NUMBER IN XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE,
35: P_MATURITY_DATE IN DATE);
36:
37: PROCEDURE GET_CURR_IG_DEAL_DETAILS(
38: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,
39: P_TRANSACTION_NUMBER IN XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE,
40: P_MATURITY_DATE OUT NOCOPY DATE);
41:
42: PROCEDURE MAINTAIN_POSITION_HISTORY(

Line 39: P_TRANSACTION_NUMBER IN XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE,

35: P_MATURITY_DATE IN DATE);
36:
37: PROCEDURE GET_CURR_IG_DEAL_DETAILS(
38: P_DEAL_NUMBER IN XTR_INTERGROUP_TRANSFERS.DEAL_NUMBER%TYPE,
39: P_TRANSACTION_NUMBER IN XTR_INTERGROUP_TRANSFERS.TRANSACTION_NUMBER%TYPE,
40: P_MATURITY_DATE OUT NOCOPY DATE);
41:
42: PROCEDURE MAINTAIN_POSITION_HISTORY(
43: P_START_DATE IN DATE,