APPS.AP_WEB_ARCHIVE_PURGE_ER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

 l_debug_info := 'Insert into the GT table.';

Line: 19

	 insert into AP_EXP_REPORT_HEADERS_GT
         (report_header_id)
	 (select report_header_id
	 from
	 (
	   select report_header_id
		from ap_expense_report_headers_all
		where source in ('CREDIT CARD', 'SelfService', 'XpenseXpress')
		and trunc(creation_date) < p_source_date
		and expense_status_code = 'PAID'
	   UNION
		-- For Both Pay reports, make sure that the parent report is also paid.
	   select a.report_header_id
		from ap_expense_report_headers_all a,
		     ap_expense_report_headers_all b
		where a.source = 'Both Pay'
		and trunc(a.creation_date) < p_source_date
		and a.expense_status_code = 'PAID'
		and a.bothpay_parent_id = b.report_header_id
		and b.expense_status_code = 'PAID'
		and trunc(b.creation_date) < p_source_date
	 ));

Line: 42

	 insert into AP_EXP_REPORT_HEADERS_GT
         (report_header_id)
	 (select report_header_id
	 from
	 (
	   select report_header_id
		from ap_expense_report_headers_all
		where source in ('CREDIT CARD', 'SelfService', 'XpenseXpress')
		and trunc(creation_date) < p_source_date
		and org_id = p_org_id
		and expense_status_code = 'PAID'
	   UNION
		-- For Both Pay reports, make sure that the parent report is also paid.
	   select a.report_header_id
		from ap_expense_report_headers_all a,
		     ap_expense_report_headers_all b
		where a.source = 'Both Pay'
		and trunc(a.creation_date) < p_source_date
		and a.org_id = p_org_id
		and a.expense_status_code = 'PAID'
		and a.bothpay_parent_id = b.report_header_id
		and b.expense_status_code = 'PAID'
		and trunc(b.creation_date) < p_source_date
	 ));

Line: 71

 l_debug_info := 'Insert into Headers.';

Line: 74

 insert into ap_expense_report_headers_arc (
			ARC_REQ_ID,
			ARCHIVE_DATE,
			REPORT_HEADER_ID,
			EMPLOYEE_ID,
			WEEK_END_DATE,
			CREATION_DATE,
			CREATED_BY,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			VOUCHNO,
			TOTAL,
			VENDOR_ID,
			VENDOR_SITE_ID,
			EXPENSE_CHECK_ADDRESS_FLAG,
			REFERENCE_1,
			REFERENCE_2,
			INVOICE_NUM,
			EXPENSE_REPORT_ID,
			ACCTS_PAY_CODE_COMBINATION_ID,
			SET_OF_BOOKS_ID,
			SOURCE,
			PURGEABLE_FLAG,
			ACCOUNTING_DATE,
			MAXIMUM_AMOUNT_TO_APPLY,
			ADVANCE_INVOICE_TO_APPLY,
			APPLY_ADVANCES_DEFAULT,
			EMPLOYEE_CCID,
			DESCRIPTION,
			REJECT_CODE,
			HOLD_LOOKUP_CODE,
			ATTRIBUTE_CATEGORY,
			ATTRIBUTE1,
			ATTRIBUTE2,
			ATTRIBUTE3,
			ATTRIBUTE4,
			ATTRIBUTE5,
			ATTRIBUTE6,
			ATTRIBUTE7,
			ATTRIBUTE8,
			ATTRIBUTE9,
			ATTRIBUTE10,
			ATTRIBUTE11,
			ATTRIBUTE12,
			ATTRIBUTE13,
			ATTRIBUTE14,
			ATTRIBUTE15,
			DEFAULT_CURRENCY_CODE,
			DEFAULT_EXCHANGE_RATE_TYPE,
			DEFAULT_EXCHANGE_RATE,
			DEFAULT_EXCHANGE_DATE,
			LAST_UPDATE_LOGIN,
			VOUCHER_NUM,
			USSGL_TRANSACTION_CODE,
			USSGL_TRX_CODE_CONTEXT,
			DOC_CATEGORY_CODE,
			AWT_GROUP_ID,
			ORG_ID,
			WORKFLOW_APPROVED_FLAG,
			GLOBAL_ATTRIBUTE_CATEGORY,
			GLOBAL_ATTRIBUTE1,
			GLOBAL_ATTRIBUTE2,
			GLOBAL_ATTRIBUTE3,
			GLOBAL_ATTRIBUTE4,
			GLOBAL_ATTRIBUTE5,
			GLOBAL_ATTRIBUTE6,
			GLOBAL_ATTRIBUTE7,
			GLOBAL_ATTRIBUTE8,
			GLOBAL_ATTRIBUTE9,
			GLOBAL_ATTRIBUTE10,
			GLOBAL_ATTRIBUTE11,
			GLOBAL_ATTRIBUTE12,
			GLOBAL_ATTRIBUTE13,
			GLOBAL_ATTRIBUTE14,
			GLOBAL_ATTRIBUTE15,
			GLOBAL_ATTRIBUTE16,
			GLOBAL_ATTRIBUTE17,
			GLOBAL_ATTRIBUTE18,
			GLOBAL_ATTRIBUTE19,
			GLOBAL_ATTRIBUTE20,
			FLEX_CONCATENATED,
			OVERRIDE_APPROVER_ID,
			PAYMENT_CROSS_RATE_TYPE,
			PAYMENT_CROSS_RATE_DATE,
			PAYMENT_CROSS_RATE,
			PAYMENT_CURRENCY_CODE,
			CORE_WF_STATUS_FLAG,
			PREPAY_APPLY_FLAG,
			PREPAY_NUM,
			PREPAY_DIST_NUM,
			PREPAY_APPLY_AMOUNT,
			PREPAY_GL_DATE,
			BOTHPAY_PARENT_ID,
			SHORTPAY_PARENT_ID,
			PAID_ON_BEHALF_EMPLOYEE_ID,
			OVERRIDE_APPROVER_NAME,
			AMT_DUE_CCARD_COMPANY,
			AMT_DUE_EMPLOYEE,
			DEFAULT_RECEIPT_CURRENCY_CODE,
			MULTIPLE_CURRENCIES_FLAG,
			EXPENSE_STATUS_CODE,
			EXPENSE_LAST_STATUS_DATE,
			EXPENSE_CURRENT_APPROVER_ID,
			REPORT_FILING_NUMBER,
			RECEIPTS_RECEIVED_DATE,
			AUDIT_CODE,
			REPORT_SUBMITTED_DATE,
			LAST_AUDITED_BY,
			RETURN_REASON_CODE,
			RETURN_INSTRUCTION,
			RECEIPTS_STATUS,
			HOLDING_REPORT_HEADER_ID,
			REQUEST_ID,
			ADVANCES_JUSTIFICATION,
			IMAGE_RECEIPTS_STATUS,
			IMAGE_RECEIPTS_RECEIVED_DATE,
			MISSING_IMG_JUST,
                        OVERDUE_REQUEST_ID
                      )
                     (select p_request_id arc_req_id, sysdate archive_date,
		      	A.REPORT_HEADER_ID,
			EMPLOYEE_ID,
			WEEK_END_DATE,
			CREATION_DATE,
			CREATED_BY,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			VOUCHNO,
			TOTAL,
			VENDOR_ID,
			VENDOR_SITE_ID,
			EXPENSE_CHECK_ADDRESS_FLAG,
			REFERENCE_1,
			REFERENCE_2,
			INVOICE_NUM,
			EXPENSE_REPORT_ID,
			ACCTS_PAY_CODE_COMBINATION_ID,
			SET_OF_BOOKS_ID,
			SOURCE,
			PURGEABLE_FLAG,
			ACCOUNTING_DATE,
			MAXIMUM_AMOUNT_TO_APPLY,
			ADVANCE_INVOICE_TO_APPLY,
			APPLY_ADVANCES_DEFAULT,
			EMPLOYEE_CCID,
			DESCRIPTION,
			REJECT_CODE,
			HOLD_LOOKUP_CODE,
			ATTRIBUTE_CATEGORY,
			ATTRIBUTE1,
			ATTRIBUTE2,
			ATTRIBUTE3,
			ATTRIBUTE4,
			ATTRIBUTE5,
			ATTRIBUTE6,
			ATTRIBUTE7,
			ATTRIBUTE8,
			ATTRIBUTE9,
			ATTRIBUTE10,
			ATTRIBUTE11,
			ATTRIBUTE12,
			ATTRIBUTE13,
			ATTRIBUTE14,
			ATTRIBUTE15,
			DEFAULT_CURRENCY_CODE,
			DEFAULT_EXCHANGE_RATE_TYPE,
			DEFAULT_EXCHANGE_RATE,
			DEFAULT_EXCHANGE_DATE,
			LAST_UPDATE_LOGIN,
			VOUCHER_NUM,
			USSGL_TRANSACTION_CODE,
			USSGL_TRX_CODE_CONTEXT,
			DOC_CATEGORY_CODE,
			AWT_GROUP_ID,
			ORG_ID,
			WORKFLOW_APPROVED_FLAG,
			GLOBAL_ATTRIBUTE_CATEGORY,
			GLOBAL_ATTRIBUTE1,
			GLOBAL_ATTRIBUTE2,
			GLOBAL_ATTRIBUTE3,
			GLOBAL_ATTRIBUTE4,
			GLOBAL_ATTRIBUTE5,
			GLOBAL_ATTRIBUTE6,
			GLOBAL_ATTRIBUTE7,
			GLOBAL_ATTRIBUTE8,
			GLOBAL_ATTRIBUTE9,
			GLOBAL_ATTRIBUTE10,
			GLOBAL_ATTRIBUTE11,
			GLOBAL_ATTRIBUTE12,
			GLOBAL_ATTRIBUTE13,
			GLOBAL_ATTRIBUTE14,
			GLOBAL_ATTRIBUTE15,
			GLOBAL_ATTRIBUTE16,
			GLOBAL_ATTRIBUTE17,
			GLOBAL_ATTRIBUTE18,
			GLOBAL_ATTRIBUTE19,
			GLOBAL_ATTRIBUTE20,
			FLEX_CONCATENATED,
			OVERRIDE_APPROVER_ID,
			PAYMENT_CROSS_RATE_TYPE,
			PAYMENT_CROSS_RATE_DATE,
			PAYMENT_CROSS_RATE,
			PAYMENT_CURRENCY_CODE,
			CORE_WF_STATUS_FLAG,
			PREPAY_APPLY_FLAG,
			PREPAY_NUM,
			PREPAY_DIST_NUM,
			PREPAY_APPLY_AMOUNT,
			PREPAY_GL_DATE,
			BOTHPAY_PARENT_ID,
			SHORTPAY_PARENT_ID,
			PAID_ON_BEHALF_EMPLOYEE_ID,
			OVERRIDE_APPROVER_NAME,
			AMT_DUE_CCARD_COMPANY,
			AMT_DUE_EMPLOYEE,
			DEFAULT_RECEIPT_CURRENCY_CODE,
			MULTIPLE_CURRENCIES_FLAG,
			EXPENSE_STATUS_CODE,
			EXPENSE_LAST_STATUS_DATE,
			EXPENSE_CURRENT_APPROVER_ID,
			REPORT_FILING_NUMBER,
			RECEIPTS_RECEIVED_DATE,
			AUDIT_CODE,
			REPORT_SUBMITTED_DATE,
			LAST_AUDITED_BY,
			RETURN_REASON_CODE,
			RETURN_INSTRUCTION,
			RECEIPTS_STATUS,
			HOLDING_REPORT_HEADER_ID,
			REQUEST_ID,
			ADVANCES_JUSTIFICATION,
			IMAGE_RECEIPTS_STATUS,
			IMAGE_RECEIPTS_RECEIVED_DATE,
			MISSING_IMG_JUST,
			OVERDUE_REQUEST_ID
		      from ap_expense_report_headers_all a, AP_EXP_REPORT_HEADERS_GT gt
		      where gt.report_header_id = a.report_header_id);

