APPS.PA_TRANSACTIONS dependencies on PA_EXPENDITURE_GROUPS

Line 1721: INSERT INTO pa_expenditure_groups(

1717: IF P_DEBUG_MODE THEN
1718: pa_cc_utils.log_message('InsertExp: ' || 'Start ');
1719: END IF;
1720:
1721: INSERT INTO pa_expenditure_groups(
1722: expenditure_group
1723: , expenditure_group_status_code
1724: , expenditure_ending_date
1725: , system_linkage_function

Line 1780: from pa_expenditure_groups

1776: END IF;
1777:
1778: select 1, expenditure_ending_date
1779: into l_Dummy, l_Ending_Date
1780: from pa_expenditure_groups
1781: where expenditure_group = X_expenditure_group;
1782:
1783: Exception
1784: when no_data_found then

Line 1797: INSERT INTO pa_expenditure_groups(

1793: IF P_DEBUG_MODE THEN
1794: pa_cc_utils.log_message('InsertExp: ' || 'Exp Group does not exist, insert');
1795: END IF;
1796:
1797: INSERT INTO pa_expenditure_groups(
1798: expenditure_group
1799: , expenditure_group_status_code
1800: , expenditure_ending_date
1801: , system_linkage_function

Line 1833: update pa_expenditure_groups

1829: IF P_DEBUG_MODE THEN
1830: pa_cc_utils.log_message('InsertExp: ' || 'Existing Exp Groups ending date is lesser, update');
1831: END IF;
1832:
1833: update pa_expenditure_groups
1834: set expenditure_ending_date = X_ending_date
1835: where expenditure_group = X_expenditure_group;
1836:
1837: IF P_DEBUG_MODE THEN