eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_PREGEN dependencies on PSP_DISTRIBUTION_INTERFACE

Line 123: -- fetches all records from psp_distribution_interface table belongs to given batch name and

119: --
120: --
121: -- This is the Main procedure which is being called by Concurrent process
122: -- Input parameter is Batch Name
123: -- fetches all records from psp_distribution_interface table belongs to given batch name and
124: -- validates each record whether it is valid or not.
125: -- If all records are valid then imports into psp_pre_gen_dist_lines table and marks as Transfered in
126: -- psp_distribution_interface table
127: --

Line 126: -- psp_distribution_interface table

122: -- Input parameter is Batch Name
123: -- fetches all records from psp_distribution_interface table belongs to given batch name and
124: -- validates each record whether it is valid or not.
125: -- If all records are valid then imports into psp_pre_gen_dist_lines table and marks as Transfered in
126: -- psp_distribution_interface table
127: --
128: PROCEDURE IMPORT_PREGEN_LINES (ERRBUF OUT NOCOPY Varchar2,
129: RETCODE OUT NOCOPY Number,
130: p_batch_name IN VARCHAR2,

Line 139: FROM psp_distribution_interface

135: -- p_gms_pa_install IN VARCHAR2 default NULL) IS Commented as part of bug fix 2447912
136:
137: CURSOR get_all_from_interface_csr is
138: SELECT *
139: FROM psp_distribution_interface
140: WHERE batch_name = p_batch_name and
141: status_code <> 'V' FOR UPDATE;
142:
143: -- Declared the following cursor and exception for bug fix 2094036

Line 146: FROM psp_distribution_interface

142:
143: -- Declared the following cursor and exception for bug fix 2094036
144: CURSOR pregen_distribution_check_cur IS
145: SELECT distribution_interface_id
146: FROM psp_distribution_interface
147: WHERE batch_name = p_batch_name
148: AND business_group_id = p_business_group_id
149: AND set_of_books_id = p_set_of_books_id
150: FOR UPDATE OF distribution_interface_id NOWAIT;

Line 160: FROM psp_distribution_interface

156: g_pregen_rec get_all_from_interface_csr%ROWTYPE;
157:
158: CURSOR get_for_total_csr is
159: SELECT *
160: FROM psp_distribution_interface
161: WHERE batch_name = p_batch_name
162: ORDER BY source_code,time_period_id;
163:
164: g_for_total_rec get_for_total_csr%ROWTYPE;

Line 179: FROM psp_distribution_interface

175:
176: -- Introduced the following for bug fix 2916848
177: CURSOR currency_count_cur IS
178: SELECT COUNT(DISTINCT NVL(currency_code, 'bg_currency'))
179: FROM psp_distribution_interface
180: WHERE batch_name = p_batch_name
181: AND business_group_id = p_business_group_id
182: AND set_of_books_id = p_set_of_books_id;
183:

Line 186: FROM psp_distribution_interface

182: AND set_of_books_id = p_set_of_books_id;
183:
184: CURSOR currency_code_cur IS
185: SELECT currency_code
186: FROM psp_distribution_interface
187: WHERE batch_name = p_batch_name
188: AND business_group_id = p_business_group_id
189: AND set_of_books_id = p_set_of_books_id
190: AND currency_code IS NOT NULL

Line 275: tabname => 'PSP_DISTRIBUTION_INTERFACE');

271: end if;
272:
273: Begin
274: FND_STATS.Gather_Table_Stats(ownname => 'PSP',
275: tabname => 'PSP_DISTRIBUTION_INTERFACE');
276:
277: -- percent => 10,
278: -- tmode => 'NORMAL');
279: -- Removed percent and tmode parameters for bug fix 2463762

Line 378: select count(*) into l_count_status_v from psp_distribution_interface

374: --RAISE NO_DATA_FOUND;
375: /* Code added by Subha on 7/23/1999 to allow processing to continue in the vent that all
376: records in interface table have a status of 'VALID' */
377:
378: select count(*) into l_count_status_v from psp_distribution_interface
379: where batch_name=p_batch_name and status_code='V';
380: if l_count_status_v = 0 then
381: raise NO_DATA_FOUND;
382: end if;

Line 697: update psp_distribution_interface