Line: 315

 l_debug_info := 'Insert into Lines.';

Line: 317

 insert into ap_expense_report_lines_arc (
			ARC_REQ_ID,
			ARCHIVE_DATE,
			REPORT_HEADER_ID,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			CODE_COMBINATION_ID,
			ITEM_DESCRIPTION,
			SET_OF_BOOKS_ID,
			AMOUNT,
			ATTRIBUTE_CATEGORY,
			ATTRIBUTE1,
			ATTRIBUTE2,
			ATTRIBUTE3,
			ATTRIBUTE4,
			ATTRIBUTE5,
			ATTRIBUTE6,
			ATTRIBUTE7,
			ATTRIBUTE8,
			ATTRIBUTE9,
			ATTRIBUTE10,
			ATTRIBUTE11,
			ATTRIBUTE12,
			ATTRIBUTE13,
			ATTRIBUTE14,
			ATTRIBUTE15,
			CURRENCY_CODE,
			EXCHANGE_RATE_TYPE,
			EXCHANGE_RATE,
			EXCHANGE_DATE,
			VAT_CODE,
			LINE_TYPE_LOOKUP_CODE,
			LAST_UPDATE_LOGIN,
			CREATION_DATE,
			CREATED_BY,
			STAT_AMOUNT,
			USSGL_TRANSACTION_CODE,
			USSGL_TRX_CODE_CONTEXT,
			PROJECT_ACCOUNTING_CONTEXT,
			PROJECT_ID,
			TASK_ID,
			EXPENDITURE_ORGANIZATION_ID,
			EXPENDITURE_TYPE,
			EXPENDITURE_ITEM_DATE,
			PA_QUANTITY,
			DISTRIBUTION_LINE_NUMBER,
			REFERENCE_1,
			REFERENCE_2,
			AWT_GROUP_ID,
			ORG_ID,
			RECEIPT_VERIFIED_FLAG,
			JUSTIFICATION_REQUIRED_FLAG,
			RECEIPT_REQUIRED_FLAG,
			GLOBAL_ATTRIBUTE_CATEGORY,
			GLOBAL_ATTRIBUTE1,
			GLOBAL_ATTRIBUTE2,
			GLOBAL_ATTRIBUTE3,
			GLOBAL_ATTRIBUTE4,
			GLOBAL_ATTRIBUTE5,
			GLOBAL_ATTRIBUTE6,
			GLOBAL_ATTRIBUTE7,
			GLOBAL_ATTRIBUTE8,
			GLOBAL_ATTRIBUTE9,
			GLOBAL_ATTRIBUTE10,
			GLOBAL_ATTRIBUTE11,
			GLOBAL_ATTRIBUTE12,
			GLOBAL_ATTRIBUTE13,
			GLOBAL_ATTRIBUTE14,
			GLOBAL_ATTRIBUTE15,
			GLOBAL_ATTRIBUTE16,
			GLOBAL_ATTRIBUTE17,
			GLOBAL_ATTRIBUTE18,
			GLOBAL_ATTRIBUTE19,
			GLOBAL_ATTRIBUTE20,
			RECEIPT_MISSING_FLAG,
			JUSTIFICATION,
			EXPENSE_GROUP,
			START_EXPENSE_DATE,
			END_EXPENSE_DATE,
			RECEIPT_CURRENCY_CODE,
			RECEIPT_CONVERSION_RATE,
			DAILY_AMOUNT,
			RECEIPT_CURRENCY_AMOUNT,
			WEB_PARAMETER_ID,
			AMOUNT_INCLUDES_TAX_FLAG,
			ADJUSTMENT_REASON,
			POLICY_SHORTPAY_FLAG,
			AWARD_ID,
			CREDIT_CARD_TRX_ID,
			MERCHANT_DOCUMENT_NUMBER,
			MERCHANT_NAME,
			MERCHANT_REFERENCE,
			MERCHANT_TAX_REG_NUMBER,
			MERCHANT_TAXPAYER_ID,
			COUNTRY_OF_SUPPLY,
			TAX_CODE_OVERRIDE_FLAG,
			TAX_CODE_ID,
			ITEMIZE_ID,
			PROJECT_NAME,
			TASK_NAME,
			COMPANY_PREPAID_INVOICE_ID,
			PA_INTERFACED_FLAG,
			PROJECT_NUMBER,
			TASK_NUMBER,
			AWARD_NUMBER,
			VEHICLE_CATEGORY_CODE,
			VEHICLE_TYPE,
			FUEL_TYPE,
			NUMBER_PEOPLE,
			DAILY_DISTANCE,
			DISTANCE_UNIT_CODE,
			AVG_MILEAGE_RATE,
			DESTINATION_FROM,
			DESTINATION_TO,
			TRIP_DISTANCE,
			LICENSE_PLATE_NUMBER,
			MILEAGE_RATE_ADJUSTED_FLAG,
			LOCATION_ID,
			NUM_PDM_DAYS1,
			NUM_PDM_DAYS2,
			NUM_PDM_DAYS3,
			PER_DIEM_RATE1,
			PER_DIEM_RATE2,
			PER_DIEM_RATE3,
			DEDUCTION_ADDITION_AMT1,
			DEDUCTION_ADDITION_AMT2,
			DEDUCTION_ADDITION_AMT3,
			NUM_FREE_BREAKFASTS1,
			NUM_FREE_LUNCHES1,
			NUM_FREE_DINNERS1,
			NUM_FREE_ACCOMMODATIONS1,
			NUM_FREE_BREAKFASTS2,
			NUM_FREE_LUNCHES2,
			NUM_FREE_DINNERS2,
			NUM_FREE_ACCOMMODATIONS2,
			NUM_FREE_BREAKFASTS3,
			NUM_FREE_LUNCHES3,
			NUM_FREE_DINNERS3,
			NUM_FREE_ACCOMMODATIONS3,
			ATTENDEES,
			NUMBER_ATTENDEES,
			TRAVEL_TYPE,
			TICKET_CLASS_CODE,
			TICKET_NUMBER,
			FLIGHT_NUMBER,
			LOCATION_TO_ID,
			ITEMIZATION_PARENT_ID,
			FLEX_CONCATENATED,
			FUNC_CURRENCY_AMT,
			LOCATION,
			CATEGORY_CODE,
			ADJUSTMENT_REASON_CODE,
			AP_VALIDATION_ERROR,
			SUBMITTED_AMOUNT,
			REPORT_LINE_ID,
			ALLOCATION_REASON,
			ALLOCATION_SPLIT_CODE,
			RATE_PER_PASSENGER,
			PASSENGER_RATE_TYPE,
			PASSENGER_AMOUNT,
			RANGE_LOW,
			RANGE_HIGH,
			UOM_DAYS,
			IMAGE_RECEIPT_REQUIRED_FLAG,
			RECEIPTS_ISSUE,
			ADJUSTMENT_REASON_COPY
                      )
                     (select p_request_id arc_req_id, sysdate archive_date,
			A.REPORT_HEADER_ID,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			CODE_COMBINATION_ID,
			ITEM_DESCRIPTION,
			SET_OF_BOOKS_ID,
			AMOUNT,
			ATTRIBUTE_CATEGORY,
			ATTRIBUTE1,
			ATTRIBUTE2,
			ATTRIBUTE3,
			ATTRIBUTE4,
			ATTRIBUTE5,
			ATTRIBUTE6,
			ATTRIBUTE7,
			ATTRIBUTE8,
			ATTRIBUTE9,
			ATTRIBUTE10,
			ATTRIBUTE11,
			ATTRIBUTE12,
			ATTRIBUTE13,
			ATTRIBUTE14,
			ATTRIBUTE15,
			CURRENCY_CODE,
			EXCHANGE_RATE_TYPE,
			EXCHANGE_RATE,
			EXCHANGE_DATE,
			VAT_CODE,
			LINE_TYPE_LOOKUP_CODE,
			LAST_UPDATE_LOGIN,
			CREATION_DATE,
			CREATED_BY,
			STAT_AMOUNT,
			USSGL_TRANSACTION_CODE,
			USSGL_TRX_CODE_CONTEXT,
			PROJECT_ACCOUNTING_CONTEXT,
			PROJECT_ID,
			TASK_ID,
			EXPENDITURE_ORGANIZATION_ID,
			EXPENDITURE_TYPE,
			EXPENDITURE_ITEM_DATE,
			PA_QUANTITY,
			DISTRIBUTION_LINE_NUMBER,
			REFERENCE_1,
			REFERENCE_2,
			AWT_GROUP_ID,
			ORG_ID,
			RECEIPT_VERIFIED_FLAG,
			JUSTIFICATION_REQUIRED_FLAG,
			RECEIPT_REQUIRED_FLAG,
			GLOBAL_ATTRIBUTE_CATEGORY,
			GLOBAL_ATTRIBUTE1,
			GLOBAL_ATTRIBUTE2,
			GLOBAL_ATTRIBUTE3,
			GLOBAL_ATTRIBUTE4,
			GLOBAL_ATTRIBUTE5,
			GLOBAL_ATTRIBUTE6,
			GLOBAL_ATTRIBUTE7,
			GLOBAL_ATTRIBUTE8,
			GLOBAL_ATTRIBUTE9,
			GLOBAL_ATTRIBUTE10,
			GLOBAL_ATTRIBUTE11,
			GLOBAL_ATTRIBUTE12,
			GLOBAL_ATTRIBUTE13,
			GLOBAL_ATTRIBUTE14,
			GLOBAL_ATTRIBUTE15,
			GLOBAL_ATTRIBUTE16,
			GLOBAL_ATTRIBUTE17,
			GLOBAL_ATTRIBUTE18,
			GLOBAL_ATTRIBUTE19,
			GLOBAL_ATTRIBUTE20,
			RECEIPT_MISSING_FLAG,
			JUSTIFICATION,
			EXPENSE_GROUP,
			START_EXPENSE_DATE,
			END_EXPENSE_DATE,
			RECEIPT_CURRENCY_CODE,
			RECEIPT_CONVERSION_RATE,
			DAILY_AMOUNT,
			RECEIPT_CURRENCY_AMOUNT,
			WEB_PARAMETER_ID,
			AMOUNT_INCLUDES_TAX_FLAG,
			ADJUSTMENT_REASON,
			POLICY_SHORTPAY_FLAG,
			AWARD_ID,
			CREDIT_CARD_TRX_ID,
			MERCHANT_DOCUMENT_NUMBER,
			MERCHANT_NAME,
			MERCHANT_REFERENCE,
			MERCHANT_TAX_REG_NUMBER,
			MERCHANT_TAXPAYER_ID,
			COUNTRY_OF_SUPPLY,
			TAX_CODE_OVERRIDE_FLAG,
			TAX_CODE_ID,
			ITEMIZE_ID,
			PROJECT_NAME,
			TASK_NAME,
			COMPANY_PREPAID_INVOICE_ID,
			PA_INTERFACED_FLAG,
			PROJECT_NUMBER,
			TASK_NUMBER,
			AWARD_NUMBER,
			VEHICLE_CATEGORY_CODE,
			VEHICLE_TYPE,
			FUEL_TYPE,
			NUMBER_PEOPLE,
			DAILY_DISTANCE,
			DISTANCE_UNIT_CODE,
			AVG_MILEAGE_RATE,
			DESTINATION_FROM,
			DESTINATION_TO,
			TRIP_DISTANCE,
			LICENSE_PLATE_NUMBER,
			MILEAGE_RATE_ADJUSTED_FLAG,
			LOCATION_ID,
			NUM_PDM_DAYS1,
			NUM_PDM_DAYS2,
			NUM_PDM_DAYS3,
			PER_DIEM_RATE1,
			PER_DIEM_RATE2,
			PER_DIEM_RATE3,
			DEDUCTION_ADDITION_AMT1,
			DEDUCTION_ADDITION_AMT2,
			DEDUCTION_ADDITION_AMT3,
			NUM_FREE_BREAKFASTS1,
			NUM_FREE_LUNCHES1,
			NUM_FREE_DINNERS1,
			NUM_FREE_ACCOMMODATIONS1,
			NUM_FREE_BREAKFASTS2,
			NUM_FREE_LUNCHES2,
			NUM_FREE_DINNERS2,
			NUM_FREE_ACCOMMODATIONS2,
			NUM_FREE_BREAKFASTS3,
			NUM_FREE_LUNCHES3,
			NUM_FREE_DINNERS3,
			NUM_FREE_ACCOMMODATIONS3,
			ATTENDEES,
			NUMBER_ATTENDEES,
			TRAVEL_TYPE,
			TICKET_CLASS_CODE,
			TICKET_NUMBER,
			FLIGHT_NUMBER,
			LOCATION_TO_ID,
			ITEMIZATION_PARENT_ID,
			FLEX_CONCATENATED,
			FUNC_CURRENCY_AMT,
			LOCATION,
			CATEGORY_CODE,
			ADJUSTMENT_REASON_CODE,
			AP_VALIDATION_ERROR,
			SUBMITTED_AMOUNT,
			REPORT_LINE_ID,
			ALLOCATION_REASON,
			ALLOCATION_SPLIT_CODE,
			RATE_PER_PASSENGER,
			PASSENGER_RATE_TYPE,
			PASSENGER_AMOUNT,
			RANGE_LOW,
			RANGE_HIGH,
			UOM_DAYS,
			IMAGE_RECEIPT_REQUIRED_FLAG,
			RECEIPTS_ISSUE,
			ADJUSTMENT_REASON_COPY
		      from ap_expense_report_lines_all a, AP_EXP_REPORT_HEADERS_GT gt
		      where gt.report_header_id = a.report_header_id);

