64: -- End of Comments
65:
66: TYPE RPS_Rec_Type IS RECORD
67: (
68: REPOSSESSION_ID NUMBER := FND_API.G_MISS_NUM
69: , DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM
70: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
71: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
72: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
65:
66: TYPE RPS_Rec_Type IS RECORD
67: (
68: REPOSSESSION_ID NUMBER := FND_API.G_MISS_NUM
69: , DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM
70: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
71: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
72: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , REMARKET_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
66: TYPE RPS_Rec_Type IS RECORD
67: (
68: REPOSSESSION_ID NUMBER := FND_API.G_MISS_NUM
69: , DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM
70: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
71: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
72: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , REMARKET_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
74: , REPOSSESSION_DATE DATE := FND_API.G_MISS_DATE
67: (
68: REPOSSESSION_ID NUMBER := FND_API.G_MISS_NUM
69: , DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM
70: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
71: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
72: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , REMARKET_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
74: , REPOSSESSION_DATE DATE := FND_API.G_MISS_DATE
75: , ASSET_ID NUMBER := FND_API.G_MISS_NUM
68: REPOSSESSION_ID NUMBER := FND_API.G_MISS_NUM
69: , DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM
70: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
71: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
72: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , REMARKET_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
74: , REPOSSESSION_DATE DATE := FND_API.G_MISS_DATE
75: , ASSET_ID NUMBER := FND_API.G_MISS_NUM
76: , ASSET_VALUE NUMBER := FND_API.G_MISS_NUM
69: , DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM
70: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
71: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
72: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , REMARKET_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
74: , REPOSSESSION_DATE DATE := FND_API.G_MISS_DATE
75: , ASSET_ID NUMBER := FND_API.G_MISS_NUM
76: , ASSET_VALUE NUMBER := FND_API.G_MISS_NUM
77: , ASSET_NUMBER NUMBER := FND_API.G_MISS_NUM
70: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
71: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
72: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , REMARKET_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
74: , REPOSSESSION_DATE DATE := FND_API.G_MISS_DATE
75: , ASSET_ID NUMBER := FND_API.G_MISS_NUM
76: , ASSET_VALUE NUMBER := FND_API.G_MISS_NUM
77: , ASSET_NUMBER NUMBER := FND_API.G_MISS_NUM
78: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
71: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
72: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , REMARKET_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
74: , REPOSSESSION_DATE DATE := FND_API.G_MISS_DATE
75: , ASSET_ID NUMBER := FND_API.G_MISS_NUM
76: , ASSET_VALUE NUMBER := FND_API.G_MISS_NUM
77: , ASSET_NUMBER NUMBER := FND_API.G_MISS_NUM
78: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
79: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
72: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
73: , REMARKET_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
74: , REPOSSESSION_DATE DATE := FND_API.G_MISS_DATE
75: , ASSET_ID NUMBER := FND_API.G_MISS_NUM
76: , ASSET_VALUE NUMBER := FND_API.G_MISS_NUM
77: , ASSET_NUMBER NUMBER := FND_API.G_MISS_NUM
78: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
79: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
80: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
73: , REMARKET_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
74: , REPOSSESSION_DATE DATE := FND_API.G_MISS_DATE
75: , ASSET_ID NUMBER := FND_API.G_MISS_NUM
76: , ASSET_VALUE NUMBER := FND_API.G_MISS_NUM
77: , ASSET_NUMBER NUMBER := FND_API.G_MISS_NUM
78: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
79: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
80: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
81: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
74: , REPOSSESSION_DATE DATE := FND_API.G_MISS_DATE
75: , ASSET_ID NUMBER := FND_API.G_MISS_NUM
76: , ASSET_VALUE NUMBER := FND_API.G_MISS_NUM
77: , ASSET_NUMBER NUMBER := FND_API.G_MISS_NUM
78: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
79: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
80: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
81: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
82: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , ASSET_ID NUMBER := FND_API.G_MISS_NUM
76: , ASSET_VALUE NUMBER := FND_API.G_MISS_NUM
77: , ASSET_NUMBER NUMBER := FND_API.G_MISS_NUM
78: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
79: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
80: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
81: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
82: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , ASSET_VALUE NUMBER := FND_API.G_MISS_NUM
77: , ASSET_NUMBER NUMBER := FND_API.G_MISS_NUM
78: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
79: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
80: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
81: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
82: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ASSET_NUMBER NUMBER := FND_API.G_MISS_NUM
78: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
79: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
80: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
81: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
82: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
79: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
80: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
81: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
82: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
80: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
81: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
82: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
81: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
82: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
82: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
91: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
99: , CREATION_DATE DATE := FND_API.G_MISS_DATE
92: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
99: , CREATION_DATE DATE := FND_API.G_MISS_DATE
100: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
93: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
99: , CREATION_DATE DATE := FND_API.G_MISS_DATE
100: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
94: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
99: , CREATION_DATE DATE := FND_API.G_MISS_DATE
100: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
95: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
99: , CREATION_DATE DATE := FND_API.G_MISS_DATE
100: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
103: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
96: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
99: , CREATION_DATE DATE := FND_API.G_MISS_DATE
100: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
103: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
97: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
99: , CREATION_DATE DATE := FND_API.G_MISS_DATE
100: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
103: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
98: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
99: , CREATION_DATE DATE := FND_API.G_MISS_DATE
100: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
103: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
99: , CREATION_DATE DATE := FND_API.G_MISS_DATE
100: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
103: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
107: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
103: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
107: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , DISPOSITION_CODE VARCHAR2(30):= FND_API.G_MISS_CHAR
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
103: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
107: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , DISPOSITION_CODE VARCHAR2(30):= FND_API.G_MISS_CHAR
109: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
102: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
103: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
107: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , DISPOSITION_CODE VARCHAR2(30):= FND_API.G_MISS_CHAR
109: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
110: , ORG_ID NUMBER := FND_API.G_MISS_NUM
103: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
107: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , DISPOSITION_CODE VARCHAR2(30):= FND_API.G_MISS_CHAR
109: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
110: , ORG_ID NUMBER := FND_API.G_MISS_NUM
111: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
104: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
107: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , DISPOSITION_CODE VARCHAR2(30):= FND_API.G_MISS_CHAR
109: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
110: , ORG_ID NUMBER := FND_API.G_MISS_NUM
111: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
112: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
105: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
107: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , DISPOSITION_CODE VARCHAR2(30):= FND_API.G_MISS_CHAR
109: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
110: , ORG_ID NUMBER := FND_API.G_MISS_NUM
111: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
112: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
113: );
106: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
107: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , DISPOSITION_CODE VARCHAR2(30):= FND_API.G_MISS_CHAR
109: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
110: , ORG_ID NUMBER := FND_API.G_MISS_NUM
111: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
112: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
113: );
114:
107: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , DISPOSITION_CODE VARCHAR2(30):= FND_API.G_MISS_CHAR
109: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
110: , ORG_ID NUMBER := FND_API.G_MISS_NUM
111: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
112: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
113: );
114:
115: G_MISS_RPS_REC RPS_Rec_Type;
108: , DISPOSITION_CODE VARCHAR2(30):= FND_API.G_MISS_CHAR
109: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
110: , ORG_ID NUMBER := FND_API.G_MISS_NUM
111: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
112: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
113: );
114:
115: G_MISS_RPS_REC RPS_Rec_Type;
116: TYPE RPS_Tbl_Type IS TABLE OF RPS_Rec_Type
130: -- Pre-Req :
131: -- Parameters:
132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- Parameters:
132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_admin_group_id IN NUMBER Required
132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_admin_group_id IN NUMBER Required
140: -- P_RPS_Rec IN RPS_Rec_Type Required
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_admin_group_id IN NUMBER Required
140: -- P_RPS_Rec IN RPS_Rec_Type Required
141: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_admin_group_id IN NUMBER Required
140: -- P_RPS_Rec IN RPS_Rec_Type Required
141: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
142: --
151: -- End of Comments
152: --
153: PROCEDURE Create_repossession(
154: P_Api_Version_Number IN NUMBER,
155: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
156: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
159: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
152: --
153: PROCEDURE Create_repossession(
154: P_Api_Version_Number IN NUMBER,
155: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
156: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
159: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
160: P_Admin_Group_Id IN NUMBER,
153: PROCEDURE Create_repossession(
154: P_Api_Version_Number IN NUMBER,
155: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
156: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
159: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
160: P_Admin_Group_Id IN NUMBER,
161: P_Identity_Salesforce_Id IN NUMBER,
154: P_Api_Version_Number IN NUMBER,
155: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
156: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
159: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
160: P_Admin_Group_Id IN NUMBER,
161: P_Identity_Salesforce_Id IN NUMBER,
162: --P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
155: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
156: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
159: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
160: P_Admin_Group_Id IN NUMBER,
161: P_Identity_Salesforce_Id IN NUMBER,
162: --P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
163: P_RPS_Rec IN RPS_Rec_Type := G_MISS_RPS_REC,
176: -- Pre-Req :
177: -- Parameters:
178: -- IN
179: -- p_api_version_number IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- Parameters:
178: -- IN
179: -- p_api_version_number IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_admin_group_id IN NUMBER Required
178: -- IN
179: -- p_api_version_number IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_admin_group_id IN NUMBER Required
186: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
179: -- p_api_version_number IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_admin_group_id IN NUMBER Required
186: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
187: -- P_RPS_Rec IN RPS_Rec_Type Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_admin_group_id IN NUMBER Required
186: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
187: -- P_RPS_Rec IN RPS_Rec_Type Required
188: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
199: --
200: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
201: PROCEDURE Update_repossession(
202: P_Api_Version_Number IN NUMBER,
203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
207: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
200: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
201: PROCEDURE Update_repossession(
202: P_Api_Version_Number IN NUMBER,
203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
207: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
208: P_Admin_Group_Id IN NUMBER,
201: PROCEDURE Update_repossession(
202: P_Api_Version_Number IN NUMBER,
203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
207: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
208: P_Admin_Group_Id IN NUMBER,
209: P_Identity_Salesforce_Id IN NUMBER,
202: P_Api_Version_Number IN NUMBER,
203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
207: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
208: P_Admin_Group_Id IN NUMBER,
209: P_Identity_Salesforce_Id IN NUMBER,
210: --P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
207: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
208: P_Admin_Group_Id IN NUMBER,
209: P_Identity_Salesforce_Id IN NUMBER,
210: --P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
211: P_RPS_Rec IN RPS_Rec_Type,
222: -- Pre-Req :
223: -- Parameters:
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
230: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
223: -- Parameters:
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
230: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_admin_group_id IN NUMBER Required
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
230: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_admin_group_id IN NUMBER Required
232: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
230: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_admin_group_id IN NUMBER Required
232: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
233: -- P_RPS_Rec IN RPS_Rec_Type Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
230: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_admin_group_id IN NUMBER Required
232: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
233: -- P_RPS_Rec IN RPS_Rec_Type Required
234: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
246: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
247: -- The Master delete procedure may not be needed depends on different business requirements.
248: PROCEDURE Delete_repossession(
249: P_Api_Version_Number IN NUMBER,
250: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
251: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
254: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
247: -- The Master delete procedure may not be needed depends on different business requirements.
248: PROCEDURE Delete_repossession(
249: P_Api_Version_Number IN NUMBER,
250: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
251: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
254: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
255: P_Admin_Group_Id IN NUMBER,
248: PROCEDURE Delete_repossession(
249: P_Api_Version_Number IN NUMBER,
250: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
251: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
254: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
255: P_Admin_Group_Id IN NUMBER,
256: P_Identity_Salesforce_Id IN NUMBER,
249: P_Api_Version_Number IN NUMBER,
250: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
251: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
254: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
255: P_Admin_Group_Id IN NUMBER,
256: P_Identity_Salesforce_Id IN NUMBER,
257: P_Profile_Tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
250: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
251: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
254: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
255: P_Admin_Group_Id IN NUMBER,
256: P_Identity_Salesforce_Id IN NUMBER,
257: P_Profile_Tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
258: P_RPS_Rec IN RPS_Rec_Type,
269: -- Pre-Req :
270: -- Parameters:
271: -- IN
272: -- p_api_version_number IN NUMBER Required
273: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
274: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
275: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
276: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
277: -- p_admin_group_id IN NUMBER Required
270: -- Parameters:
271: -- IN
272: -- p_api_version_number IN NUMBER Required
273: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
274: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
275: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
276: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
277: -- p_admin_group_id IN NUMBER Required
278: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
271: -- IN
272: -- p_api_version_number IN NUMBER Required
273: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
274: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
275: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
276: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
277: -- p_admin_group_id IN NUMBER Required
278: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
279: -- P_RPS_Rec IN RPS_Rec_Type Required
272: -- p_api_version_number IN NUMBER Required
273: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
274: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
275: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
276: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
277: -- p_admin_group_id IN NUMBER Required
278: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
279: -- P_RPS_Rec IN RPS_Rec_Type Required
280: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
284: --
285: -- Return Total Records Count Flag. This flag controls whether the total record count
286: -- and total record amount is returned.
287: --
288: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
289: -- Hint: User defined record type
290: -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
291: --
292: -- OUT:
308:
309: /*
310: PROCEDURE Get_repossession(
311: P_Api_Version_Number IN NUMBER,
312: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
313: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
314: P_Admin_Group_id IN NUMBER,
315: P_identity_salesforce_id IN NUMBER := NULL,
316: P_RPS_Rec IN RPS_Rec_Type, --IEX_repossession_PUB.RPS_Rec_Type,
309: /*
310: PROCEDURE Get_repossession(
311: P_Api_Version_Number IN NUMBER,
312: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
313: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
314: P_Admin_Group_id IN NUMBER,
315: P_identity_salesforce_id IN NUMBER := NULL,
316: P_RPS_Rec IN RPS_Rec_Type, --IEX_repossession_PUB.RPS_Rec_Type,
317: -- Hint: Add list of bind variables here
316: P_RPS_Rec IN RPS_Rec_Type, --IEX_repossession_PUB.RPS_Rec_Type,
317: -- Hint: Add list of bind variables here
318: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
319: p_start_rec_prt IN NUMBER := 1,
320: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
321: -- Hint: user defined record type
322: p_order_by_rec IN RPS_sort_Rec_Type, --IEX_repossession_PUB.RPS_sort_rec_type,
323: x_return_status OUT NOCOPY VARCHAR2,
324: x_msg_count OUT NOCOPY NUMBER,
343: --
344: -- End of Comments
345:
346: PROCEDURE Validate_REPOSSESSION_ID (
347: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
348: P_Validation_mode IN VARCHAR2,
349: P_REPOSSESSION_ID IN NUMBER,
350: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
351: X_Return_Status OUT NOCOPY VARCHAR2,
364: --
365: -- End of Comments
366:
367: PROCEDURE Validate_DELINQUENCY_ID (
368: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
369: P_Validation_mode IN VARCHAR2,
370: P_DELINQUENCY_ID IN NUMBER,
371: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
372: X_Return_Status OUT NOCOPY VARCHAR2,
385: --
386: -- End of Comments
387:
388: PROCEDURE Validate_PARTY_ID (
389: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
390: P_Validation_mode IN VARCHAR2,
391: P_PARTY_ID IN NUMBER,
392: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
393: X_Return_Status OUT NOCOPY VARCHAR2,
406: --
407: -- End of Comments
408:
409: PROCEDURE Validate_CUST_ACCOUNT_ID (
410: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
411: P_Validation_mode IN VARCHAR2,
412: P_CUST_ACCOUNT_ID IN NUMBER,
413: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
414: X_Return_Status OUT NOCOPY VARCHAR2,
427: --
428: -- End of Comments
429:
430: PROCEDURE Validate_UNPAID_REASON_CODE (
431: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
432: P_Validation_mode IN VARCHAR2,
433: P_UNPAID_REASON_CODE IN VARCHAR2,
434: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
435: X_Return_Status OUT NOCOPY VARCHAR2,
448: --
449: -- End of Comments
450:
451: PROCEDURE Validate_REMARKET_FLAG (
452: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
453: P_Validation_mode IN VARCHAR2,
454: P_REMARKET_FLAG IN VARCHAR2,
455: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
456: X_Return_Status OUT NOCOPY VARCHAR2,
469: --
470: -- End of Comments
471:
472: PROCEDURE Validate_REPOSSESSION_DATE (
473: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
474: P_Validation_mode IN VARCHAR2,
475: P_REPOSSESSION_DATE IN DATE,
476: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
477: X_Return_Status OUT NOCOPY VARCHAR2,
490: --
491: -- End of Comments
492:
493: PROCEDURE Validate_ASSET_ID (
494: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
495: P_Validation_mode IN VARCHAR2,
496: P_ASSET_ID IN NUMBER,
497: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
498: X_Return_Status OUT NOCOPY VARCHAR2,
511: --
512: -- End of Comments
513:
514: PROCEDURE Validate_ASSET_VALUE (
515: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
516: P_Validation_mode IN VARCHAR2,
517: P_ASSET_VALUE IN NUMBER,
518: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
519: X_Return_Status OUT NOCOPY VARCHAR2,
532: --
533: -- End of Comments
534:
535: PROCEDURE Validate_ASSET_NUMBER (
536: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
537: P_Validation_mode IN VARCHAR2,
538: P_ASSET_NUMBER IN NUMBER,
539: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
540: X_Return_Status OUT NOCOPY VARCHAR2,
553: --
554: -- End of Comments
555:
556: PROCEDURE v_CREDIT_HOLD_REQUEST_FLAG (
557: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
558: P_Validation_mode IN VARCHAR2,
559: P_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2,
560: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
561: X_Return_Status OUT NOCOPY VARCHAR2,
574: --
575: -- End of Comments
576:
577: PROCEDURE v_CREDIT_HOLD_APPROVED_FLAG (
578: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
579: P_Validation_mode IN VARCHAR2,
580: P_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2,
581: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
582: X_Return_Status OUT NOCOPY VARCHAR2,
595: --
596: -- End of Comments
597:
598: PROCEDURE v_SERVICE_HOLD_REQUEST_FLAG (
599: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
600: P_Validation_mode IN VARCHAR2,
601: P_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2,
602: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
603: X_Return_Status OUT NOCOPY VARCHAR2,
616: --
617: -- End of Comments
618:
619: PROCEDURE v_SERVICE_HOLD_APPROVED_FLAG (
620: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
621: P_Validation_mode IN VARCHAR2,
622: P_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2,
623: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
624: X_Return_Status OUT NOCOPY VARCHAR2,
637: --
638: -- End of Comments
639:
640: PROCEDURE v_SUGGESTION_APPROVED_FLAG (
641: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
642: P_Validation_mode IN VARCHAR2,
643: P_SUGGESTION_APPROVED_FLAG IN VARCHAR2,
644: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
645: X_Return_Status OUT NOCOPY VARCHAR2,
658: -- 2. Developer can manually added inter-field level validation.
659: -- End of Comments
660:
661: PROCEDURE Validate_RPS_rec(
662: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
663: P_Validation_mode IN VARCHAR2,
664: P_RPS_Rec IN RPS_Rec_Type,
665: X_Return_Status OUT NOCOPY VARCHAR2,
666: X_Msg_Count OUT NOCOPY NUMBER,
678: -- 2. We can also validate table instead of record. There will be an option for user to choose.
679: -- End of Comments
680:
681: PROCEDURE Validate_repossession(
682: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
683: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
684: P_Validation_mode IN VARCHAR2,
685: P_RPS_Rec IN RPS_Rec_Type,
686: X_Return_Status OUT NOCOPY VARCHAR2,
679: -- End of Comments
680:
681: PROCEDURE Validate_repossession(
682: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
683: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
684: P_Validation_mode IN VARCHAR2,
685: P_RPS_Rec IN RPS_Rec_Type,
686: X_Return_Status OUT NOCOPY VARCHAR2,
687: X_Msg_Count OUT NOCOPY NUMBER,