APPS.IEX_WRITEOFFS_PVT dependencies on FND_API

Line 81: WRITEOFF_ID NUMBER := FND_API.G_MISS_NUM,

77: -- End of Comments
78:
79: TYPE writeoffs_Rec_Type IS RECORD
80: (
81: WRITEOFF_ID NUMBER := FND_API.G_MISS_NUM,
82: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
83: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
84: CAS_ID NUMBER := FND_API.G_MISS_NUM,
85: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,

Line 82: PARTY_ID NUMBER := FND_API.G_MISS_NUM,

78:
79: TYPE writeoffs_Rec_Type IS RECORD
80: (
81: WRITEOFF_ID NUMBER := FND_API.G_MISS_NUM,
82: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
83: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
84: CAS_ID NUMBER := FND_API.G_MISS_NUM,
85: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
86: DISPOSITION_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 83: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,

79: TYPE writeoffs_Rec_Type IS RECORD
80: (
81: WRITEOFF_ID NUMBER := FND_API.G_MISS_NUM,
82: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
83: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
84: CAS_ID NUMBER := FND_API.G_MISS_NUM,
85: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
86: DISPOSITION_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

Line 84: CAS_ID NUMBER := FND_API.G_MISS_NUM,

80: (
81: WRITEOFF_ID NUMBER := FND_API.G_MISS_NUM,
82: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
83: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
84: CAS_ID NUMBER := FND_API.G_MISS_NUM,
85: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
86: DISPOSITION_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
88: OBJECT_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 85: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,

81: WRITEOFF_ID NUMBER := FND_API.G_MISS_NUM,
82: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
83: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
84: CAS_ID NUMBER := FND_API.G_MISS_NUM,
85: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
86: DISPOSITION_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
88: OBJECT_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: WRITEOFF_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 86: DISPOSITION_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

82: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
83: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
84: CAS_ID NUMBER := FND_API.G_MISS_NUM,
85: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
86: DISPOSITION_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
88: OBJECT_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: WRITEOFF_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 87: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

83: DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
84: CAS_ID NUMBER := FND_API.G_MISS_NUM,
85: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
86: DISPOSITION_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
88: OBJECT_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: WRITEOFF_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,

Line 88: OBJECT_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

84: CAS_ID NUMBER := FND_API.G_MISS_NUM,
85: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
86: DISPOSITION_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
88: OBJECT_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: WRITEOFF_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
92: WRITEOFF_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 89: WRITEOFF_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,

85: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
86: DISPOSITION_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
88: OBJECT_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: WRITEOFF_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
92: WRITEOFF_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: WRITEOFF_AMOUNT NUMBER := FND_API.G_MISS_NUM,

Line 90: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,

86: DISPOSITION_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
88: OBJECT_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: WRITEOFF_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
92: WRITEOFF_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: WRITEOFF_AMOUNT NUMBER := FND_API.G_MISS_NUM,
94: WRITEOFF_CURRENCY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 91: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,

87: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
88: OBJECT_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: WRITEOFF_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
92: WRITEOFF_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: WRITEOFF_AMOUNT NUMBER := FND_API.G_MISS_NUM,
94: WRITEOFF_CURRENCY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: WRITEOFF_DATE DATE := FND_API.G_MISS_DATE,

Line 92: WRITEOFF_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,

88: OBJECT_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
89: WRITEOFF_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
92: WRITEOFF_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: WRITEOFF_AMOUNT NUMBER := FND_API.G_MISS_NUM,
94: WRITEOFF_CURRENCY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: WRITEOFF_DATE DATE := FND_API.G_MISS_DATE,
96: WRITEOFF_REQUEST_DATE DATE := FND_API.G_MISS_DATE,

Line 93: WRITEOFF_AMOUNT NUMBER := FND_API.G_MISS_NUM,

89: WRITEOFF_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
90: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
92: WRITEOFF_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: WRITEOFF_AMOUNT NUMBER := FND_API.G_MISS_NUM,
94: WRITEOFF_CURRENCY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: WRITEOFF_DATE DATE := FND_API.G_MISS_DATE,
96: WRITEOFF_REQUEST_DATE DATE := FND_API.G_MISS_DATE,
97: WRITEOFF_PROCESS VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 94: WRITEOFF_CURRENCY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

90: ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
91: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
92: WRITEOFF_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: WRITEOFF_AMOUNT NUMBER := FND_API.G_MISS_NUM,
94: WRITEOFF_CURRENCY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: WRITEOFF_DATE DATE := FND_API.G_MISS_DATE,
96: WRITEOFF_REQUEST_DATE DATE := FND_API.G_MISS_DATE,
97: WRITEOFF_PROCESS VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: WRITEOFF_SCORE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 95: WRITEOFF_DATE DATE := FND_API.G_MISS_DATE,

91: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
92: WRITEOFF_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: WRITEOFF_AMOUNT NUMBER := FND_API.G_MISS_NUM,
94: WRITEOFF_CURRENCY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: WRITEOFF_DATE DATE := FND_API.G_MISS_DATE,
96: WRITEOFF_REQUEST_DATE DATE := FND_API.G_MISS_DATE,
97: WRITEOFF_PROCESS VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: WRITEOFF_SCORE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: BAD_DEBT_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 96: WRITEOFF_REQUEST_DATE DATE := FND_API.G_MISS_DATE,

92: WRITEOFF_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
93: WRITEOFF_AMOUNT NUMBER := FND_API.G_MISS_NUM,
94: WRITEOFF_CURRENCY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: WRITEOFF_DATE DATE := FND_API.G_MISS_DATE,
96: WRITEOFF_REQUEST_DATE DATE := FND_API.G_MISS_DATE,
97: WRITEOFF_PROCESS VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: WRITEOFF_SCORE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: BAD_DEBT_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: LEASING_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 97: WRITEOFF_PROCESS VARCHAR2(240) := FND_API.G_MISS_CHAR,

93: WRITEOFF_AMOUNT NUMBER := FND_API.G_MISS_NUM,
94: WRITEOFF_CURRENCY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: WRITEOFF_DATE DATE := FND_API.G_MISS_DATE,
96: WRITEOFF_REQUEST_DATE DATE := FND_API.G_MISS_DATE,
97: WRITEOFF_PROCESS VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: WRITEOFF_SCORE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: BAD_DEBT_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: LEASING_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: REPOSSES_SCH_DATE DATE := FND_API.G_MISS_DATE,

Line 98: WRITEOFF_SCORE VARCHAR2(240) := FND_API.G_MISS_CHAR,

94: WRITEOFF_CURRENCY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
95: WRITEOFF_DATE DATE := FND_API.G_MISS_DATE,
96: WRITEOFF_REQUEST_DATE DATE := FND_API.G_MISS_DATE,
97: WRITEOFF_PROCESS VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: WRITEOFF_SCORE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: BAD_DEBT_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: LEASING_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: REPOSSES_SCH_DATE DATE := FND_API.G_MISS_DATE,
102: REPOSSES_COMP_DATE DATE := FND_API.G_MISS_DATE,

Line 99: BAD_DEBT_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,

95: WRITEOFF_DATE DATE := FND_API.G_MISS_DATE,
96: WRITEOFF_REQUEST_DATE DATE := FND_API.G_MISS_DATE,
97: WRITEOFF_PROCESS VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: WRITEOFF_SCORE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: BAD_DEBT_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: LEASING_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: REPOSSES_SCH_DATE DATE := FND_API.G_MISS_DATE,
102: REPOSSES_COMP_DATE DATE := FND_API.G_MISS_DATE,
103: CREDIT_HOLD_YN VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 100: LEASING_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

96: WRITEOFF_REQUEST_DATE DATE := FND_API.G_MISS_DATE,
97: WRITEOFF_PROCESS VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: WRITEOFF_SCORE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: BAD_DEBT_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: LEASING_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: REPOSSES_SCH_DATE DATE := FND_API.G_MISS_DATE,
102: REPOSSES_COMP_DATE DATE := FND_API.G_MISS_DATE,
103: CREDIT_HOLD_YN VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: APPROVER_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 101: REPOSSES_SCH_DATE DATE := FND_API.G_MISS_DATE,

97: WRITEOFF_PROCESS VARCHAR2(240) := FND_API.G_MISS_CHAR,
98: WRITEOFF_SCORE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: BAD_DEBT_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: LEASING_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: REPOSSES_SCH_DATE DATE := FND_API.G_MISS_DATE,
102: REPOSSES_COMP_DATE DATE := FND_API.G_MISS_DATE,
103: CREDIT_HOLD_YN VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: APPROVER_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: EXTERNAL_AGENT_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 102: REPOSSES_COMP_DATE DATE := FND_API.G_MISS_DATE,

98: WRITEOFF_SCORE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99: BAD_DEBT_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: LEASING_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: REPOSSES_SCH_DATE DATE := FND_API.G_MISS_DATE,
102: REPOSSES_COMP_DATE DATE := FND_API.G_MISS_DATE,
103: CREDIT_HOLD_YN VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: APPROVER_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: EXTERNAL_AGENT_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: PROCEDURE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 103: CREDIT_HOLD_YN VARCHAR2(240) := FND_API.G_MISS_CHAR,

99: BAD_DEBT_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: LEASING_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: REPOSSES_SCH_DATE DATE := FND_API.G_MISS_DATE,
102: REPOSSES_COMP_DATE DATE := FND_API.G_MISS_DATE,
103: CREDIT_HOLD_YN VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: APPROVER_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: EXTERNAL_AGENT_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: PROCEDURE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: CHECKLIST_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 104: APPROVER_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,

100: LEASING_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
101: REPOSSES_SCH_DATE DATE := FND_API.G_MISS_DATE,
102: REPOSSES_COMP_DATE DATE := FND_API.G_MISS_DATE,
103: CREDIT_HOLD_YN VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: APPROVER_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: EXTERNAL_AGENT_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: PROCEDURE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: CHECKLIST_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
108: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

Line 105: EXTERNAL_AGENT_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,

101: REPOSSES_SCH_DATE DATE := FND_API.G_MISS_DATE,
102: REPOSSES_COMP_DATE DATE := FND_API.G_MISS_DATE,
103: CREDIT_HOLD_YN VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: APPROVER_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: EXTERNAL_AGENT_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: PROCEDURE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: CHECKLIST_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
108: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
109: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 106: PROCEDURE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

102: REPOSSES_COMP_DATE DATE := FND_API.G_MISS_DATE,
103: CREDIT_HOLD_YN VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: APPROVER_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: EXTERNAL_AGENT_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: PROCEDURE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: CHECKLIST_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
108: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
109: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
110: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

Line 107: CHECKLIST_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

103: CREDIT_HOLD_YN VARCHAR2(240) := FND_API.G_MISS_CHAR,
104: APPROVER_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: EXTERNAL_AGENT_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: PROCEDURE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: CHECKLIST_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
108: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
109: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
110: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
111: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 108: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

104: APPROVER_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
105: EXTERNAL_AGENT_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: PROCEDURE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: CHECKLIST_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
108: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
109: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
110: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
111: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
112: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 109: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

105: EXTERNAL_AGENT_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
106: PROCEDURE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: CHECKLIST_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
108: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
109: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
110: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
111: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
112: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 110: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

106: PROCEDURE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
107: CHECKLIST_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
108: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
109: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
110: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
111: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
112: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 111: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

107: CHECKLIST_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
108: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
109: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
110: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
111: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
112: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 112: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,

108: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
109: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
110: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
111: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
112: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 113: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

109: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
110: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
111: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
112: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 114: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

110: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
111: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
112: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 115: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

111: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
112: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 116: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

112: ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 117: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

113: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 118: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

114: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 119: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

115: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 120: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

116: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 121: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

117: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 122: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

118: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 123: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,

119: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 124: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,

120: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 125: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,

121: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
129: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 126: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,

122: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
129: CREATION_DATE DATE := FND_API.G_MISS_DATE,
130: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 127: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,

123: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
129: CREATION_DATE DATE := FND_API.G_MISS_DATE,
130: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
131: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 128: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

124: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
129: CREATION_DATE DATE := FND_API.G_MISS_DATE,
130: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
131: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
132: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

Line 129: CREATION_DATE DATE := FND_API.G_MISS_DATE,

125: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
129: CREATION_DATE DATE := FND_API.G_MISS_DATE,
130: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
131: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
132: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
133: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 130: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

126: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
129: CREATION_DATE DATE := FND_API.G_MISS_DATE,
130: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
131: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
132: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
133: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
134: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 131: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

127: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
129: CREATION_DATE DATE := FND_API.G_MISS_DATE,
130: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
131: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
132: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
133: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
134: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 132: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

128: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
129: CREATION_DATE DATE := FND_API.G_MISS_DATE,
130: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
131: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
132: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
133: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
134: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 133: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR

129: CREATION_DATE DATE := FND_API.G_MISS_DATE,
130: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
131: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
132: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
133: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
134: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 134: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR

130: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
131: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
132: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
133: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
134: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM

Line 135: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR

131: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
132: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
133: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
134: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
139: , ORG_ID NUMBER := FND_API.G_MISS_NUM

Line 136: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR

132: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
133: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
134: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
139: , ORG_ID NUMBER := FND_API.G_MISS_NUM
140: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM

Line 137: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR

133: , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
134: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
139: , ORG_ID NUMBER := FND_API.G_MISS_NUM
140: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
141: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR

Line 138: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM

134: , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
135: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
139: , ORG_ID NUMBER := FND_API.G_MISS_NUM
140: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
141: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
142: );

Line 139: , ORG_ID NUMBER := FND_API.G_MISS_NUM

135: , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
136: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
139: , ORG_ID NUMBER := FND_API.G_MISS_NUM
140: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
141: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
142: );
143:

Line 140: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM

136: , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
137: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
139: , ORG_ID NUMBER := FND_API.G_MISS_NUM
140: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
141: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
142: );
143:
144: G_MISS_writeoffs_REC writeoffs_Rec_Type;

Line 141: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR

137: , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
138: , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
139: , ORG_ID NUMBER := FND_API.G_MISS_NUM
140: , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
141: , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
142: );
143:
144: G_MISS_writeoffs_REC writeoffs_Rec_Type;
145: TYPE writeoffs_Tbl_Type IS TABLE OF writeoffs_Rec_Type