Line: 655

 l_debug_info := 'Insert into Dists.';

Line: 658

 insert into ap_exp_report_dists_arc (
			ARC_REQ_ID,
			ARCHIVE_DATE,
			REPORT_HEADER_ID,
			REPORT_LINE_ID,
			REPORT_DISTRIBUTION_ID,
			ORG_ID,
			SEQUENCE_NUM,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			CREATION_DATE,
			CREATED_BY,
			LAST_UPDATE_LOGIN,
			CODE_COMBINATION_ID,
			SEGMENT1,
			SEGMENT2,
			SEGMENT3,
			SEGMENT4,
			SEGMENT5,
			SEGMENT6,
			SEGMENT7,
			SEGMENT8,
			SEGMENT9,
			SEGMENT10,
			SEGMENT11,
			SEGMENT12,
			SEGMENT13,
			SEGMENT14,
			SEGMENT15,
			SEGMENT16,
			SEGMENT17,
			SEGMENT18,
			SEGMENT19,
			SEGMENT20,
			SEGMENT21,
			SEGMENT22,
			SEGMENT23,
			SEGMENT24,
			SEGMENT25,
			SEGMENT26,
			SEGMENT27,
			SEGMENT28,
			SEGMENT29,
			SEGMENT30,
			PREPARER_MODIFIED_FLAG,
			AMOUNT,
			PROJECT_ID,
			TASK_ID,
			AWARD_ID,
			EXPENDITURE_ORGANIZATION_ID,
			COST_CENTER,
			RECEIPT_CURRENCY_CODE,
			RECEIPT_CONVERSION_RATE,
			RECEIPT_CURRENCY_AMOUNT,
			WEB_PARAMETER_ID
                      )
                     (select p_request_id arc_req_id, sysdate archive_date,
			A.REPORT_HEADER_ID,
			REPORT_LINE_ID,
			REPORT_DISTRIBUTION_ID,
			ORG_ID,
			SEQUENCE_NUM,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			CREATION_DATE,
			CREATED_BY,
			LAST_UPDATE_LOGIN,
			CODE_COMBINATION_ID,
			SEGMENT1,
			SEGMENT2,
			SEGMENT3,
			SEGMENT4,
			SEGMENT5,
			SEGMENT6,
			SEGMENT7,
			SEGMENT8,
			SEGMENT9,
			SEGMENT10,
			SEGMENT11,
			SEGMENT12,
			SEGMENT13,
			SEGMENT14,
			SEGMENT15,
			SEGMENT16,
			SEGMENT17,
			SEGMENT18,
			SEGMENT19,
			SEGMENT20,
			SEGMENT21,
			SEGMENT22,
			SEGMENT23,
			SEGMENT24,
			SEGMENT25,
			SEGMENT26,
			SEGMENT27,
			SEGMENT28,
			SEGMENT29,
			SEGMENT30,
			PREPARER_MODIFIED_FLAG,
			AMOUNT,
			PROJECT_ID,
			TASK_ID,
			AWARD_ID,
			EXPENDITURE_ORGANIZATION_ID,
			COST_CENTER,
			RECEIPT_CURRENCY_CODE,
			RECEIPT_CONVERSION_RATE,
			RECEIPT_CURRENCY_AMOUNT,
			WEB_PARAMETER_ID
		      from ap_exp_report_dists_all a, AP_EXP_REPORT_HEADERS_GT gt
		      where gt.report_header_id = a.report_header_id);

