60: -- End of Comments
61:
62: TYPE LTG_Rec_Type IS RECORD
63: (
64: LITIGATION_ID NUMBER := FND_API.G_MISS_NUM
65: , DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM
66: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
67: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , JUDGEMENT_DATE DATE := FND_API.G_MISS_DATE
61:
62: TYPE LTG_Rec_Type IS RECORD
63: (
64: LITIGATION_ID NUMBER := FND_API.G_MISS_NUM
65: , DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM
66: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
67: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , JUDGEMENT_DATE DATE := FND_API.G_MISS_DATE
69: , DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
62: TYPE LTG_Rec_Type IS RECORD
63: (
64: LITIGATION_ID NUMBER := FND_API.G_MISS_NUM
65: , DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM
66: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
67: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , JUDGEMENT_DATE DATE := FND_API.G_MISS_DATE
69: , DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
63: (
64: LITIGATION_ID NUMBER := FND_API.G_MISS_NUM
65: , DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM
66: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
67: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , JUDGEMENT_DATE DATE := FND_API.G_MISS_DATE
69: , DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
71: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
64: LITIGATION_ID NUMBER := FND_API.G_MISS_NUM
65: , DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM
66: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
67: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , JUDGEMENT_DATE DATE := FND_API.G_MISS_DATE
69: , DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
71: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
72: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
65: , DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM
66: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
67: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , JUDGEMENT_DATE DATE := FND_API.G_MISS_DATE
69: , DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
71: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
72: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
73: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
66: , PARTY_ID NUMBER := FND_API.G_MISS_NUM
67: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , JUDGEMENT_DATE DATE := FND_API.G_MISS_DATE
69: , DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
71: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
72: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
73: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
74: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , UNPAID_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , JUDGEMENT_DATE DATE := FND_API.G_MISS_DATE
69: , DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
71: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
72: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
73: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
74: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , JUDGEMENT_DATE DATE := FND_API.G_MISS_DATE
69: , DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
71: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
72: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
73: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
74: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
71: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
72: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
73: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
74: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
71: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
72: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
73: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
74: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
72: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
73: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
74: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
73: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
74: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
74: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
83: , ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
91: , CREATION_DATE DATE := FND_API.G_MISS_DATE
84: , ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
91: , CREATION_DATE DATE := FND_API.G_MISS_DATE
92: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
85: , ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
91: , CREATION_DATE DATE := FND_API.G_MISS_DATE
92: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
93: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
86: , ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
91: , CREATION_DATE DATE := FND_API.G_MISS_DATE
92: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
93: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
94: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
87: , ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
91: , CREATION_DATE DATE := FND_API.G_MISS_DATE
92: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
93: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
94: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
95: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
91: , CREATION_DATE DATE := FND_API.G_MISS_DATE
92: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
93: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
94: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
95: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
91: , CREATION_DATE DATE := FND_API.G_MISS_DATE
92: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
93: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
94: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
95: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
91: , CREATION_DATE DATE := FND_API.G_MISS_DATE
92: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
93: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
94: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
95: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
91: , CREATION_DATE DATE := FND_API.G_MISS_DATE
92: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
93: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
94: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
95: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , SUGGESTION_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
92: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
93: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
94: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
95: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , SUGGESTION_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
93: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
94: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
95: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , SUGGESTION_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
101: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
94: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
95: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , SUGGESTION_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
101: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
102: , ORG_ID NUMBER := FND_API.G_MISS_NUM
95: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , SUGGESTION_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
101: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
102: , ORG_ID NUMBER := FND_API.G_MISS_NUM
103: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
96: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , SUGGESTION_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
101: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
102: , ORG_ID NUMBER := FND_API.G_MISS_NUM
103: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
104: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
97: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , SUGGESTION_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
101: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
102: , ORG_ID NUMBER := FND_API.G_MISS_NUM
103: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
104: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
105: );
98: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , SUGGESTION_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
101: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
102: , ORG_ID NUMBER := FND_API.G_MISS_NUM
103: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
104: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
105: );
106:
99: , SUGGESTION_APPROVED_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
101: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
102: , ORG_ID NUMBER := FND_API.G_MISS_NUM
103: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
104: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
105: );
106:
107: TYPE LTG_sort_rec_type IS RECORD
100: , CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM
101: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
102: , ORG_ID NUMBER := FND_API.G_MISS_NUM
103: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
104: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
105: );
106:
107: TYPE LTG_sort_rec_type IS RECORD
108: (
123: -- Pre-Req :
124: -- Parameters:
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
124: -- Parameters:
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
132: -- p_admin_group_id IN NUMBER Required
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
132: -- p_admin_group_id IN NUMBER Required
133: -- P_LTG_Rec IN LTG_Rec_Type Required
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
132: -- p_admin_group_id IN NUMBER Required
133: -- P_LTG_Rec IN LTG_Rec_Type Required
134: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
132: -- p_admin_group_id IN NUMBER Required
133: -- P_LTG_Rec IN LTG_Rec_Type Required
134: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
135: --
144: -- End of Comments
145: --
146: PROCEDURE Create_litigation(
147: P_Api_Version_Number IN NUMBER,
148: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
149: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
152: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
145: --
146: PROCEDURE Create_litigation(
147: P_Api_Version_Number IN NUMBER,
148: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
149: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
152: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
153: P_Admin_Group_Id IN NUMBER,
146: PROCEDURE Create_litigation(
147: P_Api_Version_Number IN NUMBER,
148: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
149: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
152: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
153: P_Admin_Group_Id IN NUMBER,
154: P_Identity_Salesforce_Id IN NUMBER,
147: P_Api_Version_Number IN NUMBER,
148: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
149: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
152: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
153: P_Admin_Group_Id IN NUMBER,
154: P_Identity_Salesforce_Id IN NUMBER,
155: --P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
148: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
149: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
152: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
153: P_Admin_Group_Id IN NUMBER,
154: P_Identity_Salesforce_Id IN NUMBER,
155: --P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
156: P_LTG_Rec IN LTG_Rec_Type := G_MISS_LTG_REC,
169: -- Pre-Req :
170: -- Parameters:
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
170: -- Parameters:
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_admin_group_id IN NUMBER Required
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_admin_group_id IN NUMBER Required
179: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_admin_group_id IN NUMBER Required
179: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
180: -- P_LTG_Rec IN LTG_Rec_Type Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_admin_group_id IN NUMBER Required
179: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
180: -- P_LTG_Rec IN LTG_Rec_Type Required
181: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
192: --
193: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
194: PROCEDURE Update_litigation(
195: P_Api_Version_Number IN NUMBER,
196: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
200: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
193: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
194: PROCEDURE Update_litigation(
195: P_Api_Version_Number IN NUMBER,
196: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
200: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
201: P_Admin_Group_Id IN NUMBER,
194: PROCEDURE Update_litigation(
195: P_Api_Version_Number IN NUMBER,
196: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
200: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
201: P_Admin_Group_Id IN NUMBER,
202: P_Identity_Salesforce_Id IN NUMBER,
195: P_Api_Version_Number IN NUMBER,
196: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
200: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
201: P_Admin_Group_Id IN NUMBER,
202: P_Identity_Salesforce_Id IN NUMBER,
203: -- P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
196: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
200: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
201: P_Admin_Group_Id IN NUMBER,
202: P_Identity_Salesforce_Id IN NUMBER,
203: -- P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
204: P_LTG_Rec IN LTG_Rec_Type,
215: -- Pre-Req :
216: -- Parameters:
217: -- IN
218: -- p_api_version_number IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
223: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
216: -- Parameters:
217: -- IN
218: -- p_api_version_number IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
223: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_admin_group_id IN NUMBER Required
217: -- IN
218: -- p_api_version_number IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
223: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_admin_group_id IN NUMBER Required
225: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
218: -- p_api_version_number IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
223: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_admin_group_id IN NUMBER Required
225: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
226: -- P_LTG_Rec IN LTG_Rec_Type Required
219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
223: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_admin_group_id IN NUMBER Required
225: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
226: -- P_LTG_Rec IN LTG_Rec_Type Required
227: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
239: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
240: -- The Master delete procedure may not be needed depends on different business requirements.
241: PROCEDURE Delete_litigation(
242: P_Api_Version_Number IN NUMBER,
243: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
244: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
246: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
247: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
240: -- The Master delete procedure may not be needed depends on different business requirements.
241: PROCEDURE Delete_litigation(
242: P_Api_Version_Number IN NUMBER,
243: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
244: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
246: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
247: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
248: P_Admin_Group_Id IN NUMBER,
241: PROCEDURE Delete_litigation(
242: P_Api_Version_Number IN NUMBER,
243: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
244: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
246: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
247: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
248: P_Admin_Group_Id IN NUMBER,
249: P_Identity_Salesforce_Id IN NUMBER,
242: P_Api_Version_Number IN NUMBER,
243: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
244: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
246: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
247: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
248: P_Admin_Group_Id IN NUMBER,
249: P_Identity_Salesforce_Id IN NUMBER,
250: P_Profile_Tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
243: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
244: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
246: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
247: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
248: P_Admin_Group_Id IN NUMBER,
249: P_Identity_Salesforce_Id IN NUMBER,
250: P_Profile_Tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
251: P_LTG_Rec IN LTG_Rec_Type,
262: -- Pre-Req :
263: -- Parameters:
264: -- IN
265: -- p_api_version_number IN NUMBER Required
266: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
267: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
268: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
269: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
270: -- p_admin_group_id IN NUMBER Required
263: -- Parameters:
264: -- IN
265: -- p_api_version_number IN NUMBER Required
266: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
267: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
268: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
269: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
270: -- p_admin_group_id IN NUMBER Required
271: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
264: -- IN
265: -- p_api_version_number IN NUMBER Required
266: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
267: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
268: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
269: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
270: -- p_admin_group_id IN NUMBER Required
271: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
272: -- P_LTG_Rec IN LTG_Rec_Type Required
265: -- p_api_version_number IN NUMBER Required
266: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
267: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
268: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
269: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
270: -- p_admin_group_id IN NUMBER Required
271: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
272: -- P_LTG_Rec IN LTG_Rec_Type Required
273: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
277: --
278: -- Return Total Records Count Flag. This flag controls whether the total record count
279: -- and total record amount is returned.
280: --
281: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
282: -- Hint: User defined record type
283: -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
284: --
285: -- OUT:
299: -- End of Comments
300: --
301: PROCEDURE Get_litigation(
302: P_Api_Version_Number IN NUMBER,
303: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305: P_Admin_Group_id IN NUMBER,
306: P_identity_salesforce_id IN NUMBER := NULL,
307: P_LTG_Rec IN LTG_Rec_Type,
300: --
301: PROCEDURE Get_litigation(
302: P_Api_Version_Number IN NUMBER,
303: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305: P_Admin_Group_id IN NUMBER,
306: P_identity_salesforce_id IN NUMBER := NULL,
307: P_LTG_Rec IN LTG_Rec_Type,
308: -- Hint: Add list of bind variables here
307: P_LTG_Rec IN LTG_Rec_Type,
308: -- Hint: Add list of bind variables here
309: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
310: p_start_rec_prt IN NUMBER := 1,
311: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
312: -- Hint: user defined record type
313: p_order_by_rec IN LTG_sort_rec_type,
314: x_return_status OUT NOCOPY VARCHAR2,
315: x_msg_count OUT NOCOPY NUMBER,
334: --
335: -- End of Comments
336:
337: PROCEDURE Validate_LITIGATION_ID (
338: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
339: P_Validation_mode IN VARCHAR2,
340: P_LITIGATION_ID IN NUMBER,
341: -- 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.
342: X_Return_Status OUT NOCOPY VARCHAR2,
355: --
356: -- End of Comments
357:
358: PROCEDURE Validate_DELINQUENCY_ID (
359: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
360: P_Validation_mode IN VARCHAR2,
361: P_DELINQUENCY_ID IN NUMBER,
362: -- 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.
363: X_Return_Status OUT NOCOPY VARCHAR2,
376: --
377: -- End of Comments
378:
379: PROCEDURE Validate_PARTY_ID (
380: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
381: P_Validation_mode IN VARCHAR2,
382: P_PARTY_ID IN NUMBER,
383: -- 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.
384: X_Return_Status OUT NOCOPY VARCHAR2,
397: --
398: -- End of Comments
399:
400: PROCEDURE Validate_UNPAID_REASON_CODE (
401: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
402: P_Validation_mode IN VARCHAR2,
403: P_UNPAID_REASON_CODE IN VARCHAR2,
404: -- 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.
405: X_Return_Status OUT NOCOPY VARCHAR2,
418: --
419: -- End of Comments
420:
421: PROCEDURE Validate_JUDGEMENT_DATE (
422: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
423: P_Validation_mode IN VARCHAR2,
424: P_JUDGEMENT_DATE IN DATE,
425: -- 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.
426: X_Return_Status OUT NOCOPY VARCHAR2,
439: --
440: -- End of Comments
441:
442: PROCEDURE Validate_DISPOSITION_CODE (
443: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
444: P_Validation_mode IN VARCHAR2,
445: P_DISPOSITION_CODE IN VARCHAR2,
446: -- 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.
447: X_Return_Status OUT NOCOPY VARCHAR2,
460: --
461: -- End of Comments
462:
463: PROCEDURE v_CREDIT_HOLD_REQUEST_FLAG (
464: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
465: P_Validation_mode IN VARCHAR2,
466: P_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2,
467: -- 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.
468: X_Return_Status OUT NOCOPY VARCHAR2,
481: --
482: -- End of Comments
483:
484: PROCEDURE v_CREDIT_HOLD_APPROVED_FLAG (
485: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
486: P_Validation_mode IN VARCHAR2,
487: P_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2,
488: -- 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.
489: X_Return_Status OUT NOCOPY VARCHAR2,
502: --
503: -- End of Comments
504:
505: PROCEDURE v_SERVICE_HOLD_REQUEST_FLAG (
506: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
507: P_Validation_mode IN VARCHAR2,
508: P_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2,
509: -- 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.
510: X_Return_Status OUT NOCOPY VARCHAR2,
523: --
524: -- End of Comments
525:
526: PROCEDURE v_SERVICE_HOLD_APPROVED_FLAG (
527: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
528: P_Validation_mode IN VARCHAR2,
529: P_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2,
530: -- 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.
531: X_Return_Status OUT NOCOPY VARCHAR2,
544: --
545: -- End of Comments
546:
547: PROCEDURE v_SUGGESTION_APPROVED_FLAG (
548: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
549: P_Validation_mode IN VARCHAR2,
550: P_SUGGESTION_APPROVED_FLAG IN VARCHAR2,
551: -- 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.
552: X_Return_Status OUT NOCOPY VARCHAR2,
565: -- 2. Developer can manually added inter-field level validation.
566: -- End of Comments
567:
568: PROCEDURE Validate_LTG_rec(
569: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
570: P_Validation_mode IN VARCHAR2,
571: P_LTG_Rec IN LTG_Rec_Type,
572: X_Return_Status OUT NOCOPY VARCHAR2,
573: X_Msg_Count OUT NOCOPY NUMBER,
585: -- 2. We can also validate table instead of record. There will be an option for user to choose.
586: -- End of Comments
587:
588: PROCEDURE Validate_litigation(
589: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
590: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
591: P_Validation_mode IN VARCHAR2,
592: P_LTG_Rec IN LTG_Rec_Type,
593: X_Return_Status OUT NOCOPY VARCHAR2,
586: -- End of Comments
587:
588: PROCEDURE Validate_litigation(
589: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
590: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
591: P_Validation_mode IN VARCHAR2,
592: P_LTG_Rec IN LTG_Rec_Type,
593: X_Return_Status OUT NOCOPY VARCHAR2,
594: X_Msg_Count OUT NOCOPY NUMBER,