62: -- End of Comments
63:
64: TYPE costs_Rec_Type IS RECORD
65: (
66: COST_ID NUMBER := FND_API.G_MISS_NUM,
67: CASE_ID NUMBER := FND_API.G_MISS_NUM,
68: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
69: COST_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: COST_ITEM_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
63:
64: TYPE costs_Rec_Type IS RECORD
65: (
66: COST_ID NUMBER := FND_API.G_MISS_NUM,
67: CASE_ID NUMBER := FND_API.G_MISS_NUM,
68: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
69: COST_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: COST_ITEM_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: COST_ITEM_TYPE_DESC VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: TYPE costs_Rec_Type IS RECORD
65: (
66: COST_ID NUMBER := FND_API.G_MISS_NUM,
67: CASE_ID NUMBER := FND_API.G_MISS_NUM,
68: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
69: COST_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: COST_ITEM_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: COST_ITEM_TYPE_DESC VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: COST_ITEM_AMOUNT NUMBER := FND_API.G_MISS_NUM,
65: (
66: COST_ID NUMBER := FND_API.G_MISS_NUM,
67: CASE_ID NUMBER := FND_API.G_MISS_NUM,
68: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
69: COST_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: COST_ITEM_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: COST_ITEM_TYPE_DESC VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: COST_ITEM_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: COST_ITEM_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
66: COST_ID NUMBER := FND_API.G_MISS_NUM,
67: CASE_ID NUMBER := FND_API.G_MISS_NUM,
68: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
69: COST_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: COST_ITEM_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: COST_ITEM_TYPE_DESC VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: COST_ITEM_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: COST_ITEM_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: COST_ITEM_QTY NUMBER := FND_API.G_MISS_NUM,
67: CASE_ID NUMBER := FND_API.G_MISS_NUM,
68: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
69: COST_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: COST_ITEM_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: COST_ITEM_TYPE_DESC VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: COST_ITEM_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: COST_ITEM_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: COST_ITEM_QTY NUMBER := FND_API.G_MISS_NUM,
75: COST_ITEM_DATE DATE := FND_API.G_MISS_DATE,
68: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
69: COST_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: COST_ITEM_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: COST_ITEM_TYPE_DESC VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: COST_ITEM_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: COST_ITEM_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: COST_ITEM_QTY NUMBER := FND_API.G_MISS_NUM,
75: COST_ITEM_DATE DATE := FND_API.G_MISS_DATE,
76: FUNCTIONAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
69: COST_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: COST_ITEM_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: COST_ITEM_TYPE_DESC VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: COST_ITEM_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: COST_ITEM_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: COST_ITEM_QTY NUMBER := FND_API.G_MISS_NUM,
75: COST_ITEM_DATE DATE := FND_API.G_MISS_DATE,
76: FUNCTIONAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
77: EXCHANGE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
70: COST_ITEM_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: COST_ITEM_TYPE_DESC VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: COST_ITEM_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: COST_ITEM_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: COST_ITEM_QTY NUMBER := FND_API.G_MISS_NUM,
75: COST_ITEM_DATE DATE := FND_API.G_MISS_DATE,
76: FUNCTIONAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
77: EXCHANGE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
78: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
71: COST_ITEM_TYPE_DESC VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: COST_ITEM_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: COST_ITEM_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: COST_ITEM_QTY NUMBER := FND_API.G_MISS_NUM,
75: COST_ITEM_DATE DATE := FND_API.G_MISS_DATE,
76: FUNCTIONAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
77: EXCHANGE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
78: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
79: EXCHANGE_DATE DATE := FND_API.G_MISS_DATE,
72: COST_ITEM_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73: COST_ITEM_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: COST_ITEM_QTY NUMBER := FND_API.G_MISS_NUM,
75: COST_ITEM_DATE DATE := FND_API.G_MISS_DATE,
76: FUNCTIONAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
77: EXCHANGE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
78: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
79: EXCHANGE_DATE DATE := FND_API.G_MISS_DATE,
80: COST_ITEM_APPROVED VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: COST_ITEM_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: COST_ITEM_QTY NUMBER := FND_API.G_MISS_NUM,
75: COST_ITEM_DATE DATE := FND_API.G_MISS_DATE,
76: FUNCTIONAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
77: EXCHANGE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
78: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
79: EXCHANGE_DATE DATE := FND_API.G_MISS_DATE,
80: COST_ITEM_APPROVED VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: COST_ITEM_QTY NUMBER := FND_API.G_MISS_NUM,
75: COST_ITEM_DATE DATE := FND_API.G_MISS_DATE,
76: FUNCTIONAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
77: EXCHANGE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
78: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
79: EXCHANGE_DATE DATE := FND_API.G_MISS_DATE,
80: COST_ITEM_APPROVED VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
75: COST_ITEM_DATE DATE := FND_API.G_MISS_DATE,
76: FUNCTIONAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
77: EXCHANGE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
78: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
79: EXCHANGE_DATE DATE := FND_API.G_MISS_DATE,
80: COST_ITEM_APPROVED VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
76: FUNCTIONAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
77: EXCHANGE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
78: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
79: EXCHANGE_DATE DATE := FND_API.G_MISS_DATE,
80: COST_ITEM_APPROVED VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
77: EXCHANGE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
78: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
79: EXCHANGE_DATE DATE := FND_API.G_MISS_DATE,
80: COST_ITEM_APPROVED VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
78: EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
79: EXCHANGE_DATE DATE := FND_API.G_MISS_DATE,
80: COST_ITEM_APPROVED VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
79: EXCHANGE_DATE DATE := FND_API.G_MISS_DATE,
80: COST_ITEM_APPROVED VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
80: COST_ITEM_APPROVED VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
88: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
81: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
88: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
89: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
82: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
88: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
89: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
90: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
83: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
88: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
89: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
90: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: CREATION_DATE DATE := FND_API.G_MISS_DATE,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
88: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
89: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
90: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
88: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
89: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
90: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
88: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
89: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
90: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
88: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
89: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
90: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
89: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
90: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
90: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
100: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
108: );
101: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
108: );
109:
102: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
108: );
109:
110: G_MISS_costs_REC costs_Rec_Type;
103: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
108: );
109:
110: G_MISS_costs_REC costs_Rec_Type;
111: TYPE costs_Tbl_Type IS TABLE OF costs_Rec_Type
120: -- Pre-Req :
121: -- Parameters:
122: -- IN
123: -- p_api_version_number IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
125: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127: -- P_costs_Rec IN costs_Rec_Type Required
128: --
121: -- Parameters:
122: -- IN
123: -- p_api_version_number IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
125: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127: -- P_costs_Rec IN costs_Rec_Type Required
128: --
129: -- OUT:
122: -- IN
123: -- p_api_version_number IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
125: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127: -- P_costs_Rec IN costs_Rec_Type Required
128: --
129: -- OUT:
130: -- x_return_status OUT NOCOPY VARCHAR2
133: -- End of Comments
134: --
135: PROCEDURE Create_costs(
136: P_Api_Version_Number IN NUMBER,
137: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
138: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: P_costs_Rec IN costs_Rec_Type := G_MISS_costs_REC,
141: X_COST_ID OUT NOCOPY NUMBER,
134: --
135: PROCEDURE Create_costs(
136: P_Api_Version_Number IN NUMBER,
137: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
138: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: P_costs_Rec IN costs_Rec_Type := G_MISS_costs_REC,
141: X_COST_ID OUT NOCOPY NUMBER,
142: X_Return_Status OUT NOCOPY VARCHAR2,
135: PROCEDURE Create_costs(
136: P_Api_Version_Number IN NUMBER,
137: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
138: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: P_costs_Rec IN costs_Rec_Type := G_MISS_costs_REC,
141: X_COST_ID OUT NOCOPY NUMBER,
142: X_Return_Status OUT NOCOPY VARCHAR2,
143: X_Msg_Count OUT NOCOPY NUMBER,
152: -- Pre-Req :
153: -- Parameters:
154: -- IN
155: -- p_api_version_number IN NUMBER Required
156: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
157: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
158: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
159: -- P_costs_Rec IN costs_Rec_Type Required
160: --
153: -- Parameters:
154: -- IN
155: -- p_api_version_number IN NUMBER Required
156: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
157: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
158: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
159: -- P_costs_Rec IN costs_Rec_Type Required
160: --
161: -- OUT:
154: -- IN
155: -- p_api_version_number IN NUMBER Required
156: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
157: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
158: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
159: -- P_costs_Rec IN costs_Rec_Type Required
160: --
161: -- OUT:
162: -- x_return_status OUT NOCOPY VARCHAR2
168: --
169: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
170: PROCEDURE Update_costs(
171: P_Api_Version_Number IN NUMBER,
172: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
173: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: P_costs_Rec IN costs_Rec_Type,
176: X_Return_Status OUT NOCOPY VARCHAR2,
169: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
170: PROCEDURE Update_costs(
171: P_Api_Version_Number IN NUMBER,
172: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
173: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: P_costs_Rec IN costs_Rec_Type,
176: X_Return_Status OUT NOCOPY VARCHAR2,
177: X_Msg_Count OUT NOCOPY NUMBER,
170: PROCEDURE Update_costs(
171: P_Api_Version_Number IN NUMBER,
172: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
173: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: P_costs_Rec IN costs_Rec_Type,
176: X_Return_Status OUT NOCOPY VARCHAR2,
177: X_Msg_Count OUT NOCOPY NUMBER,
178: X_Msg_Data OUT NOCOPY VARCHAR2,
187: -- Pre-Req :
188: -- Parameters:
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194: -- P_cost_ID IN NUMBER Required
195: --
188: -- Parameters:
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194: -- P_cost_ID IN NUMBER Required
195: --
196: -- OUT:
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194: -- P_cost_ID IN NUMBER Required
195: --
196: -- OUT:
197: -- x_return_status OUT NOCOPY VARCHAR2
201: -- End of Comments
202: --
203: PROCEDURE Delete_costs(
204: P_Api_Version_Number IN NUMBER,
205: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
206: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
207: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
208: P_cost_ID IN NUMBER,
209: X_Return_Status OUT NOCOPY VARCHAR2,
202: --
203: PROCEDURE Delete_costs(
204: P_Api_Version_Number IN NUMBER,
205: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
206: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
207: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
208: P_cost_ID IN NUMBER,
209: X_Return_Status OUT NOCOPY VARCHAR2,
210: X_Msg_Count OUT NOCOPY NUMBER,
203: PROCEDURE Delete_costs(
204: P_Api_Version_Number IN NUMBER,
205: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
206: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
207: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
208: P_cost_ID IN NUMBER,
209: X_Return_Status OUT NOCOPY VARCHAR2,
210: X_Msg_Count OUT NOCOPY NUMBER,
211: X_Msg_Data OUT NOCOPY VARCHAR2