Line: 774

 l_debug_info := 'Insert into CC Transactions.';

Line: 777

 insert into ap_credit_card_trxns_arc (
			ARC_REQ_ID,
			ARCHIVE_DATE,
			TRX_ID,
			VALIDATE_CODE,
			CARD_PROGRAM_ID,
			EXPENSED_AMOUNT,
			CARD_NUMBER,
			REFERENCE_NUMBER,
			TRANSACTION_TYPE,
			TRANSACTION_DATE,
			TRANSACTION_AMOUNT,
			DEBIT_FLAG,
			BILLED_DATE,
			BILLED_AMOUNT,
			BILLED_DECIMAL,
			BILLED_CURRENCY_CODE,
			POSTED_DATE,
			POSTED_AMOUNT,
			POSTED_DECIMAL,
			POSTED_CURRENCY_CODE,
			CURRENCY_CONVERSION_EXPONENT,
			CURRENCY_CONVERSION_RATE,
			MIS_INDUSTRY_CODE,
			SIC_CODE,
			MERCHANT_TAX_ID,
			MERCHANT_REFERENCE,
			MERCHANT_NAME1,
			MERCHANT_NAME2,
			MERCHANT_ADDRESS1,
			MERCHANT_ADDRESS2,
			MERCHANT_ADDRESS3,
			MERCHANT_ADDRESS4,
			MERCHANT_CITY,
			MERCHANT_PROVINCE_STATE,
			MERCHANT_POSTAL_CODE,
			MERCHANT_COUNTRY,
			TOTAL_TAX,
			LOCAL_TAX,
			NATIONAL_TAX,
			OTHER_TAX,
			ORG_ID,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			LAST_UPDATE_LOGIN,
			CREATION_DATE,
			CREATED_BY,
			FOLIO_TYPE,
			ATM_CASH_ADVANCE,
			ATM_TRANSACTION_DATE,
			ATM_FEE_AMOUNT,
			ATM_TYPE,
			ATM_ID,
			ATM_NETWORK_ID,
			RESTAURANT_FOOD_AMOUNT,
			RESTAURANT_BEVERAGE_AMOUNT,
			RESTAURANT_TIP_AMOUNT,
			CAR_RENTAL_DATE,
			CAR_RETURN_DATE,
			CAR_RENTAL_LOCATION,
			CAR_RENTAL_STATE,
			CAR_RETURN_LOCATION,
			CAR_RETURN_STATE,
			CAR_RENTER_NAME,
			CAR_RENTAL_DAYS,
			CAR_RENTAL_AGREEMENT_NUMBER,
			CAR_CLASS,
			CAR_TOTAL_MILEAGE,
			CAR_GAS_AMOUNT,
			CAR_INSURANCE_AMOUNT,
			CAR_MILEAGE_AMOUNT,
			CAR_DAILY_RATE,
			HOTEL_ARRIVAL_DATE,
			HOTEL_DEPART_DATE,
			HOTEL_CHARGE_DESC,
			HOTEL_GUEST_NAME,
			HOTEL_STAY_DURATION,
			HOTEL_ROOM_RATE,
			HOTEL_NO_SHOW_FLAG,
			HOTEL_ROOM_AMOUNT,
			HOTEL_TELEPHONE_AMOUNT,
			HOTEL_ROOM_TAX,
			HOTEL_BAR_AMOUNT,
			HOTEL_MOVIE_AMOUNT,
			HOTEL_GIFT_SHOP_AMOUNT,
			HOTEL_LAUNDRY_AMOUNT,
			HOTEL_HEALTH_AMOUNT,
			HOTEL_RESTAURANT_AMOUNT,
			HOTEL_BUSINESS_AMOUNT,
			HOTEL_PARKING_AMOUNT,
			HOTEL_ROOM_SERVICE_AMOUNT,
			HOTEL_TIP_AMOUNT,
			HOTEL_MISC_AMOUNT,
			HOTEL_CITY,
			HOTEL_STATE,
			HOTEL_FOLIO_NUMBER,
			HOTEL_ROOM_TYPE,
			AIR_DEPARTURE_DATE,
			AIR_DEPARTURE_CITY,
			AIR_ROUTING,
			AIR_ARRIVAL_CITY,
			AIR_STOPOVER_FLAG,
			AIR_BASE_FARE_AMOUNT,
			AIR_FARE_BASIS_CODE,
			AIR_SERVICE_CLASS,
			AIR_CARRIER_ABBREVIATION,
			AIR_CARRIER_CODE,
			AIR_TICKET_ISSUER,
			AIR_ISSUER_CITY,
			AIR_PASSENGER_NAME,
			AIR_REFUND_TICKET_NUMBER,
			AIR_EXCHANGED_TICKET_NUMBER,
			AIR_AGENCY_NUMBER,
			AIR_TICKET_NUMBER,
			FINANCIAL_CATEGORY,
			PAYMENT_FLAG,
			RECORD_TYPE,
			MERCHANT_ACTIVITY,
			CATEGORY,
			REPORT_HEADER_ID,
			EXPENSE_STATUS,
			COMPANY_PREPAID_INVOICE_ID,
			INACTIVE_EMP_WF_ITEM_KEY,
			LOCATION_ID,
			REQUEST_ID,
			MERCHANT_COUNTRY_CODE,
			DISPUTE_DATE,
			PAYMENT_DUE_FROM_CODE,
			TRX_AVAILABLE_DATE,
			CARD_ACCEPTOR_ID,
			TRXN_DETAIL_FLAG,
			CARD_ID,
			DESCRIPTION,
			COMPANY_NUMBER,
			MARKET_CODE,
			VALIDATE_REQUEST_ID
                      )
                     (select p_request_id arc_req_id, sysdate archive_date,
		      TRX_ID,
			VALIDATE_CODE,
			CARD_PROGRAM_ID,
			EXPENSED_AMOUNT,
			CARD_NUMBER,
			REFERENCE_NUMBER,
			TRANSACTION_TYPE,
			TRANSACTION_DATE,
			TRANSACTION_AMOUNT,
			DEBIT_FLAG,
			BILLED_DATE,
			BILLED_AMOUNT,
			BILLED_DECIMAL,
			BILLED_CURRENCY_CODE,
			POSTED_DATE,
			POSTED_AMOUNT,
			POSTED_DECIMAL,
			POSTED_CURRENCY_CODE,
			CURRENCY_CONVERSION_EXPONENT,
			CURRENCY_CONVERSION_RATE,
			MIS_INDUSTRY_CODE,
			SIC_CODE,
			MERCHANT_TAX_ID,
			MERCHANT_REFERENCE,
			MERCHANT_NAME1,
			MERCHANT_NAME2,
			MERCHANT_ADDRESS1,
			MERCHANT_ADDRESS2,
			MERCHANT_ADDRESS3,
			MERCHANT_ADDRESS4,
			MERCHANT_CITY,
			MERCHANT_PROVINCE_STATE,
			MERCHANT_POSTAL_CODE,
			MERCHANT_COUNTRY,
			TOTAL_TAX,
			LOCAL_TAX,
			NATIONAL_TAX,
			OTHER_TAX,
			ORG_ID,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			LAST_UPDATE_LOGIN,
			CREATION_DATE,
			CREATED_BY,
			FOLIO_TYPE,
			ATM_CASH_ADVANCE,
			ATM_TRANSACTION_DATE,
			ATM_FEE_AMOUNT,
			ATM_TYPE,
			ATM_ID,
			ATM_NETWORK_ID,
			RESTAURANT_FOOD_AMOUNT,
			RESTAURANT_BEVERAGE_AMOUNT,
			RESTAURANT_TIP_AMOUNT,
			CAR_RENTAL_DATE,
			CAR_RETURN_DATE,
			CAR_RENTAL_LOCATION,
			CAR_RENTAL_STATE,
			CAR_RETURN_LOCATION,
			CAR_RETURN_STATE,
			CAR_RENTER_NAME,
			CAR_RENTAL_DAYS,
			CAR_RENTAL_AGREEMENT_NUMBER,
			CAR_CLASS,
			CAR_TOTAL_MILEAGE,
			CAR_GAS_AMOUNT,
			CAR_INSURANCE_AMOUNT,
			CAR_MILEAGE_AMOUNT,
			CAR_DAILY_RATE,
			HOTEL_ARRIVAL_DATE,
			HOTEL_DEPART_DATE,
			HOTEL_CHARGE_DESC,
			HOTEL_GUEST_NAME,
			HOTEL_STAY_DURATION,
			HOTEL_ROOM_RATE,
			HOTEL_NO_SHOW_FLAG,
			HOTEL_ROOM_AMOUNT,
			HOTEL_TELEPHONE_AMOUNT,
			HOTEL_ROOM_TAX,
			HOTEL_BAR_AMOUNT,
			HOTEL_MOVIE_AMOUNT,
			HOTEL_GIFT_SHOP_AMOUNT,
			HOTEL_LAUNDRY_AMOUNT,
			HOTEL_HEALTH_AMOUNT,
			HOTEL_RESTAURANT_AMOUNT,
			HOTEL_BUSINESS_AMOUNT,
			HOTEL_PARKING_AMOUNT,
			HOTEL_ROOM_SERVICE_AMOUNT,
			HOTEL_TIP_AMOUNT,
			HOTEL_MISC_AMOUNT,
			HOTEL_CITY,
			HOTEL_STATE,
			HOTEL_FOLIO_NUMBER,
			HOTEL_ROOM_TYPE,
			AIR_DEPARTURE_DATE,
			AIR_DEPARTURE_CITY,
			AIR_ROUTING,
			AIR_ARRIVAL_CITY,
			AIR_STOPOVER_FLAG,
			AIR_BASE_FARE_AMOUNT,
			AIR_FARE_BASIS_CODE,
			AIR_SERVICE_CLASS,
			AIR_CARRIER_ABBREVIATION,
			AIR_CARRIER_CODE,
			AIR_TICKET_ISSUER,
			AIR_ISSUER_CITY,
			AIR_PASSENGER_NAME,
			AIR_REFUND_TICKET_NUMBER,
			AIR_EXCHANGED_TICKET_NUMBER,
			AIR_AGENCY_NUMBER,
			AIR_TICKET_NUMBER,
			FINANCIAL_CATEGORY,
			PAYMENT_FLAG,
			RECORD_TYPE,
			MERCHANT_ACTIVITY,
			CATEGORY,
			A.REPORT_HEADER_ID,
			EXPENSE_STATUS,
			COMPANY_PREPAID_INVOICE_ID,
			INACTIVE_EMP_WF_ITEM_KEY,
			LOCATION_ID,
			REQUEST_ID,
			MERCHANT_COUNTRY_CODE,
			DISPUTE_DATE,
			PAYMENT_DUE_FROM_CODE,
			TRX_AVAILABLE_DATE,
			CARD_ACCEPTOR_ID,
			TRXN_DETAIL_FLAG,
			CARD_ID,
			DESCRIPTION,
			COMPANY_NUMBER,
			MARKET_CODE,
			VALIDATE_REQUEST_ID
		      from ap_credit_card_trxns_all a, AP_EXP_REPORT_HEADERS_GT gt
		      where gt.report_header_id = a.report_header_id);

