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.

[Home] [Help]

APPS.PSB_GL_INTERFACE_PVT dependencies on PSB_GL_INTERFACES

Line 375: FROM psb_gl_interfaces a,

371: sum(a.entered_cr) cr_amt,
372: a.accounting_date,
373: a.budget_version_flag,
374: sum(a.amount) amount
375: FROM psb_gl_interfaces a,
376: gl_code_combinations b
377: WHERE worksheet_id = p_worksheet_id
378: AND period_name = p_period_name
379: AND budget_source_type = g_budget_source_type

Line 432: INSERT INTO psb_gl_interfaces

428: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:
432: INSERT INTO psb_gl_interfaces
433: (worksheet_id,
434: group_id,
435: status,
436: set_of_books_id,

Line 1148: FROM psb_gl_interfaces

1144: reference5,
1145: 8401,
1146: l_session_id,
1147: l_serial_id
1148: FROM psb_gl_interfaces
1149: WHERE worksheet_id = p_worksheet_id
1150: AND period_name = p_period_name
1151: AND budget_version_flag = 'P'
1152: AND NVL(budget_source_type, 'BP') = g_budget_source_type;

Line 1234: FROM psb_gl_interfaces

1230: reference1,
1231: reference2,
1232: reference4,
1233: reference5
1234: FROM psb_gl_interfaces
1235: WHERE worksheet_id = p_worksheet_id
1236: AND NVL(budget_source_type,'BP') = g_budget_source_type;
1237:
1238: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1290: FROM psb_gl_interfaces

1286:
1287: CURSOR l_ws_period_csr
1288: IS
1289: SELECT DISTINCT period_name
1290: FROM psb_gl_interfaces
1291: WHERE worksheet_id = p_source_id
1292: AND NVL(budget_source_type,'BP') = g_budget_source_type;
1293:
1294:

Line 1316: FROM psb_gl_interfaces

1312: -- Bug 3029168 Start. code to find period names
1313: SELECT MAX(period_num),MIN(PERIOD_NUM)
1314: INTO l_max_period,
1315: l_min_period
1316: FROM psb_gl_interfaces
1317: WHERE budget_source_type = p_event_type
1318: AND budget_year_id = g_budget_year_id
1319: AND worksheet_id = p_source_id;
1320:

Line 1324: FROM psb_gl_interfaces

1320:
1321:
1322: SELECT period_name
1323: INTO l_max_period_name
1324: FROM psb_gl_interfaces
1325: WHERE period_num = l_max_period
1326: AND budget_source_type = p_event_type
1327: AND budget_year_id = g_budget_year_id
1328: AND worksheet_id = p_source_id

Line 1333: FROM psb_gl_interfaces

1329: AND rownum = 1;
1330:
1331: SELECT period_name
1332: INTO l_min_period_name
1333: FROM psb_gl_interfaces
1334: WHERE period_num = l_min_period
1335: AND budget_source_type = p_event_type
1336: AND budget_year_id = g_budget_year_id
1337: AND worksheet_id = p_source_id

Line 2257: --++ THEN INTO psb_gl_interfaces

2253: CLOSE c_bgversion;
2254: END IF;
2255:
2256: --++
2257: --++ THEN INTO psb_gl_interfaces
2258: --++
2259: INSERT INTO psb_gl_interfaces
2260: (worksheet_id,
2261: group_id,

Line 2259: INSERT INTO psb_gl_interfaces

2255:
2256: --++
2257: --++ THEN INTO psb_gl_interfaces
2258: --++
2259: INSERT INTO psb_gl_interfaces
2260: (worksheet_id,
2261: group_id,
2262: status,
2263: set_of_books_id,

Line 2401: --++ THEN INTO psb_gl_interfaces

2397: RAISE FND_API.G_EXC_ERROR;
2398: END IF;
2399:
2400: --++
2401: --++ THEN INTO psb_gl_interfaces
2402: --++
2403: INSERT INTO psb_gl_interfaces
2404: (worksheet_id,
2405: group_id,

Line 2403: INSERT INTO psb_gl_interfaces

2399:
2400: --++
2401: --++ THEN INTO psb_gl_interfaces
2402: --++
2403: INSERT INTO psb_gl_interfaces
2404: (worksheet_id,
2405: group_id,
2406: status,
2407: set_of_books_id,

Line 2616: DELETE FROM psb_gl_interfaces

2612: BEGIN
2613:
2614: SAVEPOINT Delete_Old_Run;
2615:
2616: DELETE FROM psb_gl_interfaces
2617: WHERE worksheet_id = p_worksheet_id
2618: AND NVL(budget_source_type, 'P') = p_budget_source_type;
2619:
2620: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3367: -- Record types those will hold the PSB_GL_INTERFACES

3363: l_period_indx NUMBER :=0;
3364: l_tbl_indx NUMBER :=0;
3365:
3366: -- Bug#4310411 Start
3367: -- Record types those will hold the PSB_GL_INTERFACES
3368: -- table's columns.
3369: rec_budget_version_id Number_Tbl_Type;
3370: rec_accounting_date Date_Tbl_Type;
3371: rec_period_name Char_Tbl_Type;

Line 3518: -- THEN INSERT INTO psb_gl_interfaces

3514: END IF;
3515: END IF;
3516:
3517: --
3518: -- THEN INSERT INTO psb_gl_interfaces
3519: --
3520:
3521: l_tbl_indx := l_tbl_indx + 1;
3522:

Line 3543: --++ Now Bulk Insert the Data INTO PSB_GL_INTERFACES.

3539: -- change occured.
3540: l_period_indx := l_period_indx + 1;
3541: l_rec_period_name(l_period_indx) := l_gl_period_name;
3542:
3543: --++ Now Bulk Insert the Data INTO PSB_GL_INTERFACES.
3544: IF rec_budget_version_id.COUNT > 0 THEN
3545: FORALL l_indx IN 1..rec_budget_version_id.COUNT
3546: INSERT INTO psb_gl_interfaces
3547: (worksheet_id,

Line 3546: INSERT INTO psb_gl_interfaces

3542:
3543: --++ Now Bulk Insert the Data INTO PSB_GL_INTERFACES.
3544: IF rec_budget_version_id.COUNT > 0 THEN
3545: FORALL l_indx IN 1..rec_budget_version_id.COUNT
3546: INSERT INTO psb_gl_interfaces
3547: (worksheet_id,
3548: group_id,
3549: status,
3550: set_of_books_id,

Line 4761: /* for bug 4654145 --> Check the psb_gl_interfaces table whether the BR has been posted or not */

4757: IS
4758: -- local variables
4759: l_api_name CONSTANT VARCHAR2(30) := 'Find Document Posting Status';
4760:
4761: /* for bug 4654145 --> Check the psb_gl_interfaces table whether the BR has been posted or not */
4762: l_no NUMBER;
4763:
4764: BEGIN
4765: IF p_Document_Type = 'BR' THEN

Line 4768: FROM psb_gl_interfaces

4764: BEGIN
4765: IF p_Document_Type = 'BR' THEN
4766: SELECT 1
4767: INTO l_no
4768: FROM psb_gl_interfaces
4769: WHERE worksheet_id = p_document_id
4770: AND budget_source_type = p_document_type
4771: AND rownum = 1;
4772: