DBA Data[Home] [Help]

APPS.PA_BILLING_PUB dependencies on PA_EVENTS

Line 770: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

766: l_project_id pa_projects_all.project_id%TYPE;
767: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
768: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
769: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
770: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
771: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
772: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
773: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
774: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 771: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

767: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
768: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
769: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
770: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
771: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
772: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
773: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
774: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
775: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

Line 772: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

768: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
769: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
770: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
771: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
772: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
773: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
774: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
775: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
776: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

Line 773: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

769: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
770: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
771: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
772: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
773: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
774: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
775: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
776: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
777: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

Line 775: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

771: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
772: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
773: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
774: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
775: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
776: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
777: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
778: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
779: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 776: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

772: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
773: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
774: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
775: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
776: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
777: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
778: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
779: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
780: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 777: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

773: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
774: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
775: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
776: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
777: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
778: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
779: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
780: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
781: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 792: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

788: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
789: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
790: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
791: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
792: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
793: l_return_status VARCHAR2(30);
794: l_msg_count NUMBER;
795: l_msg_data VARCHAR2(30);
796: l_found VARCHAR2(30);

Line 812: -- Assigning who columns for insertion into PA_EVENTS.

808: BEGIN
809: IF g1_debug_mode = 'Y' THEN
810: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.insert_event:' );
811: END IF;
812: -- Assigning who columns for insertion into PA_EVENTS.
813:
814: created_by := FND_GLOBAL.USER_ID;
815: last_updated_by := FND_GLOBAL.USER_ID;
816: last_update_login := FND_GLOBAL.LOGIN_ID;

Line 1212: insert into pa_events

1208: END IF;
1209:
1210: /* MCB2: Removed Revenue amount and Bill amount because,these amounts are being used only for transactions */
1211: IF (pa_billing_validate.automatic_event(XD_event_type)) THEN
1212: insert into pa_events
1213: (PROJECT_ID, TASK_ID, ORGANIZATION_ID, EVENT_NUM, EVENT_TYPE, -- 1
1214: REVENUE_AMOUNT,BILL_AMOUNT,COMPLETION_DATE, REQUEST_ID, -- 2
1215: DESCRIPTION, BILL_HOLD_FLAG, REV_DIST_REJECTION_CODE, -- 3
1216: REVENUE_DISTRIBUTED_FLAG, PROGRAM_APPLICATION_ID, PROGRAM_ID, -- 4

Line 1305: pa_events_s.nextval,

1301: pa_currency.round_currency_amt(X_audit_amount9),
1302: pa_currency.round_currency_amt(X_audit_amount10),
1303: X_audit_cost_budget_type_code,
1304: X_audit_rev_budget_type_code,
1305: pa_events_s.nextval,
1306: x_inventory_org_id,
1307: x_inventory_item_id,
1308: x_quantity_billed,
1309: x_uom_code,