Line: 1054

 l_debug_info := 'Insert into CC Transaction Details.';

Line: 1057

 insert into ap_cc_trx_details_arc (
			ARC_REQ_ID,
			ARCHIVE_DATE,
			TRX_DETAIL_ID,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			LAST_UPDATE_LOGIN,
			CREATION_DATE,
			CREATED_BY,
			TRX_ID,
			TRANSACTION_AMOUNT,
			BILLED_AMOUNT,
			EXT_FOLIO_TYPE,
			FOLIO_TYPE,
			ITEM_SEQ_NUMBER,
			ITEM_DESCRIPTION,
			TRANSACTION_DATE
		      )
                     (select p_request_id arc_req_id, sysdate archive_date,
		        A.TRX_DETAIL_ID,
			A.LAST_UPDATE_DATE,
			A.LAST_UPDATED_BY,
			A.LAST_UPDATE_LOGIN,
			A.CREATION_DATE,
			A.CREATED_BY,
			A.TRX_ID,
			A.TRANSACTION_AMOUNT,
			A.BILLED_AMOUNT,
			A.EXT_FOLIO_TYPE,
			A.FOLIO_TYPE,
			A.ITEM_SEQ_NUMBER,
			A.ITEM_DESCRIPTION,
			A.TRANSACTION_DATE
		      from ap_cc_trx_details a, ap_credit_card_trxns_all b, AP_EXP_REPORT_HEADERS_GT gt
		      where gt.report_header_id = b.report_header_id
		      and a.trx_id = b.trx_id);

