APPS.AHL_WARRANTY_UTILS_PVT dependencies on DUAL

Line 186: --Calculate Expiration Dates for individual Counters associated with this contract.

182: l_user_id := to_number(fnd_global.USER_ID);
183: l_login_id := to_number(fnd_global.LOGIN_ID);
184:
185:
186: --Calculate Expiration Dates for individual Counters associated with this contract.
187: rec_i := 0;
188: l_warranty_counter_tbl.DELETE;
189:
190: FOR counter_rec in get_counter_details(l_warranty_contract_id)

Line 948: SELECT fnd_attached_documents_s.NEXTVAL into l_attch_doc_id from dual;

944: END IF;
945:
946: CLOSE document_csr;
947:
948: SELECT fnd_attached_documents_s.NEXTVAL into l_attch_doc_id from dual;
949:
950: -- if datatype_id = 6 X_Media_ID will be returned after inserting into fnd_documents only if we pass X_MEdia_ID as NULL,
951: --And we will need to explicitly insert data in fnd_lobs
952: l_data_type := document_rec.datatype_id;