693: if l_batch_status = 1 then
694: /* 2007521: Introduced update statement, to revert sticking suspense a/c if
695: there are some other errors. Give chance to user to correct all errors */
696: if nvl(g_use_pre_gen_suspense,'N') = 'Y' then
697: update psp_distribution_interface
698: set suspense_org_account_id = null,
699: status_code = 'E'
700: where batch_name = p_batch_name and
701: suspense_org_account_id is not null;

Line 706: -- in the PSP_DISTRIBUTION_INTERFACE table with the status

702: end if;
703: fnd_message.set_name('PSP','PSP_BATCH_HAS_ERRORS');
704: fnd_msg_pub.add;
705: -- This comment was added by Chandra to commit records
706: -- in the PSP_DISTRIBUTION_INTERFACE table with the status
707: commit; -- Added by Chandra
708: raise FND_API.G_EXC_UNEXPECTED_ERROR;
709: end if;
710: --For Bug 2096440 : Moved the END IF above , the check for l_batch_status=1 has to be applicable for autopop 'Y' as well as 'N'

Line 804: FROM psp_distribution_interface a,

800: a.attribute9,
801: a.attribute10,
802: a.suspense_auto_glccid,
803: a.suspense_auto_exp_type
804: FROM psp_distribution_interface a,
805: per_time_periods T,
806: psp_organization_accounts susp --- introduced for 5164744
807: WHERE batch_name = p_batch_name and
808: T.time_period_id = a.time_period_id and

Line 820: UPDATE psp_distribution_interface

816: --dbms_output.PUT_LINE('...L_project_count ' || to_char(l_project_count) );
817:
818: /* 2007521: Deleted creation of balancing lines for Projects/GL, S and T does this */
819:
820: UPDATE psp_distribution_interface
821: SET status_code = 'T'
822: WHERE batch_name = p_batch_name;
823: --dbms_output.PUT_LINE('...Crossed Update ' );
824: if sql%NOTFOUND then

Line 1628: -- This procedure is to update the psp_distribution_interface table