Line: 1098

 l_debug_info := 'Insert into Add On Mileage Rates.';

Line: 1101

 insert into oie_addon_mileage_rates_arc (
			ARC_REQ_ID,
			ARCHIVE_DATE,
			REPORT_LINE_ID,
			ADDON_RATE_TYPE,
			MILEAGE_RATE,
			MILEAGE_AMOUNT,
			MILEAGE_PAYROLL_TAX_CODE_ID,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			LAST_UPDATE_LOGIN,
			CREATED_BY,
			CREATION_DATE
                      )
                     (select p_request_id arc_req_id, sysdate archive_date,
	   	        A.REPORT_LINE_ID,
			A.ADDON_RATE_TYPE,
			A.MILEAGE_RATE,
			A.MILEAGE_AMOUNT,
			A.MILEAGE_PAYROLL_TAX_CODE_ID,
			A.LAST_UPDATE_DATE,
			A.LAST_UPDATED_BY,
			A.LAST_UPDATE_LOGIN,
			A.CREATED_BY,
			A.CREATION_DATE
		      from oie_addon_mileage_rates a, AP_EXP_REPORT_HEADERS_GT gt,
		      ap_expense_report_lines_all b
		      where gt.report_header_id = b.report_header_id
		      and a.report_line_id = b.report_line_id);

Line: 1135

 l_debug_info := 'Insert into Perdiem Daily Breakups.';

Line: 1138

 insert into oie_pdm_daily_breakups_arc (
			ARC_REQ_ID,
			ARCHIVE_DATE,
			PDM_DAILY_BREAKUP_ID,
			REPORT_LINE_ID,
			START_DATE,
			END_DATE,
			AMOUNT,
			NUMBER_OF_MEALS,
			MEALS_AMOUNT,
			BREAKFAST_FLAG,
			LUNCH_FLAG,
			DINNER_FLAG,
			ACCOMMODATION_AMOUNT,
			ACCOMMODATION_FLAG,
			HOTEL_NAME,
			NIGHT_RATE_TYPE,
			NIGHT_RATE_AMOUNT,
			PDM_RATE,
			PDM_DESTINATION_ID,
			RATE_TYPE_CODE,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			LAST_UPDATE_LOGIN,
			CREATED_BY,
			CREATION_DATE,
			SCHEDULE_TYPE_CODE,
			CUST_MEALS_AMOUNT,
			CUST_ACCOMMODATION_AMOUNT,
			CUST_NIGHT_RATE_AMOUNT,
			CUST_PDM_RATE
                      )
                     (select p_request_id arc_req_id, sysdate archive_date,
		        A.PDM_DAILY_BREAKUP_ID,
			A.REPORT_LINE_ID,
			A.START_DATE,
			A.END_DATE,
			A.AMOUNT,
			A.NUMBER_OF_MEALS,
			A.MEALS_AMOUNT,
			A.BREAKFAST_FLAG,
			A.LUNCH_FLAG,
			A.DINNER_FLAG,
			A.ACCOMMODATION_AMOUNT,
			A.ACCOMMODATION_FLAG,
			A.HOTEL_NAME,
			A.NIGHT_RATE_TYPE,
			A.NIGHT_RATE_AMOUNT,
			A.PDM_RATE,
			A.PDM_DESTINATION_ID,
			A.RATE_TYPE_CODE,
			A.LAST_UPDATE_DATE,
			A.LAST_UPDATED_BY,
			A.LAST_UPDATE_LOGIN,
			A.CREATED_BY,
			A.CREATION_DATE,
			A.SCHEDULE_TYPE_CODE,
			A.CUST_MEALS_AMOUNT,
			A.CUST_ACCOMMODATION_AMOUNT,
			A.CUST_NIGHT_RATE_AMOUNT,
			A.CUST_PDM_RATE
		      from oie_pdm_daily_breakups a, AP_EXP_REPORT_HEADERS_GT gt,
		      ap_expense_report_lines_all b
		      where gt.report_header_id = b.report_header_id
		      and a.report_line_id = b.report_line_id);

Line: 1208

 l_debug_info := 'Insert into Perdiem Destinations.';

Line: 1211

 insert into oie_pdm_destinations_arc (
			ARC_REQ_ID,
			ARCHIVE_DATE,
			PDM_DESTINATION_ID,
			REPORT_LINE_ID,
			START_DATE,
			END_DATE,
			LOCATION_ID,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			LAST_UPDATE_LOGIN,
			CREATED_BY,
			CREATION_DATE
                      )
                     (select p_request_id arc_req_id, sysdate archive_date,
	         	A.PDM_DESTINATION_ID,
			A.REPORT_LINE_ID,
			A.START_DATE,
			A.END_DATE,
			A.LOCATION_ID,
			A.LAST_UPDATE_DATE,
			A.LAST_UPDATED_BY,
			A.LAST_UPDATE_LOGIN,
			A.CREATED_BY,
			A.CREATION_DATE
		      from oie_pdm_destinations a, AP_EXP_REPORT_HEADERS_GT gt,
		      ap_expense_report_lines_all b
		      where gt.report_header_id = b.report_header_id
		      and a.report_line_id = b.report_line_id);

Line: 1245

 l_debug_info := 'Insert into OIE Attendees.';

Line: 1248

 insert into oie_attendees_arc (
			ARC_REQ_ID,
			ARCHIVE_DATE,
			ATTENDEE_LINE_ID,
			REPORT_LINE_ID,
			EMPLOYEE_FLAG,
			EMPLOYEE_ID,
			ATTENDEE_TYPE,
			NAME,
			TITLE,
			EMPLOYER,
			EMPLOYER_ADDRESS,
			TAX_ID,
			ORG_ID,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			CREATION_DATE,
			CREATED_BY,
			LAST_UPDATE_LOGIN
                      )
                     (select p_request_id arc_req_id, sysdate archive_date,
		        A.ATTENDEE_LINE_ID,
			A.REPORT_LINE_ID,
			A.EMPLOYEE_FLAG,
			A.EMPLOYEE_ID,
			A.ATTENDEE_TYPE,
			A.NAME,
			A.TITLE,
			A.EMPLOYER,
			A.EMPLOYER_ADDRESS,
			A.TAX_ID,
			A.ORG_ID,
			A.LAST_UPDATE_DATE,
			A.LAST_UPDATED_BY,
			A.CREATION_DATE,
			A.CREATED_BY,
			A.LAST_UPDATE_LOGIN
		      from oie_attendees_all a, AP_EXP_REPORT_HEADERS_GT gt,
		      ap_expense_report_lines_all b
		      where gt.report_header_id = b.report_header_id
		      and a.report_line_id = b.report_line_id);

Line: 1294

 l_debug_info := 'Insert into Audit Reasons.';

Line: 1297

 insert into ap_aud_audit_reasons_arc (
			ARC_REQ_ID,
			ARCHIVE_DATE,
			AUDIT_REASON_ID,
			REPORT_HEADER_ID,
			AUDIT_REASON_CODE,
			CREATION_DATE,
			CREATED_BY,
			LAST_UPDATE_LOGIN,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY
                      )
                     (select p_request_id arc_req_id, sysdate archive_date,
		        A.AUDIT_REASON_ID,
			A.REPORT_HEADER_ID,
			A.AUDIT_REASON_CODE,
			A.CREATION_DATE,
			A.CREATED_BY,
			A.LAST_UPDATE_LOGIN,
			A.LAST_UPDATE_DATE,
			A.LAST_UPDATED_BY
		      from ap_aud_audit_reasons a, AP_EXP_REPORT_HEADERS_GT gt
		      where gt.report_header_id = a.report_header_id);

Line: 1325

 l_debug_info := 'Insert into Violations.';

Line: 1328

 insert into ap_pol_violations_arc (
			ARC_REQ_ID,
			ARCHIVE_DATE,
			REPORT_HEADER_ID,
			DISTRIBUTION_LINE_NUMBER,
			VIOLATION_NUMBER,
			VIOLATION_TYPE,
			ALLOWABLE_AMOUNT,
			FUNC_CURRENCY_ALLOWABLE_AMT,
			ORG_ID,
			CREATED_BY,
			CREATION_DATE,
			LAST_UPDATED_BY,
			LAST_UPDATE_LOGIN,
			LAST_UPDATE_DATE,
			EXCEEDED_AMOUNT,
			VIOLATION_DATE,
			DUP_REPORT_HEADER_ID,
			DUP_REPORT_LINE_ID,
			DUP_DIST_LINE_NUMBER
                      )
                     (select p_request_id arc_req_id, sysdate archive_date,
			A.REPORT_HEADER_ID,
			A.DISTRIBUTION_LINE_NUMBER,
			A.VIOLATION_NUMBER,
			A.VIOLATION_TYPE,
			A.ALLOWABLE_AMOUNT,
			A.FUNC_CURRENCY_ALLOWABLE_AMT,
			A.ORG_ID,
			A.CREATED_BY,
			A.CREATION_DATE,
			A.LAST_UPDATED_BY,
			A.LAST_UPDATE_LOGIN,
			A.LAST_UPDATE_DATE,
			A.EXCEEDED_AMOUNT,
			A.VIOLATION_DATE,
			A.DUP_REPORT_HEADER_ID,
			A.DUP_REPORT_LINE_ID,
			A.DUP_DIST_LINE_NUMBER
		      from ap_pol_violations_all a, AP_EXP_REPORT_HEADERS_GT gt
		      where gt.report_header_id = a.report_header_id);

Line: 1374

 l_debug_info := 'Insert into AP Notes.';

Line: 1377

 insert into ap_notes_arc (
			ARC_REQ_ID,
			ARCHIVE_DATE,
			NOTE_ID,
			SOURCE_OBJECT_CODE,
			SOURCE_OBJECT_ID,
			NOTE_TYPE,
			NOTES_DETAIL,
			ENTERED_BY,
			ENTERED_DATE,
			SOURCE_LANG,
			CREATION_DATE,
			CREATED_BY,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			LAST_UPDATE_LOGIN
                       )
                     (select p_request_id arc_req_id, sysdate archive_date,
		        A.NOTE_ID,
			A.SOURCE_OBJECT_CODE,
			A.SOURCE_OBJECT_ID,
			A.NOTE_TYPE,
			A.NOTES_DETAIL,
			A.ENTERED_BY,
			A.ENTERED_DATE,
			A.SOURCE_LANG,
			A.CREATION_DATE,
			A.CREATED_BY,
			A.LAST_UPDATE_DATE,
			A.LAST_UPDATED_BY,
			A.LAST_UPDATE_LOGIN
		      from ap_notes a, AP_EXP_REPORT_HEADERS_GT gt
		      where gt.report_header_id = a.source_object_id);

Line: 1425

	select report_header_id
	from ap_expense_report_headers_arc
	where arc_req_id = l_request_id;

Line: 1429

	select report_line_id
	from ap_expense_report_lines_arc
	where arc_req_id = l_request_id;

Line: 1446

 l_debug_info := 'Delete AP Notes.';

Line: 1449

 DELETE FROM ap_notes
 WHERE source_object_id IN (
	SELECT source_object_id
	FROM ap_notes_arc
	WHERE arc_req_id = p_request_id);

Line: 1459

 l_debug_info := 'Delete Policy Violations.';

Line: 1462

 DELETE FROM ap_pol_violations_all
 WHERE report_header_id IN (
	SELECT report_header_id
	FROM ap_pol_violations_arc
	WHERE arc_req_id = p_request_id);

Line: 1472

 l_debug_info := 'Delete Audit reasons.';

Line: 1475

 DELETE FROM ap_aud_audit_reasons
 WHERE audit_reason_id IN (
        SELECT audit_reason_id
	FROM ap_aud_audit_reasons_arc
	WHERE arc_req_id = p_request_id);

Line: 1485

 l_debug_info := 'Delete Attendee information.';

Line: 1488

 DELETE FROM oie_attendees_all
 WHERE attendee_line_id IN (
        SELECT attendee_line_id
	FROM oie_attendees_arc
	WHERE arc_req_id = p_request_id);

Line: 1498

 l_debug_info := 'Delete Perdiem destinations.';

Line: 1501

 DELETE FROM oie_pdm_destinations
 WHERE pdm_destination_id IN (
        SELECT pdm_destination_id
	FROM oie_pdm_destinations_arc
	WHERE arc_req_id = p_request_id);

Line: 1511

 l_debug_info := 'Delete Perdiem Daily Beakups.';

Line: 1514

 DELETE FROM oie_pdm_daily_breakups
 WHERE pdm_daily_breakup_id IN (
        SELECT pdm_daily_breakup_id
	FROM oie_pdm_daily_breakups_arc
	WHERE arc_req_id = p_request_id);

Line: 1524

 l_debug_info := 'Delete Add On Mileage rates.';

Line: 1527

 DELETE FROM oie_addon_mileage_rates
 WHERE report_line_id IN (
        SELECT report_line_id
	FROM oie_addon_mileage_rates_arc
	WHERE arc_req_id = p_request_id);

Line: 1537

 l_debug_info := 'Delete CC Transaction Details.';

Line: 1540

 DELETE FROM ap_cc_trx_details
 WHERE trx_detail_id IN (
        SELECT trx_detail_id
	FROM ap_cc_trx_details_arc
	WHERE arc_req_id = p_request_id);

Line: 1550

 l_debug_info := 'Delete CC Transactions.';

Line: 1553

 DELETE FROM ap_credit_card_trxns_all
 WHERE report_header_id IN (
        SELECT report_header_id
	FROM ap_credit_card_trxns_arc
	WHERE arc_req_id = p_request_id);

Line: 1563

 l_debug_info := 'Delete Distributions.';

Line: 1566

 DELETE FROM ap_exp_report_dists_all
 WHERE report_distribution_id IN (
        SELECT report_distribution_id
	FROM ap_exp_report_dists_arc
	WHERE arc_req_id = p_request_id);

Line: 1576

 l_debug_info := 'Delete Lines.';

Line: 1579

 DELETE FROM ap_expense_report_lines_all
 WHERE report_line_id IN (
        SELECT report_line_id
	FROM ap_expense_report_lines_arc
	WHERE arc_req_id = p_request_id);

Line: 1589

 l_debug_info := 'Delete Headers.';

Line: 1592

 DELETE FROM ap_expense_report_headers_all
 WHERE report_header_id IN (
        SELECT report_header_id
	FROM ap_expense_report_headers_arc
	WHERE arc_req_id = p_request_id);

Line: 1608

	-- Delete Line Attachments
	open c_exp_report_lines(p_request_id);

Line: 1613

		l_debug_info := 'Delete Line Attachements for report Line ' || to_char(l_report_line_id);

Line: 1614

		FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(
				   X_entity_name => 'OIE_LINE_ATTACHMENTS',
				   X_pk1_value => to_char(l_report_line_id),
				   X_delete_document_flag => 'N');

Line: 1626

			select   end_date
			into     l_end_date
			from     wf_items
			where    item_type = 'APEXP'
			and      item_key  = to_char(l_report_header_id);

Line: 1674

						select   end_date
						into     l_end_date
						from     wf_items
						where    item_type = 'APEXP'
						and      item_key  = l_child_item_key;

Line: 1717

		l_debug_info := 'Delete Header Attachements for report ' || to_char(l_report_header_id);

Line: 1718

		FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(
				   X_entity_name => 'OIE_HEADER_ATTACHMENTS',
				   X_pk1_value => to_char(l_report_header_id),
				   X_delete_document_flag => 'N');

Line: 1766

  fnd_file.put_line(fnd_file.log, 'Archiving the selected Expense Reports');

Line: 1781

  fnd_file.put_line(fnd_file.log, 'Purging the selected Expense Reports');

Line: 1795

  select count(*) into l_count from AP_EXP_REPORT_HEADERS_GT;

Line: 1801

  delete from AP_EXP_REPORT_HEADERS_GT;