APPS.PA_TRANSACTIONS dependencies on PA_EXPENDITURE_GROUPS

Line 1604: INSERT INTO pa_expenditure_groups(

1600: IF P_DEBUG_MODE THEN
1601: pa_cc_utils.log_message('InsertExp: ' || 'Start ');
1602: END IF;
1603:
1604: INSERT INTO pa_expenditure_groups(
1605: expenditure_group
1606: , expenditure_group_status_code
1607: , expenditure_ending_date
1608: , system_linkage_function

Line 1663: from pa_expenditure_groups

1659: END IF;
1660:
1661: select 1, expenditure_ending_date
1662: into l_Dummy, l_Ending_Date
1663: from pa_expenditure_groups
1664: where expenditure_group = X_expenditure_group;
1665:
1666: Exception
1667: when no_data_found then

Line 1680: INSERT INTO pa_expenditure_groups(

1676: IF P_DEBUG_MODE THEN
1677: pa_cc_utils.log_message('InsertExp: ' || 'Exp Group does not exist, insert');
1678: END IF;
1679:
1680: INSERT INTO pa_expenditure_groups(
1681: expenditure_group
1682: , expenditure_group_status_code
1683: , expenditure_ending_date
1684: , system_linkage_function

Line 1716: update pa_expenditure_groups

1712: IF P_DEBUG_MODE THEN
1713: pa_cc_utils.log_message('InsertExp: ' || 'Existing Exp Groups ending date is lesser, update');
1714: END IF;
1715:
1716: update pa_expenditure_groups
1717: set expenditure_ending_date = X_ending_date
1718: where expenditure_group = X_expenditure_group;
1719:
1720: IF P_DEBUG_MODE THEN