1624: return;
1625: END;
1626: --
1627: ----------------------------------UPDATE_RECORD_WITH_ERROR-----------------------------------
1628: -- This procedure is to update the psp_distribution_interface table
1629: -- with given error code
1630: --
1631: Procedure update_record_with_error(X_distribution_interface_id IN Number,
1632: X_error_code IN Varchar2,

Line 1635: UPDATE psp_distribution_interface

1631: Procedure update_record_with_error(X_distribution_interface_id IN Number,
1632: X_error_code IN Varchar2,
1633: X_return_status OUT NOCOPY varchar2) IS
1634: begin
1635: UPDATE psp_distribution_interface
1636: SET status_code = 'E',
1637: error_code = x_error_code
1638: WHERE distribution_interface_id = x_distribution_interface_id;
1639:

Line 1656: -- This procedure is to update psp_distribution_interface table with Valid status

1652:
1653: end;
1654: --
1655: ----------------------------------UPDATE_RECORD_WITH_VALID-----------------------------------
1656: -- This procedure is to update psp_distribution_interface table with Valid status
1657: --
1658: Procedure update_record_with_valid(X_distribution_interface_id IN Number,
1659: X_return_status OUT NOCOPY varchar2) IS
1660: begin

Line 1661: UPDATE psp_distribution_interface

1657: --
1658: Procedure update_record_with_valid(X_distribution_interface_id IN Number,
1659: X_return_status OUT NOCOPY varchar2) IS
1660: begin
1661: UPDATE psp_distribution_interface
1662: SET status_code = 'V',
1663: error_code = NULL
1664: WHERE distribution_interface_id = x_distribution_interface_id;
1665:

Line 1744: -- fetches all records from psp_distribution_interface table belongs to given batch name and

1740:
1741: /* autopop stuff */
1742:
1743: -- Called from Import_Pregen when autopop profile option is set to 'Y'
1744: -- fetches all records from psp_distribution_interface table belongs to given batch name and
1745: -- validates each record whether it is valid or not for purposes of running auto-population.
1746: -- If a record is valid then auto-population will replace the expenditure type for
1747: -- project lines or the GL code combination ID for Gl lines. The regular import Pregen process is
1748: -- called separately and will re-do valoidations to insure the new expenditure type and other info

Line 1764: FROM psp_distribution_interface

1760: --For Bug 2651339 : Introduced the status code check
1761: --to avoid revalidation of valid records
1762: CURSOR get_all_from_interface_csr is
1763: SELECT *
1764: FROM psp_distribution_interface
1765: WHERE batch_name = x_batch_name
1766: AND status_code <> 'V'; --Introduced for bug 2651339
1767: -- FOR UPDATE; Commented FOR UPDATE for bug fix 2094036
1768:

Line 2315: update psp_distribution_interface

2311: if l_batch_status =1 then
2312: /* 2007521: Introduced update statement, to revert sticking suspense a/c if
2313: there are some other errors. Give chance to user to correct all errors */
2314: if g_use_pre_gen_suspense = 'Y' then
2315: update psp_distribution_interface
2316: set suspense_org_account_id = null,
2317: status_code = 'E'
2318: where batch_name = x_batch_name and
2319: suspense_org_account_id is not null;

Line 2377: -- This procedure is to update psp_distribution_interface table with Auto-Populated expenditure type

2373:
2374: --
2375:
2376: ----------------------------------UPDATE_RECORD_WITH_EXP-----------------------------------
2377: -- This procedure is to update psp_distribution_interface table with Auto-Populated expenditure type
2378: --
2379:
2380: Procedure update_record_with_exp(X_distribution_interface_id IN Number,
2381: X_expenditure_type IN Varchar2,

Line 2384: UPDATE psp_distribution_interface

2380: Procedure update_record_with_exp(X_distribution_interface_id IN Number,
2381: X_expenditure_type IN Varchar2,
2382: X_return_status OUT NOCOPY Varchar2) IS
2383: begin
2384: UPDATE psp_distribution_interface
2385: SET expenditure_type = X_expenditure_type
2386: WHERE distribution_interface_id = X_distribution_interface_id;
2387:
2388: if SQL%NOTFOUND then

Line 2405: -- This procedure is to update psp_distribution_interface table with Auto-Populated expenditure type

2401: end;
2402:
2403: --
2404: ----------------------------------UPDATE_RECORD_WITH_NA-----------------------------------
2405: -- This procedure is to update psp_distribution_interface table with Auto-Populated expenditure type
2406: --
2407:
2408: Procedure update_record_with_na(X_distribution_interface_id IN Number,
2409: X_gl_code_combination_id IN Number,

Line 2412: UPDATE psp_distribution_interface

2408: Procedure update_record_with_na(X_distribution_interface_id IN Number,
2409: X_gl_code_combination_id IN Number,
2410: X_return_status OUT NOCOPY Varchar2) IS
2411: begin
2412: UPDATE psp_distribution_interface
2413: SET gl_code_combination_id = X_gl_code_combination_id
2414: WHERE distribution_interface_id = X_distribution_interface_id;
2415:
2416: if SQL%NOTFOUND then

Line 2506: from psp_distribution_interface

2502:
2503: cursor get_element_type is
2504: select element_type_id,
2505: assignment_id
2506: from psp_distribution_interface
2507: where distribution_interface_id = p_distribution_interface_id;
2508:
2509: cursor get_asg_details is
2510: select ppf.full_name,

Line 2764: update psp_distribution_interface

2760: if v_return_status <> FND_API.G_RET_STS_SUCCESS then
2761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2762: end if;
2763:
2764: update psp_distribution_interface
2765: set suspense_org_account_id = v_suspense_account,
2766: error_code = p_suspense_reason_code,
2767: status_code = 'V',
2768: suspense_auto_glccid = l_suspense_auto_glccid, --- added for 5080403

Line 2787: If Cr_Dr_Flag in the psp_distribution_interface table is not in ('C','D') then throw Exception */

2783: p_return_status := fnd_api.g_ret_sts_unexp_error;
2784: END;
2785:
2786: /* Bug fix 2985061: Created this procedure.
2787: If Cr_Dr_Flag in the psp_distribution_interface table is not in ('C','D') then throw Exception */
2788:
2789: PROCEDURE VALIDATE_DR_CR_FLAG ( X_DR_CR_FLAG IN VARCHAR2,
2790: X_return_status OUT NOCOPY varchar2,
2791: X_return_code OUT NOCOPY varchar2) IS