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

Line 126: transfer_to_gl_interface(p_adj_sum_batch_name,

122: if g_run_type = 'R' then
123: check_interface_status('GL', p_adj_sum_batch_name);
124: end if;
125:
126: transfer_to_gl_interface(p_adj_sum_batch_name,
127: p_business_group_id,
128: p_set_of_books_id,
129: l_return_status);
130:

Line 1087: ------------------------ GL INTERFACE --------------------------------------------------

1083: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_SUMMARY_LINES');
1084: p_return_status := fnd_api.g_ret_sts_unexp_error;
1085: END;
1086:
1087: ------------------------ GL INTERFACE --------------------------------------------------
1088:
1089: PROCEDURE transfer_to_gl_interface(p_adj_sum_batch_name IN VARCHAR2,
1090: p_business_group_id IN NUMBER,
1091: p_set_of_books_id IN NUMBER,

Line 1089: PROCEDURE transfer_to_gl_interface(p_adj_sum_batch_name IN VARCHAR2,

1085: END;
1086:
1087: ------------------------ GL INTERFACE --------------------------------------------------
1088:
1089: PROCEDURE transfer_to_gl_interface(p_adj_sum_batch_name IN VARCHAR2,
1090: p_business_group_id IN NUMBER,
1091: p_set_of_books_id IN NUMBER,
1092: p_return_status OUT NOCOPY VARCHAR2) IS
1093:

Line 1124: CURSOR gl_interface_cursor(p_payroll_control_id IN NUMBER) IS

1120: AND gl_phase = 'Summarize_GL_Lines'
1121: AND run_id = g_run_id;
1122:
1123:
1124: CURSOR gl_interface_cursor(p_payroll_control_id IN NUMBER) IS
1125: SELECT psl.summary_line_id,
1126: psl.source_code,
1127: psl.effective_date,
1128: psl.accounting_date, --- added for 3108109

Line 1171: gl_interface_rec gl_interface_cursor%ROWTYPE;

1167: AND psl.gl_code_combination_id IS NOT NULL
1168: AND psl.payroll_control_id = p_payroll_control_id;
1169:
1170: gl_batch_rec gl_batch_cursor%ROWTYPE;
1171: gl_interface_rec gl_interface_cursor%ROWTYPE;
1172: -- l_sob_id NUMBER(15) := FND_PROFILE.VALUE('PSP_SET_OF_BOOKS');
1173: l_sob_id NUMBER(15) := p_set_of_books_id;
1174: l_user_je_source_name VARCHAR2(25);
1175: l_user_je_category_name VARCHAR2(25);

Line 1254: SELECT gl_interface_control_s.nextval

1250: close pc_batch_cur;
1251: exit;
1252: end if;
1253: -- get the group_id. Moved the group id out of payroll control id loop. Bug 1977939
1254: SELECT gl_interface_control_s.nextval
1255: INTO l_group_id
1256: FROM DUAL;
1257:
1258: l_rec_count := 0; -- MOVED this stmt, from inside the payroll control loop id Bug 1977939.

Line 1315: OPEN gl_interface_cursor(gl_batch_rec.payroll_control_id);

1311: IF gl_batch_rec.source_type = 'A' THEN
1312: l_reference4 := 'LD ADJUSTMENTS DISTRIBUTION';
1313: END IF;
1314:
1315: OPEN gl_interface_cursor(gl_batch_rec.payroll_control_id);
1316: LOOP
1317: FETCH gl_interface_cursor INTO gl_interface_rec;
1318: IF gl_interface_cursor%NOTFOUND THEN
1319: CLOSE gl_interface_cursor;

Line 1317: FETCH gl_interface_cursor INTO gl_interface_rec;

1313: END IF;
1314:
1315: OPEN gl_interface_cursor(gl_batch_rec.payroll_control_id);
1316: LOOP
1317: FETCH gl_interface_cursor INTO gl_interface_rec;
1318: IF gl_interface_cursor%NOTFOUND THEN
1319: CLOSE gl_interface_cursor;
1320: EXIT;
1321: END IF;

Line 1318: IF gl_interface_cursor%NOTFOUND THEN

1314:
1315: OPEN gl_interface_cursor(gl_batch_rec.payroll_control_id);
1316: LOOP
1317: FETCH gl_interface_cursor INTO gl_interface_rec;
1318: IF gl_interface_cursor%NOTFOUND THEN
1319: CLOSE gl_interface_cursor;
1320: EXIT;
1321: END IF;
1322:

Line 1319: CLOSE gl_interface_cursor;

1315: OPEN gl_interface_cursor(gl_batch_rec.payroll_control_id);
1316: LOOP
1317: FETCH gl_interface_cursor INTO gl_interface_rec;
1318: IF gl_interface_cursor%NOTFOUND THEN
1319: CLOSE gl_interface_cursor;
1320: EXIT;
1321: END IF;
1322:
1323: --l_batch_cnt := l_batch_cnt + 1; commented for Bug 1977939

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

1322:
1323: --l_batch_cnt := l_batch_cnt + 1; commented for Bug 1977939
1324:
1325: l_rec_count := l_rec_count + 1;
1326: IF gl_interface_rec.dr_cr_flag = 'D' THEN
1327: l_entered_dr := gl_interface_rec.summary_amount;
1328: l_entered_cr := NULL;
1329: ELSIF gl_interface_rec.dr_cr_flag = 'C' THEN
1330: l_entered_dr := NULL;

Line 1327: l_entered_dr := gl_interface_rec.summary_amount;

1323: --l_batch_cnt := l_batch_cnt + 1; commented for Bug 1977939
1324:
1325: l_rec_count := l_rec_count + 1;
1326: IF gl_interface_rec.dr_cr_flag = 'D' THEN
1327: l_entered_dr := gl_interface_rec.summary_amount;
1328: l_entered_cr := NULL;
1329: ELSIF gl_interface_rec.dr_cr_flag = 'C' THEN
1330: l_entered_dr := NULL;
1331: l_entered_cr := gl_interface_rec.summary_amount;

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

1325: l_rec_count := l_rec_count + 1;
1326: IF gl_interface_rec.dr_cr_flag = 'D' THEN
1327: l_entered_dr := gl_interface_rec.summary_amount;
1328: l_entered_cr := NULL;
1329: ELSIF gl_interface_rec.dr_cr_flag = 'C' THEN
1330: l_entered_dr := NULL;
1331: l_entered_cr := gl_interface_rec.summary_amount;
1332: END IF;
1333:

Line 1331: l_entered_cr := gl_interface_rec.summary_amount;

1327: l_entered_dr := gl_interface_rec.summary_amount;
1328: l_entered_cr := NULL;
1329: ELSIF gl_interface_rec.dr_cr_flag = 'C' THEN
1330: l_entered_dr := NULL;
1331: l_entered_cr := gl_interface_rec.summary_amount;
1332: END IF;
1333:
1334: -- Corrected currency_code reference and introduced exchange_rate_type and conversion_date for bug fix 2916848
1335: insert_into_gl_interface(

Line 1335: insert_into_gl_interface(

1331: l_entered_cr := gl_interface_rec.summary_amount;
1332: END IF;
1333:
1334: -- Corrected currency_code reference and introduced exchange_rate_type and conversion_date for bug fix 2916848
1335: insert_into_gl_interface(
1336: L_SOB_ID,GL_INTERFACE_REC.EFFECTIVE_DATE, gl_batch_rec.currency_code,
1337: L_USER_JE_CATEGORY_NAME,L_USER_JE_SOURCE_NAME,L_ENCUMBRANCE_TYPE_ID,
1338: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,
1339: L_GROUP_ID,L_REFERENCE1,L_REFERENCE1,L_REFERENCE4,

Line 1336: L_SOB_ID,GL_INTERFACE_REC.EFFECTIVE_DATE, gl_batch_rec.currency_code,

1332: END IF;
1333:
1334: -- Corrected currency_code reference and introduced exchange_rate_type and conversion_date for bug fix 2916848
1335: insert_into_gl_interface(
1336: L_SOB_ID,GL_INTERFACE_REC.EFFECTIVE_DATE, gl_batch_rec.currency_code,
1337: L_USER_JE_CATEGORY_NAME,L_USER_JE_SOURCE_NAME,L_ENCUMBRANCE_TYPE_ID,
1338: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,
1339: L_GROUP_ID,L_REFERENCE1,L_REFERENCE1,L_REFERENCE4,
1340: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,

Line 1338: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,

1334: -- Corrected currency_code reference and introduced exchange_rate_type and conversion_date for bug fix 2916848
1335: insert_into_gl_interface(
1336: L_SOB_ID,GL_INTERFACE_REC.EFFECTIVE_DATE, gl_batch_rec.currency_code,
1337: L_USER_JE_CATEGORY_NAME,L_USER_JE_SOURCE_NAME,L_ENCUMBRANCE_TYPE_ID,
1338: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,
1339: L_GROUP_ID,L_REFERENCE1,L_REFERENCE1,L_REFERENCE4,
1340: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,
1341: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1342: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,

Line 1340: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,

1336: L_SOB_ID,GL_INTERFACE_REC.EFFECTIVE_DATE, gl_batch_rec.currency_code,
1337: L_USER_JE_CATEGORY_NAME,L_USER_JE_SOURCE_NAME,L_ENCUMBRANCE_TYPE_ID,
1338: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,
1339: L_GROUP_ID,L_REFERENCE1,L_REFERENCE1,L_REFERENCE4,
1340: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,
1341: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1342: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1343: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1344: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,

Line 1341: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,

1337: L_USER_JE_CATEGORY_NAME,L_USER_JE_SOURCE_NAME,L_ENCUMBRANCE_TYPE_ID,
1338: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,
1339: L_GROUP_ID,L_REFERENCE1,L_REFERENCE1,L_REFERENCE4,
1340: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,
1341: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1342: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1343: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1344: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1345: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,

Line 1342: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,

1338: GL_INTERFACE_REC.GL_CODE_COMBINATION_ID,L_ENTERED_DR,L_ENTERED_CR,
1339: L_GROUP_ID,L_REFERENCE1,L_REFERENCE1,L_REFERENCE4,
1340: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,
1341: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1342: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1343: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1344: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1345: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1346: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,

Line 1343: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,

1339: L_GROUP_ID,L_REFERENCE1,L_REFERENCE1,L_REFERENCE4,
1340: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,
1341: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1342: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1343: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1344: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1345: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1346: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1347: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,

Line 1344: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,

1340: GL_INTERFACE_REC.SUMMARY_LINE_ID,L_REFERENCE4,
1341: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1342: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1343: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1344: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1345: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1346: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1347: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1348: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,

Line 1345: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,

1341: GL_INTERFACE_REC.ATTRIBUTE1,GL_INTERFACE_REC.ATTRIBUTE2,
1342: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1343: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1344: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1345: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1346: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1347: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1348: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1349: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,

Line 1346: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,

1342: GL_INTERFACE_REC.ATTRIBUTE3,GL_INTERFACE_REC.ATTRIBUTE4,
1343: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1344: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1345: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1346: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1347: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1348: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1349: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1350: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,

Line 1347: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,

1343: GL_INTERFACE_REC.ATTRIBUTE5,GL_INTERFACE_REC.ATTRIBUTE6,
1344: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1345: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1346: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1347: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1348: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1349: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1350: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1351: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,

Line 1348: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,

1344: GL_INTERFACE_REC.ATTRIBUTE7,GL_INTERFACE_REC.ATTRIBUTE8,
1345: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1346: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1347: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1348: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1349: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1350: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1351: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1352: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,

Line 1349: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,

1345: GL_INTERFACE_REC.ATTRIBUTE9,GL_INTERFACE_REC.ATTRIBUTE10,
1346: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1347: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1348: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1349: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1350: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1351: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1352: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1353: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,

Line 1350: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,

1346: GL_INTERFACE_REC.ATTRIBUTE11,GL_INTERFACE_REC.ATTRIBUTE12,
1347: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1348: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1349: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1350: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1351: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1352: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1353: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1354: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,

Line 1351: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,

1347: GL_INTERFACE_REC.ATTRIBUTE13,GL_INTERFACE_REC.ATTRIBUTE14,
1348: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1349: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1350: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1351: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1352: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1353: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1354: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1355: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,

Line 1352: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,

1348: GL_INTERFACE_REC.ATTRIBUTE15,GL_INTERFACE_REC.ATTRIBUTE16,
1349: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1350: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1351: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1352: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1353: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1354: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1355: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,
1356: gl_interface_rec.exchange_rate_type,

Line 1353: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,

1349: GL_INTERFACE_REC.ATTRIBUTE17,GL_INTERFACE_REC.ATTRIBUTE18,
1350: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1351: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1352: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1353: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1354: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1355: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,
1356: gl_interface_rec.exchange_rate_type,
1357: GL_INTERFACE_REC.accounting_date, --- added for 3108109

Line 1354: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,

1350: GL_INTERFACE_REC.ATTRIBUTE19,GL_INTERFACE_REC.ATTRIBUTE20,
1351: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1352: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1353: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1354: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1355: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,
1356: gl_interface_rec.exchange_rate_type,
1357: GL_INTERFACE_REC.accounting_date, --- added for 3108109
1358: L_RETURN_STATUS);

Line 1355: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,

1351: GL_INTERFACE_REC.ATTRIBUTE21,GL_INTERFACE_REC.ATTRIBUTE22,
1352: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1353: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1354: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1355: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,
1356: gl_interface_rec.exchange_rate_type,
1357: GL_INTERFACE_REC.accounting_date, --- added for 3108109
1358: L_RETURN_STATUS);
1359:

Line 1356: gl_interface_rec.exchange_rate_type,

1352: GL_INTERFACE_REC.ATTRIBUTE23,GL_INTERFACE_REC.ATTRIBUTE24,
1353: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1354: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1355: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,
1356: gl_interface_rec.exchange_rate_type,
1357: GL_INTERFACE_REC.accounting_date, --- added for 3108109
1358: L_RETURN_STATUS);
1359:
1360: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1357: GL_INTERFACE_REC.accounting_date, --- added for 3108109

1353: GL_INTERFACE_REC.ATTRIBUTE25,GL_INTERFACE_REC.ATTRIBUTE26,
1354: GL_INTERFACE_REC.ATTRIBUTE27,GL_INTERFACE_REC.ATTRIBUTE28,
1355: GL_INTERFACE_REC.ATTRIBUTE29,GL_INTERFACE_REC.ATTRIBUTE30,
1356: gl_interface_rec.exchange_rate_type,
1357: GL_INTERFACE_REC.accounting_date, --- added for 3108109
1358: L_RETURN_STATUS);
1359:
1360: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1374: tabname => 'GL_INTERFACE');

1370: -- Gather the table statistics here ...
1371:
1372: begin
1373: FND_STATS.Gather_Table_Stats (ownname => 'GL',
1374: tabname => 'GL_INTERFACE');
1375: -- percent => 10,
1376: -- tmode => 'TEMPORARY');
1377: -- Above two parameters commented out for bug fix 2476829
1378:

Line 1385: -- insert into gl_interface_control

1381: null;
1382:
1383: end;
1384:
1385: -- insert into gl_interface_control
1386: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
1387: INTO l_int_run_id
1388: FROM DUAL;
1389:

Line 1390: insert into gl_interface_control(

1386: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
1387: INTO l_int_run_id
1388: FROM DUAL;
1389:
1390: insert into gl_interface_control(
1391: je_source_name,
1392: status,
1393: interface_run_id,
1394: group_id,

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

1440: --
1441: p_return_status := fnd_api.g_ret_sts_success;
1442: EXCEPTION
1443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1444: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1445: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1446: p_return_status := fnd_api.g_ret_sts_unexp_error;
1447:
1448: WHEN RETURN_BACK THEN

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

1441: p_return_status := fnd_api.g_ret_sts_success;
1442: EXCEPTION
1443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1444: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1445: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1446: p_return_status := fnd_api.g_ret_sts_unexp_error;
1447:
1448: WHEN RETURN_BACK THEN
1449: p_return_status := fnd_api.g_ret_sts_success;

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

1448: WHEN RETURN_BACK THEN
1449: p_return_status := fnd_api.g_ret_sts_success;
1450:
1451: WHEN OTHERS THEN
1452: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1453: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1454: p_return_status := fnd_api.g_ret_sts_unexp_error;
1455: END;
1456:

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

1449: p_return_status := fnd_api.g_ret_sts_success;
1450:
1451: WHEN OTHERS THEN
1452: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1453: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1454: p_return_status := fnd_api.g_ret_sts_unexp_error;
1455: END;
1456:
1457: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------

Line 1612: l_cnt_gl_interface NUMBER;

1608: --
1609: l_status VARCHAR2(50);
1610: l_reference6 VARCHAR2(100);
1611: --
1612: l_cnt_gl_interface NUMBER;
1613: l_summary_line_id NUMBER(10);
1614: l_gl_project_flag VARCHAR2(1);
1615: l_reversal_ac_failed VARCHAR2(1) := 'N';
1616: l_summary_amount NUMBER;

Line 1650: CURSOR gl_interface_group_cur IS

1646: AND PPC.source_type = 'A'
1647: AND PSL.group_id IS NOT NULL
1648: AND rownum =1; -- Removed max function on group_id and introduced rownum=1 Bug 2133056
1649:
1650: CURSOR gl_interface_group_cur IS
1651: SELECT count(*)
1652: FROM gl_interface
1653: WHERE group_id = l_group_id
1654: AND set_of_books_id = p_set_of_books_id

Line 1652: FROM gl_interface

1648: AND rownum =1; -- Removed max function on group_id and introduced rownum=1 Bug 2133056
1649:
1650: CURSOR gl_interface_group_cur IS
1651: SELECT count(*)
1652: FROM gl_interface
1653: WHERE group_id = l_group_id
1654: AND set_of_books_id = p_set_of_books_id
1655: AND user_je_source_name = 'OLD';
1656:

Line 1658: CURSOR gl_interface_status_cur IS

1654: AND set_of_books_id = p_set_of_books_id
1655: AND user_je_source_name = 'OLD';
1656:
1657: -- Bug 2133056: Changes related to handle situation of GL import leaving some xface recs in 'NEW'
1658: CURSOR gl_interface_status_cur IS
1659: SELECT count(*)
1660: FROM gl_interface
1661: WHERE group_id = l_group_id
1662: AND user_je_source_name = 'OLD'

Line 1660: FROM gl_interface

1656:
1657: -- Bug 2133056: Changes related to handle situation of GL import leaving some xface recs in 'NEW'
1658: CURSOR gl_interface_status_cur IS
1659: SELECT count(*)
1660: FROM gl_interface
1661: WHERE group_id = l_group_id
1662: AND user_je_source_name = 'OLD'
1663: AND status = 'NEW';
1664: l_status_new integer;

Line 1689: OPEN gl_interface_status_cur;

1685: END IF;
1686: CLOSE summary_group_cur;
1687:
1688: /* Bug 2133056: to handle situation of GL import left lines untouched */
1689: OPEN gl_interface_status_cur;
1690: FETCH gl_interface_status_cur INTO l_status_new;
1691: IF (gl_interface_status_cur%NOTFOUND) THEN
1692: CLOSE gl_interface_status_cur;
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1690: FETCH gl_interface_status_cur INTO l_status_new;

1686: CLOSE summary_group_cur;
1687:
1688: /* Bug 2133056: to handle situation of GL import left lines untouched */
1689: OPEN gl_interface_status_cur;
1690: FETCH gl_interface_status_cur INTO l_status_new;
1691: IF (gl_interface_status_cur%NOTFOUND) THEN
1692: CLOSE gl_interface_status_cur;
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END IF;

Line 1691: IF (gl_interface_status_cur%NOTFOUND) THEN

1687:
1688: /* Bug 2133056: to handle situation of GL import left lines untouched */
1689: OPEN gl_interface_status_cur;
1690: FETCH gl_interface_status_cur INTO l_status_new;
1691: IF (gl_interface_status_cur%NOTFOUND) THEN
1692: CLOSE gl_interface_status_cur;
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END IF;
1695: CLOSE gl_interface_status_cur;

Line 1692: CLOSE gl_interface_status_cur;

1688: /* Bug 2133056: to handle situation of GL import left lines untouched */
1689: OPEN gl_interface_status_cur;
1690: FETCH gl_interface_status_cur INTO l_status_new;
1691: IF (gl_interface_status_cur%NOTFOUND) THEN
1692: CLOSE gl_interface_status_cur;
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END IF;
1695: CLOSE gl_interface_status_cur;
1696:

Line 1695: CLOSE gl_interface_status_cur;

1691: IF (gl_interface_status_cur%NOTFOUND) THEN
1692: CLOSE gl_interface_status_cur;
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END IF;
1695: CLOSE gl_interface_status_cur;
1696:
1697: if l_status_new > 0 then
1698: update psp_payroll_controls
1699: set gl_phase = 'Summarize_GL_Lines'

Line 1704: delete from gl_interface

1700: where gl_phase = 'Submitted_Import_Request'
1701: and batch_name = pc_batch_rec.batch_name; --- 3184075
1702: ---and adj_sum_batch_name = p_adj_sum_batch_name;
1703:
1704: delete from gl_interface
1705: where group_id = l_group_id
1706: and user_je_source_name = 'OLD';
1707:
1708: delete from gl_interface_control

Line 1708: delete from gl_interface_control

1704: delete from gl_interface
1705: where group_id = l_group_id
1706: and user_je_source_name = 'OLD';
1707:
1708: delete from gl_interface_control
1709: where group_id = l_group_id
1710: and je_source_name = 'OLD';
1711:
1712: commit;

Line 1735: OPEN gl_interface_group_cur;

1731:
1732: -- Replaced the earlier 'select stmt.' code with new 'cursor' code for bug fix 1765678
1733:
1734:
1735: OPEN gl_interface_group_cur;
1736: FETCH gl_interface_group_cur INTO l_cnt_gl_interface;
1737: IF (gl_interface_group_cur%NOTFOUND) THEN
1738: CLOSE gl_interface_group_cur;
1739: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;

Line 1736: FETCH gl_interface_group_cur INTO l_cnt_gl_interface;

1732: -- Replaced the earlier 'select stmt.' code with new 'cursor' code for bug fix 1765678
1733:
1734:
1735: OPEN gl_interface_group_cur;
1736: FETCH gl_interface_group_cur INTO l_cnt_gl_interface;
1737: IF (gl_interface_group_cur%NOTFOUND) THEN
1738: CLOSE gl_interface_group_cur;
1739: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
1740: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');

Line 1737: IF (gl_interface_group_cur%NOTFOUND) THEN

1733:
1734:
1735: OPEN gl_interface_group_cur;
1736: FETCH gl_interface_group_cur INTO l_cnt_gl_interface;
1737: IF (gl_interface_group_cur%NOTFOUND) THEN
1738: CLOSE gl_interface_group_cur;
1739: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
1740: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
1741: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1738: CLOSE gl_interface_group_cur;

1734:
1735: OPEN gl_interface_group_cur;
1736: FETCH gl_interface_group_cur INTO l_cnt_gl_interface;
1737: IF (gl_interface_group_cur%NOTFOUND) THEN
1738: CLOSE gl_interface_group_cur;
1739: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
1740: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
1741: p_return_status := fnd_api.g_ret_sts_unexp_error;
1742: EXIT;

Line 1744: CLOSE gl_interface_group_cur;

1740: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
1741: p_return_status := fnd_api.g_ret_sts_unexp_error;
1742: EXIT;
1743: END IF;
1744: CLOSE gl_interface_group_cur;
1745:
1746: IF l_cnt_gl_interface > 0 THEN
1747:
1748:

Line 1746: IF l_cnt_gl_interface > 0 THEN

1742: EXIT;
1743: END IF;
1744: CLOSE gl_interface_group_cur;
1745:
1746: IF l_cnt_gl_interface > 0 THEN
1747:
1748:
1749: fnd_message.set_name('PSP','PSP_ADJ_GL_FAILED');
1750: get_the_batch_details(pc_batch_rec.batch_name, l_return_status);

Line 1759: ELSIF l_cnt_gl_interface = 0 THEN

1755: -- Uncommented the following code as the code would fail if more than one GL batch fails along bug fix 1828519
1756: close gl_tie_back_cur;
1757: exit;
1758:
1759: ELSIF l_cnt_gl_interface = 0 THEN
1760: OPEN gl_tie_back_success_cur(l_group_id,gl_tie_back_rec.payroll_control_id); --Added control id for 2133056
1761: l_dr_summary_amount := 0; --- Bug 2133056, initialized the amounts
1762: l_cr_summary_amount := 0;
1763: LOOP

Line 2068: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------

2064: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');
2065: p_return_status := fnd_api.g_ret_sts_unexp_error;
2066: END;
2067:
2068: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------
2069:
2070: PROCEDURE insert_into_gl_interface(
2071: P_SET_OF_BOOKS_ID IN NUMBER,
2072: P_ACCOUNTING_DATE IN DATE,

Line 2070: PROCEDURE insert_into_gl_interface(

2066: END;
2067:
2068: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------
2069:
2070: PROCEDURE insert_into_gl_interface(
2071: P_SET_OF_BOOKS_ID IN NUMBER,
2072: P_ACCOUNTING_DATE IN DATE,
2073: P_CURRENCY_CODE IN VARCHAR2,
2074: P_USER_JE_CATEGORY_NAME IN VARCHAR2,

Line 2121: INSERT INTO GL_INTERFACE(

2117: P_CURRENCY_CONVERSION_DATE IN DATE, -- Introduced for bug fix 2916848
2118: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
2119: l_msg_id number(9);
2120: BEGIN
2121: INSERT INTO GL_INTERFACE(
2122: STATUS,
2123: SET_OF_BOOKS_ID,
2124: ACCOUNTING_DATE,
2125: CURRENCY_CODE,

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

2227: --
2228: p_return_status := fnd_api.g_ret_sts_success;
2229: EXCEPTION
2230: WHEN OTHERS THEN
2231: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;
2232: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');
2233: p_return_status := fnd_api.g_ret_sts_unexp_error;
2234: END;
2235:

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

2228: p_return_status := fnd_api.g_ret_sts_success;
2229: EXCEPTION
2230: WHEN OTHERS THEN
2231: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;
2232: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');
2233: p_return_status := fnd_api.g_ret_sts_unexp_error;
2234: END;
2235:
2236: -------------------- CREATE GMS SUM LINES -----------------------------------------------

Line 4163: delete from gl_interface

4159: END IF;
4160:
4161: -- Used the group_id parameter, instead of deriving it from summary lines table: Bug 2133056
4162: -- Removed all other deletion of gl tables, because of bug 2133056 fix.
4163: delete from gl_interface
4164: where user_je_source_name = l_user_je_source_name
4165: and group_id = p_group_id ;
4166:
4167: --- Added this stmt for Bug 2133056

Line 4168: delete from gl_interface_control

4164: where user_je_source_name = l_user_je_source_name
4165: and group_id = p_group_id ;
4166:
4167: --- Added this stmt for Bug 2133056
4168: delete from gl_interface_control
4169: where je_source_name = l_user_je_source_name
4170: and group_id = p_group_id;
4171:
4172: end if;

Line 4260: CURSOR gl_interface_status_cur IS

4256: FROM psp_summary_lines
4257: WHERE payroll_control_id = payroll_control_rec.payroll_control_id
4258: AND group_id IS NOT NULL;
4259:
4260: CURSOR gl_interface_status_cur IS
4261: SELECT count(*)
4262: FROM gl_interface
4263: WHERE group_id = l_group_id
4264: AND user_je_source_name = 'OLD'

Line 4262: FROM gl_interface

4258: AND group_id IS NOT NULL;
4259:
4260: CURSOR gl_interface_status_cur IS
4261: SELECT count(*)
4262: FROM gl_interface
4263: WHERE group_id = l_group_id
4264: AND user_je_source_name = 'OLD'
4265: AND status = 'NEW';
4266:

Line 4316: OPEN gl_interface_status_cur;

4312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4313: END IF;
4314: CLOSE summary_group_cur;
4315:
4316: OPEN gl_interface_status_cur;
4317: FETCH gl_interface_status_cur INTO l_status_new;
4318: IF (gl_interface_status_cur%NOTFOUND) THEN
4319: CLOSE gl_interface_status_cur;
4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4317: FETCH gl_interface_status_cur INTO l_status_new;

4313: END IF;
4314: CLOSE summary_group_cur;
4315:
4316: OPEN gl_interface_status_cur;
4317: FETCH gl_interface_status_cur INTO l_status_new;
4318: IF (gl_interface_status_cur%NOTFOUND) THEN
4319: CLOSE gl_interface_status_cur;
4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4321: END IF;

Line 4318: IF (gl_interface_status_cur%NOTFOUND) THEN

4314: CLOSE summary_group_cur;
4315:
4316: OPEN gl_interface_status_cur;
4317: FETCH gl_interface_status_cur INTO l_status_new;
4318: IF (gl_interface_status_cur%NOTFOUND) THEN
4319: CLOSE gl_interface_status_cur;
4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4321: END IF;
4322: CLOSE gl_interface_status_cur;

Line 4319: CLOSE gl_interface_status_cur;

4315:
4316: OPEN gl_interface_status_cur;
4317: FETCH gl_interface_status_cur INTO l_status_new;
4318: IF (gl_interface_status_cur%NOTFOUND) THEN
4319: CLOSE gl_interface_status_cur;
4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4321: END IF;
4322: CLOSE gl_interface_status_cur;
4323:

Line 4322: CLOSE gl_interface_status_cur;

4318: IF (gl_interface_status_cur%NOTFOUND) THEN
4319: CLOSE gl_interface_status_cur;
4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4321: END IF;
4322: CLOSE gl_interface_status_cur;
4323:
4324: if l_status_new > 0 then
4325: update psp_payroll_controls
4326: set gl_phase = 'Summarize_GL_Lines'

Line 4330: delete from gl_interface

4326: set gl_phase = 'Summarize_GL_Lines'
4327: where gl_phase = 'Submitted_Import_Request'
4328: and payroll_control_id = payroll_control_rec.payroll_control_id;
4329:
4330: delete from gl_interface
4331: where group_id = l_group_id
4332: and user_je_source_name = 'OLD';
4333:
4334: delete from gl_interface_control

Line 4334: delete from gl_interface_control

4330: delete from gl_interface
4331: where group_id = l_group_id
4332: and user_je_source_name = 'OLD';
4333:
4334: delete from gl_interface_control
4335: where group_id = l_group_id
4336: and je_source_name = 'OLD';
4337: end if;
4338: