DBA Data[Home] [Help]

APPS.PA_BILLING_PUB dependencies on PA_BILLING_VALIDATE

Line 927: IF (pa_billing_validate.valid_proj_task_extn(

923:
924:
925: -- Validate Id's
926:
927: IF (pa_billing_validate.valid_proj_task_extn(
928: nvl(X_project_id, pa_billing.GlobVars.ProjectId),
929: nvl(X_top_task_id, pa_billing.GlobVars.TaskId),
930: pa_billing.GlobVars.BillingAssignmentId) AND
931: pa_billing_validate.valid_organization(XD_organization_id)) THEN

Line 931: pa_billing_validate.valid_organization(XD_organization_id)) THEN

927: IF (pa_billing_validate.valid_proj_task_extn(
928: nvl(X_project_id, pa_billing.GlobVars.ProjectId),
929: nvl(X_top_task_id, pa_billing.GlobVars.TaskId),
930: pa_billing.GlobVars.BillingAssignmentId) AND
931: pa_billing_validate.valid_organization(XD_organization_id)) THEN
932: NULL;
933: ELSE
934: RAISE INVALID_ID;
935: END IF;

Line 980: IF (pa_billing_validate.valid_organization(x_inventory_org_id)) THEN

976: /* Adding validation of newly added columns in event table for project contract integration */
977: -- Validating inventory_org_id and inventory_item_id
978:
979: IF (x_inventory_org_id IS NOT NULL) THEN
980: IF (pa_billing_validate.valid_organization(x_inventory_org_id)) THEN
981: NULL;
982: ELSE
983: RAISE INVALID_INVENT_ID;
984: END IF;

Line 1212: IF (pa_billing_validate.automatic_event(XD_event_type)) THEN

1208: l_revproc_exchange_rate := l_projfunc_bil_exchange_rate;
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

Line 1766: IF (pa_billing_validate.valid_proj_task_extn(

1762:
1763:
1764: -- Validate Id's
1765:
1766: IF (pa_billing_validate.valid_proj_task_extn(
1767: nvl(X_project_id, pa_billing.GlobVars.ProjectId),
1768: nvl(X_top_task_id, pa_billing.GlobVars.TaskId),
1769: pa_billing.GlobVars.BillingAssignmentId) AND
1770: pa_billing_validate.valid_organization(XD_organization_id)) THEN

Line 1770: pa_billing_validate.valid_organization(XD_organization_id)) THEN

1766: IF (pa_billing_validate.valid_proj_task_extn(
1767: nvl(X_project_id, pa_billing.GlobVars.ProjectId),
1768: nvl(X_top_task_id, pa_billing.GlobVars.TaskId),
1769: pa_billing.GlobVars.BillingAssignmentId) AND
1770: pa_billing_validate.valid_organization(XD_organization_id)) THEN
1771: NULL;
1772: ELSE
1773: RAISE INVALID_ID;
1774: END IF;

Line 1819: IF (pa_billing_validate.valid_organization(x_inventory_org_id)) THEN

1815: /* Adding validation of newly added columns in event table for project contract integration */
1816: -- Validating inventory_org_id and inventory_item_id
1817:
1818: IF (x_inventory_org_id IS NOT NULL) THEN
1819: IF (pa_billing_validate.valid_organization(x_inventory_org_id)) THEN
1820: NULL;
1821: ELSE
1822: RAISE INVALID_INVENT_ID;
1823: END IF;

Line 2056: IF (pa_billing_validate.automatic_event(XD_event_type)) THEN

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
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