APPS.PA_BILLING_SETUP_PVT dependencies on PA_BILLING_ASSIGNMENTS_ALL

Line 1134: INSERT INTO pa_billing_assignments_all(

1130: SELECT PA_BILLING_ASSIGNMENTS_S.NEXTVAL INTO l_billing_assignment_id
1131: FROM dual;
1132:
1133: x_billing_assignment_id := l_billing_assignment_id;
1134: INSERT INTO pa_billing_assignments_all(
1135: BILLING_ASSIGNMENT_ID ,
1136: BILLING_EXTENSION_ID ,
1137: PROJECT_TYPE ,
1138: PROJECT_ID ,

Line 1337: FROM pa_billing_assignments_all

1333: IF p_validate_only <> FND_API.G_TRUE
1334: THEN
1335: BEGIN
1336: SELECT 'x' INTO l_dummy_char
1337: FROM pa_billing_assignments_all
1338: WHERE billing_assignment_id = p_billing_assignment_id
1339: AND record_version_number = p_record_version_number
1340: FOR UPDATE OF record_version_number NOWAIT;
1341: EXCEPTION

Line 1371: FROM pa_billing_assignments_all

1367: END;
1368: ELSE
1369: BEGIN
1370: SELECT 'x' INTO l_dummy_char
1371: FROM pa_billing_assignments_all
1372: WHERE billing_assignment_id = p_billing_assignment_id
1373: AND record_version_number = p_record_version_number;
1374: EXCEPTION
1375: WHEN NO_DATA_FOUND THEN

Line 1412: UPDATE pa_billing_assignments_all

1408: p_active_flag => p_active,
1409: x_return_status => l_return_status
1410: )
1411: THEN
1412: UPDATE pa_billing_assignments_all
1413: SET
1414: billing_extension_id = p_billing_extension_id,
1415: AMOUNT = l_amount ,
1416: PERCENTAGE = l_percent ,

Line 1547: FROM pa_billing_assignments_all

1543: IF p_validate_only <> FND_API.G_TRUE
1544: THEN
1545: BEGIN
1546: SELECT 'x' INTO l_dummy_char
1547: FROM pa_billing_assignments_all
1548: WHERE billing_extension_id = p_billing_extension_id
1549: AND record_version_number = p_record_version_number
1550: FOR UPDATE OF record_version_number NOWAIT;
1551: EXCEPTION

Line 1581: FROM pa_billing_assignments_all

1577: END;
1578: ELSE
1579: BEGIN
1580: SELECT 'x' INTO l_dummy_char
1581: FROM pa_billing_assignments_all
1582: WHERE billing_extension_id = p_billing_extension_id
1583: AND record_version_number = p_record_version_number;
1584: EXCEPTION
1585: WHEN NO_DATA_FOUND THEN

Line 1614: DELETE FROM pa_billing_assignments_all

1610: RAISE FND_API.G_EXC_ERROR;
1611: END IF;
1612:
1613:
1614: DELETE FROM pa_billing_assignments_all
1615: WHERE billing_extension_id = p_billing_extension_id
1616: AND RECORD_VERSION_NUMBER = p_record_version_number;
1617:
1618: END IF;