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_SUM_TRANS dependencies on GL_INTERFACE

Line 103: transfer_to_gl_interface(p_source_type,

99: p_business_group_id,
100: p_set_of_books_id );
101: END IF;
102:
103: transfer_to_gl_interface(p_source_type,
104: p_source_code,
105: p_time_period_id,
106: p_batch_name,
107: p_business_group_id,

Line 176: transfer_to_gl_interface(p_source_type,

172: p_business_group_id,
173: p_set_of_books_id );
174: END IF;
175:
176: transfer_to_gl_interface(p_source_type,
177: p_source_code,
178: p_time_period_id,
179: p_batch_name,
180: p_business_group_id,

Line 1196: ------------------------ GL INTERFACE --------------------------------------------------

1192: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_SUMMARY_LINES');
1193: p_return_status := fnd_api.g_ret_sts_unexp_error;
1194: END;
1195:
1196: ------------------------ GL INTERFACE --------------------------------------------------
1197:
1198: PROCEDURE transfer_to_gl_interface(p_source_type IN VARCHAR2,
1199: p_source_code IN VARCHAR2,
1200: p_time_period_id IN NUMBER,

Line 1198: PROCEDURE transfer_to_gl_interface(p_source_type IN VARCHAR2,

1194: END;
1195:
1196: ------------------------ GL INTERFACE --------------------------------------------------
1197:
1198: PROCEDURE transfer_to_gl_interface(p_source_type IN VARCHAR2,
1199: p_source_code IN VARCHAR2,
1200: p_time_period_id IN NUMBER,
1201: p_batch_name IN VARCHAR2,
1202: p_business_group_id IN NUMBER,

Line 1244: CURSOR gl_interface_cursor(l_payroll_control_id IN NUMBER) IS

1240: AND phase = p_phase; --- 2444657: added the condition;
1241:
1242: /* End of code changes for bug 3112053 */
1243:
1244: CURSOR gl_interface_cursor(l_payroll_control_id IN NUMBER) IS
1245: SELECT psl.summary_line_id,
1246: psl.source_code,
1247: psl.effective_date,
1248: psl.accounting_date, -- added 2 cols for 3108109

Line 1291: gl_interface_rec gl_interface_cursor%ROWTYPE;

1287: AND psl.payroll_control_id = l_payroll_control_id;
1288:
1289: gl_batch_rec gl_batch_cursor%ROWTYPE;
1290: gl_payroll_control_rec gl_payroll_control_cursor%ROWTYPE; -- Introduced for Bug 3112053
1291: gl_interface_rec gl_interface_cursor%ROWTYPE;
1292:
1293: l_user_je_source_name VARCHAR2(25);
1294: l_user_je_category_name VARCHAR2(25);
1295: l_period_name VARCHAR2(35);

Line 1351: SELECT gl_interface_control_s.nextval

1347: END IF;
1348:
1349: -- get the group_id
1350:
1351: SELECT gl_interface_control_s.nextval
1352: INTO l_group_id
1353: FROM dual;
1354:
1355: BEGIN

Line 1393: OPEN gl_interface_cursor(gl_payroll_control_rec.payroll_control_id);

1389: WHERE status_code = 'N'
1390: AND gl_code_combination_id IS NOT NULL
1391: AND payroll_control_id = gl_payroll_control_rec.payroll_control_id;
1392:
1393: OPEN gl_interface_cursor(gl_payroll_control_rec.payroll_control_id);
1394: LOOP
1395: FETCH gl_interface_cursor INTO gl_interface_rec;
1396: IF gl_interface_cursor%NOTFOUND THEN
1397: CLOSE gl_interface_cursor;

Line 1395: FETCH gl_interface_cursor INTO gl_interface_rec;

1391: AND payroll_control_id = gl_payroll_control_rec.payroll_control_id;
1392:
1393: OPEN gl_interface_cursor(gl_payroll_control_rec.payroll_control_id);
1394: LOOP
1395: FETCH gl_interface_cursor INTO gl_interface_rec;
1396: IF gl_interface_cursor%NOTFOUND THEN
1397: CLOSE gl_interface_cursor;
1398: EXIT;
1399: END IF;

Line 1396: IF gl_interface_cursor%NOTFOUND THEN

1392:
1393: OPEN gl_interface_cursor(gl_payroll_control_rec.payroll_control_id);
1394: LOOP
1395: FETCH gl_interface_cursor INTO gl_interface_rec;
1396: IF gl_interface_cursor%NOTFOUND THEN
1397: CLOSE gl_interface_cursor;
1398: EXIT;
1399: END IF;
1400:

Line 1397: CLOSE gl_interface_cursor;

1393: OPEN gl_interface_cursor(gl_payroll_control_rec.payroll_control_id);
1394: LOOP
1395: FETCH gl_interface_cursor INTO gl_interface_rec;
1396: IF gl_interface_cursor%NOTFOUND THEN
1397: CLOSE gl_interface_cursor;
1398: EXIT;
1399: END IF;
1400:
1401: l_rec_count := l_rec_count + 1;

Line 1403: IF gl_interface_rec.dr_cr_flag = 'D' THEN

1399: END IF;
1400:
1401: l_rec_count := l_rec_count + 1;
1402:
1403: IF gl_interface_rec.dr_cr_flag = 'D' THEN
1404: l_entered_dr := gl_interface_rec.summary_amount;
1405: l_entered_cr := NULL;
1406: ELSIF gl_interface_rec.dr_cr_flag = 'C' THEN
1407: l_entered_dr := NULL;

Line 1404: l_entered_dr := gl_interface_rec.summary_amount;

1400:
1401: l_rec_count := l_rec_count + 1;
1402:
1403: IF gl_interface_rec.dr_cr_flag = 'D' THEN
1404: l_entered_dr := gl_interface_rec.summary_amount;
1405: l_entered_cr := NULL;
1406: ELSIF gl_interface_rec.dr_cr_flag = 'C' THEN
1407: l_entered_dr := NULL;
1408: l_entered_cr := gl_interface_rec.summary_amount;

Line 1406: ELSIF gl_interface_rec.dr_cr_flag = 'C' THEN

1402:
1403: IF gl_interface_rec.dr_cr_flag = 'D' THEN
1404: l_entered_dr := gl_interface_rec.summary_amount;
1405: l_entered_cr := NULL;
1406: ELSIF gl_interface_rec.dr_cr_flag = 'C' THEN
1407: l_entered_dr := NULL;
1408: l_entered_cr := gl_interface_rec.summary_amount;
1409: END IF;
1410:

Line 1408: l_entered_cr := gl_interface_rec.summary_amount;

1404: l_entered_dr := gl_interface_rec.summary_amount;
1405: l_entered_cr := NULL;
1406: ELSIF gl_interface_rec.dr_cr_flag = 'C' THEN
1407: l_entered_dr := NULL;
1408: l_entered_cr := gl_interface_rec.summary_amount;
1409: END IF;
1410:
1411: -- dbms_output.put_line('Inserting into gl interface .............');
1412:

Line 1411: -- dbms_output.put_line('Inserting into gl interface .............');

1407: l_entered_dr := NULL;
1408: l_entered_cr := gl_interface_rec.summary_amount;
1409: END IF;
1410:
1411: -- dbms_output.put_line('Inserting into gl interface .............');
1412:
1413: -- Changed The parameter g_currency_code to gl_batch_rec.currency_code, Introduced exchange_rate_type
1414: -- and conversion_date for Bug fix 2916848
1415: insert_into_gl_interface(

Line 1415: insert_into_gl_interface(

1411: -- dbms_output.put_line('Inserting into gl interface .............');
1412:
1413: -- Changed The parameter g_currency_code to gl_batch_rec.currency_code, Introduced exchange_rate_type
1414: -- and conversion_date for Bug fix 2916848
1415: insert_into_gl_interface(
1416: P_SET_OF_BOOKS_ID, GL_INTERFACE_REC.EFFECTIVE_DATE,
1417: gl_payroll_control_rec.CURRENCY_CODE,
1418: L_USER_JE_CATEGORY_NAME,L_USER_JE_SOURCE_NAME,L_ENCUMBRANCE_TYPE_ID,
1419: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,

Line 1416: P_SET_OF_BOOKS_ID, GL_INTERFACE_REC.EFFECTIVE_DATE,

1412:
1413: -- Changed The parameter g_currency_code to gl_batch_rec.currency_code, Introduced exchange_rate_type
1414: -- and conversion_date for Bug fix 2916848
1415: insert_into_gl_interface(
1416: P_SET_OF_BOOKS_ID, GL_INTERFACE_REC.EFFECTIVE_DATE,
1417: gl_payroll_control_rec.CURRENCY_CODE,
1418: L_USER_JE_CATEGORY_NAME,L_USER_JE_SOURCE_NAME,L_ENCUMBRANCE_TYPE_ID,
1419: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,
1420: L_GROUP_ID,L_REFERENCE1,L_REFERENCE1,L_REFERENCE4,

Line 1419: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,

1415: insert_into_gl_interface(
1416: P_SET_OF_BOOKS_ID, GL_INTERFACE_REC.EFFECTIVE_DATE,
1417: gl_payroll_control_rec.CURRENCY_CODE,
1418: L_USER_JE_CATEGORY_NAME,L_USER_JE_SOURCE_NAME,L_ENCUMBRANCE_TYPE_ID,
1419: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,
1420: L_GROUP_ID,L_REFERENCE1,L_REFERENCE1,L_REFERENCE4,
1421: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,
1422: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1423: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,

Line 1421: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,

1417: gl_payroll_control_rec.CURRENCY_CODE,
1418: L_USER_JE_CATEGORY_NAME,L_USER_JE_SOURCE_NAME,L_ENCUMBRANCE_TYPE_ID,
1419: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,
1420: L_GROUP_ID,L_REFERENCE1,L_REFERENCE1,L_REFERENCE4,
1421: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,
1422: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1423: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1424: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1425: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,

Line 1422: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,

1418: L_USER_JE_CATEGORY_NAME,L_USER_JE_SOURCE_NAME,L_ENCUMBRANCE_TYPE_ID,
1419: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,
1420: L_GROUP_ID,L_REFERENCE1,L_REFERENCE1,L_REFERENCE4,
1421: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,
1422: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1423: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1424: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1425: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1426: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,

Line 1423: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,

1419: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,
1420: L_GROUP_ID,L_REFERENCE1,L_REFERENCE1,L_REFERENCE4,
1421: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,
1422: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1423: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1424: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1425: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1426: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1427: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,

Line 1424: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,

1420: L_GROUP_ID,L_REFERENCE1,L_REFERENCE1,L_REFERENCE4,
1421: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,
1422: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1423: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1424: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1425: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1426: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1427: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1428: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,

Line 1425: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,

1421: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,
1422: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1423: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1424: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1425: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1426: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1427: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1428: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1429: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,

Line 1426: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,

1422: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1423: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1424: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1425: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1426: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1427: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1428: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1429: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1430: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,

Line 1427: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,

1423: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1424: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1425: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1426: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1427: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1428: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1429: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1430: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1431: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,

Line 1428: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,

1424: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1425: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1426: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1427: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1428: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1429: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1430: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1431: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1432: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,

Line 1429: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,

1425: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1426: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1427: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1428: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1429: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1430: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1431: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1432: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1433: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,

Line 1430: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,

1426: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1427: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1428: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1429: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1430: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1431: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1432: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1433: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1434: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,

Line 1431: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,

1427: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1428: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1429: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1430: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1431: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1432: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1433: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1434: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1435: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,

Line 1432: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,

1428: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1429: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1430: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1431: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1432: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1433: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1434: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1435: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1436: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,

Line 1433: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,

1429: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1430: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1431: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1432: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1433: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1434: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1435: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1436: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,
1437: GL_INTERFACE_REC.EXCHANGE_RATE_TYPE, -- modified for 3108109

Line 1434: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,

1430: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1431: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1432: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1433: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1434: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1435: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1436: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,
1437: GL_INTERFACE_REC.EXCHANGE_RATE_TYPE, -- modified for 3108109
1438: GL_INTERFACE_REC.ACCOUNTING_DATE,

Line 1435: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,

1431: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1432: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1433: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1434: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1435: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1436: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,
1437: GL_INTERFACE_REC.EXCHANGE_RATE_TYPE, -- modified for 3108109
1438: GL_INTERFACE_REC.ACCOUNTING_DATE,
1439: -- Introduced for Bug 2916848

Line 1436: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,

1432: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1433: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1434: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1435: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1436: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,
1437: GL_INTERFACE_REC.EXCHANGE_RATE_TYPE, -- modified for 3108109
1438: GL_INTERFACE_REC.ACCOUNTING_DATE,
1439: -- Introduced for Bug 2916848
1440: L_RETURN_STATUS);

Line 1437: GL_INTERFACE_REC.EXCHANGE_RATE_TYPE, -- modified for 3108109

1433: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1434: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1435: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1436: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,
1437: GL_INTERFACE_REC.EXCHANGE_RATE_TYPE, -- modified for 3108109
1438: GL_INTERFACE_REC.ACCOUNTING_DATE,
1439: -- Introduced for Bug 2916848
1440: L_RETURN_STATUS);
1441:

Line 1438: GL_INTERFACE_REC.ACCOUNTING_DATE,

1434: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1435: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1436: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,
1437: GL_INTERFACE_REC.EXCHANGE_RATE_TYPE, -- modified for 3108109
1438: GL_INTERFACE_REC.ACCOUNTING_DATE,
1439: -- Introduced for Bug 2916848
1440: L_RETURN_STATUS);
1441:
1442: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1447: END LOOP; -- End of gl_interface_cursor

1443: --dbms_output.put_line('Faaaaaaiiiiiiilllllllleeeeeeeeeddddddd......');
1444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1445: END IF;
1446:
1447: END LOOP; -- End of gl_interface_cursor
1448:
1449: END LOOP; -- End of gl_payroll_control_cursor
1450: CLOSE gl_payroll_control_cursor;
1451:

Line 1479: tabname => 'GL_INTERFACE');

1475: -- Call the gather table statistics here....
1476: BEGIN
1477:
1478: FND_STATS.Gather_Table_Stats(ownname => 'GL',
1479: tabname => 'GL_INTERFACE');
1480: /* commented for , 2476829
1481: percent => 10,
1482: tmode => 'TEMPORARY'); */
1483:

Line 1490: -- insert into gl_interface_control

1486: WHEN others THEN
1487: NULL;
1488: END;
1489:
1490: -- insert into gl_interface_control
1491:
1492: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
1493: INTO l_int_run_id
1494: FROM dual;

Line 1496: INSERT into gl_interface_control(je_source_name,status,interface_run_id,

1492: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
1493: INTO l_int_run_id
1494: FROM dual;
1495:
1496: INSERT into gl_interface_control(je_source_name,status,interface_run_id,
1497: group_id,set_of_books_id)
1498: VALUES (l_user_je_source_name, 'S',l_int_run_id,
1499: l_group_id,p_set_of_books_id);
1500:

Line 1603: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;

1599:
1600: EXCEPTION
1601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1602: --dbms_output.put_line('Gone to one level top ..................');
1603: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1604: p_return_status := fnd_api.g_ret_sts_unexp_error;
1605:
1606: WHEN RETURN_BACK THEN
1607: p_return_status := fnd_api.g_ret_sts_success;

Line 1610: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;

1606: WHEN RETURN_BACK THEN
1607: p_return_status := fnd_api.g_ret_sts_success;
1608:
1609: WHEN OTHERS THEN
1610: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1611: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1612: p_return_status := fnd_api.g_ret_sts_unexp_error;
1613: END;
1614:

Line 1611: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');

1607: p_return_status := fnd_api.g_ret_sts_success;
1608:
1609: WHEN OTHERS THEN
1610: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1611: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1612: p_return_status := fnd_api.g_ret_sts_unexp_error;
1613: END;
1614:
1615: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------

Line 1712: FROM gl_interface

1708:
1709: CURSOR gl_tie_back_reject_cur IS
1710: SELECT status,
1711: reference6
1712: FROM gl_interface
1713: WHERE group_id = p_group_id
1714: AND set_of_books_id = p_set_of_books_id
1715: AND user_je_source_name = 'OLD'
1716: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

Line 1834: l_cnt_gl_interface NUMBER;

1830: --
1831: l_status VARCHAR2(50);
1832: l_reference6 VARCHAR2(100);
1833: --
1834: l_cnt_gl_interface NUMBER;
1835: l_summary_line_id NUMBER(10);
1836: l_gl_project_flag VARCHAR2(1);
1837: l_suspense_ac_failed VARCHAR2(1) := 'N';
1838: l_reversal_ac_failed VARCHAR2(1) := 'N';

Line 1916: from gl_interface

1912: BEGIN
1913:
1914: select count(*)
1915: into l_no_run
1916: from gl_interface
1917: where status = 'NEW'
1918: and group_id = p_group_id
1919: and user_je_source_name = 'OLD'
1920: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

Line 1926: delete from gl_interface

1922: AND payroll_control_id = p_payroll_control_id);
1923:
1924: if l_no_run > 0 then
1925:
1926: delete from gl_interface
1927: where group_id = p_group_id
1928: and user_je_source_name = 'OLD'
1929: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898
1930: WHERE GROUP_ID = p_group_id

Line 1947: delete gl_interface_Control

1943: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: END IF;
1946:
1947: delete gl_interface_Control
1948: where group_id = p_group_id
1949: and je_source_name = l_user_je_source_name;
1950:
1951: update psp_payroll_controls

Line 1969: INTO l_cnt_gl_interface

1965:
1966: end if;
1967:
1968: SELECT count(*)
1969: INTO l_cnt_gl_interface
1970: FROM gl_interface
1971: WHERE group_id = p_group_id
1972: AND user_je_source_name = 'OLD'
1973: AND set_of_books_id = p_set_of_books_id

Line 1970: FROM gl_interface

1966: end if;
1967:
1968: SELECT count(*)
1969: INTO l_cnt_gl_interface
1970: FROM gl_interface
1971: WHERE group_id = p_group_id
1972: AND user_je_source_name = 'OLD'
1973: AND set_of_books_id = p_set_of_books_id
1974: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

Line 1987: IF l_cnt_gl_interface > 0 THEN

1983: UPDATE psp_payroll_controls
1984: SET phase = 'GL_Tie_Back'
1985: WHERE payroll_control_id = p_payroll_control_id;
1986:
1987: IF l_cnt_gl_interface > 0 THEN
1988: --
1989: OPEN gl_tie_back_reject_cur;
1990: LOOP
1991: FETCH gl_tie_back_reject_cur INTO l_status,l_reference6;

Line 2246: ---2445196: cleanup gl interface b'cos rejection is available in rejected summary lines

2242:
2243:
2244: END LOOP;
2245: END LOOP;
2246: ---2445196: cleanup gl interface b'cos rejection is available in rejected summary lines
2247: get_gl_je_sources(l_user_je_source_name,
2248: l_return_status);
2249: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2253: delete gl_interface

2249: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2251: END IF;
2252:
2253: delete gl_interface
2254: where group_id = p_group_id
2255: and set_of_books_id = p_set_of_books_id
2256: AND user_je_source_name = l_user_je_source_name
2257: and reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

Line 2398: ELSIF l_cnt_gl_interface = 0 and l_no_run = 0 THEN

2394: end if;
2395: END IF;
2396:
2397:
2398: ELSIF l_cnt_gl_interface = 0 and l_no_run = 0 THEN
2399: --
2400: OPEN gl_tie_back_success_cur;
2401: LOOP
2402: FETCH gl_tie_back_success_cur INTO l_summary_line_id,

Line 2767: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------

2763: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');
2764: p_return_status := fnd_api.g_ret_sts_unexp_error;
2765: END;
2766:
2767: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------
2768:
2769: PROCEDURE insert_into_gl_interface(
2770: P_SET_OF_BOOKS_ID IN NUMBER,
2771: P_ACCOUNTING_DATE IN DATE,

Line 2769: PROCEDURE insert_into_gl_interface(

2765: END;
2766:
2767: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------
2768:
2769: PROCEDURE insert_into_gl_interface(
2770: P_SET_OF_BOOKS_ID IN NUMBER,
2771: P_ACCOUNTING_DATE IN DATE,
2772: P_CURRENCY_CODE IN VARCHAR2,
2773: P_USER_JE_CATEGORY_NAME IN VARCHAR2,

Line 2826: INSERT INTO GL_INTERFACE(

2822: -- dbms_output.put_line('curren='||p_currency_code);
2823: --dbms_output.put_line('category='||p_user_je_category_name);
2824: --dbms_output.put_line('source='||p_user_je_source_name);
2825:
2826: INSERT INTO GL_INTERFACE(
2827: STATUS,
2828: SET_OF_BOOKS_ID,
2829: ACCOUNTING_DATE,
2830: CURRENCY_CODE,

Line 2931: --dbms_output.put_line('DDDDDDDDDDDDDDDDDGL Interface Inserted ....................');

2927: P_ATTRIBUTE29,
2928: P_ATTRIBUTE30,
2929: P_CURRENCY_CONVERSION_TYPE,-- Introduced the following code for Bug fix 2916848
2930: DECODE(p_currency_conversion_type, NULL, NULL, P_CURRENCY_CONVERSION_DATE));-- Introduced the following code for Bug fix 2916848
2931: --dbms_output.put_line('DDDDDDDDDDDDDDDDDGL Interface Inserted ....................');
2932: p_return_status := fnd_api.g_ret_sts_success;
2933: EXCEPTION
2934: WHEN OTHERS THEN
2935: --dbms_output.put_line('Error while inserting .........................');

Line 2936: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;

2932: p_return_status := fnd_api.g_ret_sts_success;
2933: EXCEPTION
2934: WHEN OTHERS THEN
2935: --dbms_output.put_line('Error while inserting .........................');
2936: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;
2937: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');
2938: p_return_status := fnd_api.g_ret_sts_unexp_error;
2939: END;
2940:

Line 2937: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');

2933: EXCEPTION
2934: WHEN OTHERS THEN
2935: --dbms_output.put_line('Error while inserting .........................');
2936: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;
2937: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');
2938: p_return_status := fnd_api.g_ret_sts_unexp_error;
2939: END;
2940:
2941: -------------------- CREATE GMS SUM LINES -----------------------------------------------