[Home] [Help]
9456: | HISTORY: |
9457: | 06/26/03 Linda Soo Created |
9458: | 08/20/09 Ivan Pineda Added logic for this API to retrieve the |
9459: | expenditure type from pjm_project_parameters |
9460: | or pjm_org_parameters when its not found in |
9461: | in the category associations |
9462: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
9463: PROCEDURE get_ExpType_for_DirectItem (
9464: p_api_version IN NUMBER,
9488: Added this two parameters for bug 7328006 to retrieve
9489: project_id and o rganization_id in the same access to
9490: wip_transactions to don't hurt the performance and at
9491: the same time be able to access Pjm_project_parameters
9492: and pjm_org_parameters to check if the expenditure type
9493: is defined in there
9494: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
9495: l_organization_id NUMBER;
9496: l_project_id NUMBER;
9614: at the pjm_project_parameters table defined for
9615: direct items.
9616: 3. If 2 is not found (like in the case of the common
9617: project) then use the expenditure type at the
9618: pjm_org_parameters table defined for direct items
9619: 4. If 3 is not found then error out
9620: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
9621: /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++
9622: | Check if the expenditure type is defined in the |
9677:
9678: /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++
9679: | Check if the expenditure type was not defined in the |
9680: | project parameters then try to derive it from the |
9681: | pjm_org_parameters |
9682: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
9683: l_statement := 100;
9684: if (l_expenditure_type = to_char(-1)) then
9685: if (l_debug = 'Y') THEN
9683: l_statement := 100;
9684: if (l_expenditure_type = to_char(-1)) then
9685: if (l_debug = 'Y') THEN
9686: fnd_file.put_line(fnd_file.log, 'No expenditure type found in Project Parameters');
9687: fnd_file.put_line(fnd_file.log, 'Deriving expenditure type from PJM Org Parameters');
9688: end if;
9689: begin
9690: select pop.dir_item_expenditure_type
9691: into l_expenditure_type
9688: end if;
9689: begin
9690: select pop.dir_item_expenditure_type
9691: into l_expenditure_type
9692: from pjm_org_parameters pop
9693: where pop.organization_id = l_organization_id;
9694: exception
9695: when no_data_found then
9696: if (l_debug = 'Y') THEN