DBA Data[Home] [Help]

APPS.OKC_REP_CLOSEOUT_PVT dependencies on OKC_IMP_RECORD_TYPES

Line 88: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

84: x_qa_return_status OUT NOCOPY VARCHAR2,
85: x_sequence_id OUT NOCOPY NUMBER);
86:
87: PROCEDURE Activate_tasks_closeout(p_api_version IN NUMBER,
88: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
89: p_physical_completion_date IN DATE ,
90: p_init_msg_list IN VARCHAR2,
91: p_commit IN VARCHAR2,
92: x_task_status OUT NOCOPY VARCHAR2,

Line 104: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

100: The relation of parent document which is obtained in p_document_rec is stored in the okc_rep_contract_usages table
101: */
102:
103: Procedure create_contract(p_api_version IN NUMBER,
104: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
105: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
106: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
107: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type ,
108: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type ,

Line 105: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

101: */
102:
103: Procedure create_contract(p_api_version IN NUMBER,
104: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
105: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
106: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
107: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type ,
108: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type ,
109: p_commit IN VARCHAR2 := fnd_api.g_false,

Line 106: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,

102:
103: Procedure create_contract(p_api_version IN NUMBER,
104: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
105: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
106: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
107: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type ,
108: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type ,
109: p_commit IN VARCHAR2 := fnd_api.g_false,
110: x_msg_data OUT NOCOPY VARCHAR2,

Line 107: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type ,

103: Procedure create_contract(p_api_version IN NUMBER,
104: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
105: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
106: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
107: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type ,
108: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type ,
109: p_commit IN VARCHAR2 := fnd_api.g_false,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,

Line 108: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type ,

104: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
105: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
106: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
107: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type ,
108: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type ,
109: p_commit IN VARCHAR2 := fnd_api.g_false,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_return_status OUT NOCOPY VARCHAR2

Line 120: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

116: Deletes the Contract for the given document type.
117: */
118:
119: Procedure delete_contract(p_api_version IN NUMBER,
120: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
121: p_contract_type IN VARCHAR2 DEFAULT NULL,
122: p_contract_id IN NUMBER DEFAULT NULL,
123: p_commit IN VARCHAR2 := fnd_api.g_false,
124: x_msg_data OUT NOCOPY VARCHAR2,

Line 137: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

133: The relation of parent document which is obtained in p_document_rec is stored in the okc_rep_contract_usages table
134: */
135:
136: Procedure create_new_contract_version(p_api_version IN NUMBER,
137: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
138: p_contract_type IN VARCHAR2 DEFAULT NULL,
139: p_contract_id IN NUMBER DEFAULT NULL,
140: p_commit IN VARCHAR2 := fnd_api.g_false,
141: x_msg_data OUT NOCOPY VARCHAR2,

Line 147: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

143: x_return_status OUT NOCOPY VARCHAR2
144: );
145:
146: PROCEDURE check_contract_exists(p_api_version IN NUMBER,
147: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
148: x_contract_type IN OUT NOCOPY VARCHAR2 ,
149: x_contract_id IN OUT NOCOPY NUMBER ,
150: x_contract_version_num IN OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,

Line 159: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

155:
156: PROCEDURE validate_closeout_tasks(p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2,
158: p_commit IN VARCHAR2,
159: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_qa_return_status OUT NOCOPY VARCHAR2,

Line 173: p_src_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

169:
170: PROCEDURE copy_set_tasks_to_each_po(p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2,
172: p_commit IN VARCHAR2,
173: p_src_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
174: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
175: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
176: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
177: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

Line 174: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

170: PROCEDURE copy_set_tasks_to_each_po(p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2,
172: p_commit IN VARCHAR2,
173: p_src_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
174: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
175: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
176: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
177: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
178: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

Line 175: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

171: p_init_msg_list IN VARCHAR2,
172: p_commit IN VARCHAR2,
173: p_src_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
174: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
175: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
176: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
177: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
178: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
179: x_msg_data OUT NOCOPY VARCHAR2,

Line 176: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,

172: p_commit IN VARCHAR2,
173: p_src_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
174: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
175: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
176: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
177: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
178: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,

Line 177: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

173: p_src_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
174: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
175: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
176: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
177: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
178: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_return_status OUT NOCOPY VARCHAR2);

Line 178: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

174: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
175: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
176: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
177: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
178: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_return_status OUT NOCOPY VARCHAR2);
182:

Line 185: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

181: x_return_status OUT NOCOPY VARCHAR2);
182:
183: PROCEDURE check_tasks_exists(p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2,
185: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
186: x_del_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_return_status OUT NOCOPY VARCHAR2);