Line 158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

154: -- Pre-Req :
155: -- Parameters:
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- P_writeoffs_Rec IN writeoffs_Rec_Type Required
162: --

Line 159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

155: -- Parameters:
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- P_writeoffs_Rec IN writeoffs_Rec_Type Required
162: --
163: -- OUT:

Line 160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- P_writeoffs_Rec IN writeoffs_Rec_Type Required
162: --
163: -- OUT:
164: -- x_return_status OUT NOCOPY VARCHAR2

Line 172: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

168: -- End of Comments
169: --
170: PROCEDURE Create_writeoffs(
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_writeoffs_Rec IN writeoffs_Rec_Type := G_MISS_writeoffs_REC,
176: X_WRITEOFF_ID OUT NOCOPY NUMBER,

Line 173: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

169: --
170: PROCEDURE Create_writeoffs(
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_writeoffs_Rec IN writeoffs_Rec_Type := G_MISS_writeoffs_REC,
176: X_WRITEOFF_ID OUT NOCOPY NUMBER,
177: X_Return_Status OUT NOCOPY VARCHAR2,

Line 174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

170: PROCEDURE Create_writeoffs(
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_writeoffs_Rec IN writeoffs_Rec_Type := G_MISS_writeoffs_REC,
176: X_WRITEOFF_ID OUT NOCOPY NUMBER,
177: X_Return_Status OUT NOCOPY VARCHAR2,
178: X_Msg_Count OUT NOCOPY NUMBER,

Line 191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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_writeoffs_Rec IN writeoffs_Rec_Type Required
195: --

Line 192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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_writeoffs_Rec IN writeoffs_Rec_Type Required
195: --
196: -- OUT:

Line 193: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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_writeoffs_Rec IN writeoffs_Rec_Type Required
195: --
196: -- OUT:
197: -- x_return_status OUT NOCOPY VARCHAR2

Line 206: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

202: -- End of Comments
203: --
204: PROCEDURE Update_writeoffs(
205: P_Api_Version_Number IN NUMBER,
206: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
207: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: P_writeoffs_Rec IN writeoffs_Rec_Type,
210: X_Return_Status OUT NOCOPY VARCHAR2,

Line 207: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

203: --
204: PROCEDURE Update_writeoffs(
205: P_Api_Version_Number IN NUMBER,
206: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
207: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: P_writeoffs_Rec IN writeoffs_Rec_Type,
210: X_Return_Status OUT NOCOPY VARCHAR2,
211: X_Msg_Count OUT NOCOPY NUMBER,

Line 208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

204: PROCEDURE Update_writeoffs(
205: P_Api_Version_Number IN NUMBER,
206: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
207: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: P_writeoffs_Rec IN writeoffs_Rec_Type,
210: X_Return_Status OUT NOCOPY VARCHAR2,
211: X_Msg_Count OUT NOCOPY NUMBER,
212: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 225: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

221: -- Pre-Req :
222: -- Parameters:
223: -- IN
224: -- p_api_version_number IN NUMBER Required
225: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
226: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
228: -- P_writeoff_id IN NUMBER required
229: --

Line 226: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

222: -- Parameters:
223: -- IN
224: -- p_api_version_number IN NUMBER Required
225: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
226: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
228: -- P_writeoff_id IN NUMBER required
229: --
230: -- OUT:

Line 227: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

223: -- IN
224: -- p_api_version_number IN NUMBER Required
225: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
226: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
228: -- P_writeoff_id IN NUMBER required
229: --
230: -- OUT:
231: -- x_return_status OUT NOCOPY VARCHAR2

Line 242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

238: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
239: -- The Master delete procedure may not be needed depends on different business requirements.
240: PROCEDURE Delete_writeoffs(
241: P_Api_Version_Number IN NUMBER,
242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: P_writeoff_id IN NUMBER,
246: X_Return_Status OUT NOCOPY VARCHAR2,

Line 243: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

239: -- The Master delete procedure may not be needed depends on different business requirements.
240: PROCEDURE Delete_writeoffs(
241: P_Api_Version_Number IN NUMBER,
242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: P_writeoff_id IN NUMBER,
246: X_Return_Status OUT NOCOPY VARCHAR2,
247: X_Msg_Count OUT NOCOPY NUMBER,

Line 244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

240: PROCEDURE Delete_writeoffs(
241: P_Api_Version_Number IN NUMBER,
242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: P_writeoff_id IN NUMBER,
246: X_Return_Status OUT NOCOPY VARCHAR2,
247: X_Msg_Count OUT NOCOPY NUMBER,
248: X_Msg_Data OUT NOCOPY VARCHAR2