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 1213: insert into pa_events

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

Line 1306: pa_events_s.nextval,

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

Line 1609: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

1605: l_project_id pa_projects_all.project_id%TYPE;
1606: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1607: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
1608: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
1609: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
1610: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
1611: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
1612: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
1613: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 1610: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

1606: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1607: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
1608: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
1609: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
1610: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
1611: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
1612: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
1613: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
1614: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

Line 1611: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

1607: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
1608: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
1609: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
1610: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
1611: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
1612: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
1613: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
1614: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
1615: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

Line 1612: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

1608: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
1609: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
1610: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
1611: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
1612: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
1613: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
1614: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
1615: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
1616: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

Line 1614: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

1610: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
1611: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
1612: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
1613: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
1614: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
1615: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
1616: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
1617: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1618: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 1615: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

1611: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
1612: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
1613: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
1614: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
1615: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
1616: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
1617: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1618: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
1619: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 1616: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

1612: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
1613: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
1614: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
1615: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
1616: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
1617: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1618: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
1619: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1620: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 1631: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

1627: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1628: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
1629: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
1630: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
1631: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
1632: l_return_status VARCHAR2(30);
1633: l_msg_count NUMBER;
1634: l_msg_data VARCHAR2(30);
1635: l_found VARCHAR2(30);

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

1647: BEGIN
1648: IF g1_debug_mode = 'Y' THEN
1649: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.insert_event2:' );
1650: END IF;
1651: -- Assigning who columns for insertion into PA_EVENTS.
1652:
1653: created_by := FND_GLOBAL.USER_ID;
1654: last_updated_by := FND_GLOBAL.USER_ID;
1655: last_update_login := FND_GLOBAL.LOGIN_ID;

Line 2053: l_event_id := pa_events_s.nextval;

2049:
2050: /* MCB2: Removed Revenue amount and Bill amount because,these amounts are being used only for transactions */
2051:
2052:
2053: l_event_id := pa_events_s.nextval;
2054:
2055:
2056: IF (pa_billing_validate.automatic_event(XD_event_type)) THEN
2057: insert into pa_events

Line 2057: insert into pa_events

2053: l_event_id := pa_events_s.nextval;
2054:
2055:
2056: IF (pa_billing_validate.automatic_event(XD_event_type)) THEN
2057: insert into pa_events
2058: (PROJECT_ID, TASK_ID, ORGANIZATION_ID, EVENT_NUM, EVENT_TYPE, -- 1
2059: REVENUE_AMOUNT,BILL_AMOUNT,COMPLETION_DATE, REQUEST_ID, -- 2
2060: DESCRIPTION, BILL_HOLD_FLAG, REV_DIST_REJECTION_CODE, -- 3
2061: REVENUE_DISTRIBUTED_FLAG, PROGRAM_APPLICATION_ID, PROGRAM_ID, -- 4