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 277: tabname => 'PSP_DISTRIBUTION_INTERFACE');

273: -- Commented for bug 9857299
274: /*
275: Begin
276: FND_STATS.Gather_Table_Stats(ownname => 'PSP',
277: tabname => 'PSP_DISTRIBUTION_INTERFACE');
278:
279: -- percent => 10,
280: -- tmode => 'NORMAL');
281: -- Removed percent and tmode parameters for bug fix 2463762

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

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

Line 700: update psp_distribution_interface

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

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

705: end if;
706: fnd_message.set_name('PSP','PSP_BATCH_HAS_ERRORS');
707: fnd_msg_pub.add;
708: -- This comment was added by Chandra to commit records
709: -- in the PSP_DISTRIBUTION_INTERFACE table with the status
710: commit; -- Added by Chandra
711: raise FND_API.G_EXC_UNEXPECTED_ERROR;
712: end if;
713: --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 807: FROM psp_distribution_interface a,

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

Line 823: UPDATE psp_distribution_interface

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

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

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

Line 1638: UPDATE psp_distribution_interface

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

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

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

Line 1664: UPDATE psp_distribution_interface

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

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

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

Line 1767: FROM psp_distribution_interface

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

Line 2318: update psp_distribution_interface

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

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

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

Line 2387: UPDATE psp_distribution_interface

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

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

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

Line 2415: UPDATE psp_distribution_interface

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

Line 2509: from psp_distribution_interface

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

Line 2767: update psp_distribution_interface

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

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

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