APPS.XTR_WRAPPER_API_P dependencies on XTR_SETTLEMENT_SUMMARY

Line 78: From Xtr_Settlement_Summary

74: Select *
75: From Xtr_Deal_Date_Amounts
76: Where settlement_number in
77: (Select settlement_number
78: From Xtr_Settlement_Summary
79: Where net_ID = p_settlement_summary_ID)
80: For update of reconciled_reference;
81: Begin
82: /* After CE is done with Reconciliation this procedure updates the necessary records in XTR tables to denote the completion

Line 85: /* This is to update Xtr_Settlement_Summary about the successful completion of Reconciliation */

81: Begin
82: /* After CE is done with Reconciliation this procedure updates the necessary records in XTR tables to denote the completion
83: of Reconciliation */
84: If p_task = 'REC' then
85: /* This is to update Xtr_Settlement_Summary about the successful completion of Reconciliation */
86: Update xtr_settlement_summary
87: set status = 'R'
88: Where settlement_summary_id = p_settlement_summary_ID;
89:

Line 86: Update xtr_settlement_summary

82: /* After CE is done with Reconciliation this procedure updates the necessary records in XTR tables to denote the completion
83: of Reconciliation */
84: If p_task = 'REC' then
85: /* This is to update Xtr_Settlement_Summary about the successful completion of Reconciliation */
86: Update xtr_settlement_summary
87: set status = 'R'
88: Where settlement_summary_id = p_settlement_summary_ID;
89:
90: If SQL%Found then

Line 98: From Xtr_Settlement_Summary

94: End if;
95:
96: Select settlement_number
97: Into v_settlement_number
98: From Xtr_Settlement_Summary
99: Where settlement_summary_id = p_settlement_summary_ID;
100:
101: Select Xtr_Deal_Date_Amounts_S.Nextval
102: Into v_reconciled_reference

Line 121: /* After successful Un-Reconciliation, Xtr_Settlement_Summary is updated for availability of record for future reconciliation */

117: Where current of C1;
118: End Loop;
119: End if;
120: Else
121: /* After successful Un-Reconciliation, Xtr_Settlement_Summary is updated for availability of record for future reconciliation */
122: Update xtr_settlement_summary
123: set status = 'A'
124: Where settlement_summary_id = p_settlement_summary_ID;
125: If SQL%Found then

Line 122: Update xtr_settlement_summary

118: End Loop;
119: End if;
120: Else
121: /* After successful Un-Reconciliation, Xtr_Settlement_Summary is updated for availability of record for future reconciliation */
122: Update xtr_settlement_summary
123: set status = 'A'
124: Where settlement_summary_id = p_settlement_summary_ID;
125: If SQL%Found then
126: P_Result := 'XTR2_SUCCESS';

Line 133: From Xtr_Settlement_Summary

129: End if;
130:
131: Select settlement_number
132: Into v_settlement_number
133: From Xtr_Settlement_Summary
134: Where settlement_summary_id = p_settlement_summary_ID;
135:
136: Update Xtr_Deal_Date_Amounts
137: Set Reconciled_Reference = null,