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.PAY_IN_SOE dependencies on DBMS_SQL

Line 1357: l_sql_csr := dbms_sql.open_cursor;

1353: --
1354: l_stmt := l_stmt || l_sort_by;
1355:
1356: pay_in_utils.trace('Before Open Cursor',20);
1357: l_sql_csr := dbms_sql.open_cursor;
1358:
1359: pay_in_utils.set_location(g_debug,'Before parse',30);
1360: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1361: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);

Line 1360: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);

1356: pay_in_utils.trace('Before Open Cursor',20);
1357: l_sql_csr := dbms_sql.open_cursor;
1358:
1359: pay_in_utils.set_location(g_debug,'Before parse',30);
1360: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1361: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
1362: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1363: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1364: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);

Line 1361: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);

1357: l_sql_csr := dbms_sql.open_cursor;
1358:
1359: pay_in_utils.set_location(g_debug,'Before parse',30);
1360: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1361: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
1362: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1363: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1364: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1365: dbms_sql.define_column(l_sql_csr,5,l_dob);

Line 1362: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);

1358:
1359: pay_in_utils.set_location(g_debug,'Before parse',30);
1360: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1361: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
1362: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1363: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1364: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1365: dbms_sql.define_column(l_sql_csr,5,l_dob);
1366: dbms_sql.define_column(l_sql_csr,6,l_joining_date);

Line 1363: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);

1359: pay_in_utils.set_location(g_debug,'Before parse',30);
1360: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1361: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
1362: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1363: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1364: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1365: dbms_sql.define_column(l_sql_csr,5,l_dob);
1366: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1367: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);

Line 1364: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);

1360: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1361: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
1362: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1363: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1364: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1365: dbms_sql.define_column(l_sql_csr,5,l_dob);
1366: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1367: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1368: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);

Line 1365: dbms_sql.define_column(l_sql_csr,5,l_dob);

1361: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
1362: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1363: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1364: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1365: dbms_sql.define_column(l_sql_csr,5,l_dob);
1366: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1367: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1368: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1369: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);

Line 1366: dbms_sql.define_column(l_sql_csr,6,l_joining_date);

1362: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1363: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1364: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1365: dbms_sql.define_column(l_sql_csr,5,l_dob);
1366: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1367: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1368: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1369: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1370: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);

Line 1367: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);

1363: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1364: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1365: dbms_sql.define_column(l_sql_csr,5,l_dob);
1366: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1367: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1368: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1369: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1370: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1371: dbms_sql.define_column(l_sql_csr,11,l_pay_month,240);

Line 1368: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);

1364: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1365: dbms_sql.define_column(l_sql_csr,5,l_dob);
1366: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1367: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1368: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1369: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1370: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1371: dbms_sql.define_column(l_sql_csr,11,l_pay_month,240);
1372: dbms_sql.define_column(l_sql_csr,12,l_er_location,240);

Line 1369: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);

1365: dbms_sql.define_column(l_sql_csr,5,l_dob);
1366: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1367: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1368: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1369: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1370: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1371: dbms_sql.define_column(l_sql_csr,11,l_pay_month,240);
1372: dbms_sql.define_column(l_sql_csr,12,l_er_location,240);
1373: dbms_sql.define_column(l_sql_csr,13,l_job,240);

Line 1370: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);

1366: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1367: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1368: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1369: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1370: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1371: dbms_sql.define_column(l_sql_csr,11,l_pay_month,240);
1372: dbms_sql.define_column(l_sql_csr,12,l_er_location,240);
1373: dbms_sql.define_column(l_sql_csr,13,l_job,240);
1374: dbms_sql.define_column(l_sql_csr,14,l_position,240);

Line 1371: dbms_sql.define_column(l_sql_csr,11,l_pay_month,240);

1367: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1368: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1369: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1370: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1371: dbms_sql.define_column(l_sql_csr,11,l_pay_month,240);
1372: dbms_sql.define_column(l_sql_csr,12,l_er_location,240);
1373: dbms_sql.define_column(l_sql_csr,13,l_job,240);
1374: dbms_sql.define_column(l_sql_csr,14,l_position,240);
1375: dbms_sql.define_column(l_sql_csr,15,l_grade,240);

Line 1372: dbms_sql.define_column(l_sql_csr,12,l_er_location,240);

1368: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1369: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1370: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1371: dbms_sql.define_column(l_sql_csr,11,l_pay_month,240);
1372: dbms_sql.define_column(l_sql_csr,12,l_er_location,240);
1373: dbms_sql.define_column(l_sql_csr,13,l_job,240);
1374: dbms_sql.define_column(l_sql_csr,14,l_position,240);
1375: dbms_sql.define_column(l_sql_csr,15,l_grade,240);
1376: dbms_sql.define_column(l_sql_csr,16,l_pan,240);

Line 1373: dbms_sql.define_column(l_sql_csr,13,l_job,240);

1369: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1370: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1371: dbms_sql.define_column(l_sql_csr,11,l_pay_month,240);
1372: dbms_sql.define_column(l_sql_csr,12,l_er_location,240);
1373: dbms_sql.define_column(l_sql_csr,13,l_job,240);
1374: dbms_sql.define_column(l_sql_csr,14,l_position,240);
1375: dbms_sql.define_column(l_sql_csr,15,l_grade,240);
1376: dbms_sql.define_column(l_sql_csr,16,l_pan,240);
1377: dbms_sql.define_column(l_sql_csr,17,l_superannuation,240);

Line 1374: dbms_sql.define_column(l_sql_csr,14,l_position,240);

1370: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1371: dbms_sql.define_column(l_sql_csr,11,l_pay_month,240);
1372: dbms_sql.define_column(l_sql_csr,12,l_er_location,240);
1373: dbms_sql.define_column(l_sql_csr,13,l_job,240);
1374: dbms_sql.define_column(l_sql_csr,14,l_position,240);
1375: dbms_sql.define_column(l_sql_csr,15,l_grade,240);
1376: dbms_sql.define_column(l_sql_csr,16,l_pan,240);
1377: dbms_sql.define_column(l_sql_csr,17,l_superannuation,240);
1378:

Line 1375: dbms_sql.define_column(l_sql_csr,15,l_grade,240);

1371: dbms_sql.define_column(l_sql_csr,11,l_pay_month,240);
1372: dbms_sql.define_column(l_sql_csr,12,l_er_location,240);
1373: dbms_sql.define_column(l_sql_csr,13,l_job,240);
1374: dbms_sql.define_column(l_sql_csr,14,l_position,240);
1375: dbms_sql.define_column(l_sql_csr,15,l_grade,240);
1376: dbms_sql.define_column(l_sql_csr,16,l_pan,240);
1377: dbms_sql.define_column(l_sql_csr,17,l_superannuation,240);
1378:
1379: pay_in_utils.set_location(g_debug,'Before Bind',40);

Line 1376: dbms_sql.define_column(l_sql_csr,16,l_pan,240);

1372: dbms_sql.define_column(l_sql_csr,12,l_er_location,240);
1373: dbms_sql.define_column(l_sql_csr,13,l_job,240);
1374: dbms_sql.define_column(l_sql_csr,14,l_position,240);
1375: dbms_sql.define_column(l_sql_csr,15,l_grade,240);
1376: dbms_sql.define_column(l_sql_csr,16,l_pan,240);
1377: dbms_sql.define_column(l_sql_csr,17,l_superannuation,240);
1378:
1379: pay_in_utils.set_location(g_debug,'Before Bind',40);
1380: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);

Line 1377: dbms_sql.define_column(l_sql_csr,17,l_superannuation,240);

1373: dbms_sql.define_column(l_sql_csr,13,l_job,240);
1374: dbms_sql.define_column(l_sql_csr,14,l_position,240);
1375: dbms_sql.define_column(l_sql_csr,15,l_grade,240);
1376: dbms_sql.define_column(l_sql_csr,16,l_pan,240);
1377: dbms_sql.define_column(l_sql_csr,17,l_superannuation,240);
1378:
1379: pay_in_utils.set_location(g_debug,'Before Bind',40);
1380: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
1381: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);

Line 1380: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);

1376: dbms_sql.define_column(l_sql_csr,16,l_pan,240);
1377: dbms_sql.define_column(l_sql_csr,17,l_superannuation,240);
1378:
1379: pay_in_utils.set_location(g_debug,'Before Bind',40);
1380: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
1381: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
1382: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
1383: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1384: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);

Line 1381: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);

1377: dbms_sql.define_column(l_sql_csr,17,l_superannuation,240);
1378:
1379: pay_in_utils.set_location(g_debug,'Before Bind',40);
1380: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
1381: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
1382: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
1383: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1384: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
1385:

Line 1382: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);

1378:
1379: pay_in_utils.set_location(g_debug,'Before Bind',40);
1380: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
1381: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
1382: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
1383: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1384: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
1385:
1386: pay_in_utils.set_location(g_debug,'Before execute',50);

Line 1383: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);

1379: pay_in_utils.set_location(g_debug,'Before Bind',40);
1380: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
1381: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
1382: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
1383: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1384: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
1385:
1386: pay_in_utils.set_location(g_debug,'Before execute',50);
1387: l_dummy := dbms_sql.execute(l_sql_csr);

Line 1384: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);

1380: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
1381: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
1382: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
1383: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1384: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
1385:
1386: pay_in_utils.set_location(g_debug,'Before execute',50);
1387: l_dummy := dbms_sql.execute(l_sql_csr);
1388:

Line 1387: l_dummy := dbms_sql.execute(l_sql_csr);

1383: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1384: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
1385:
1386: pay_in_utils.set_location(g_debug,'Before execute',50);
1387: l_dummy := dbms_sql.execute(l_sql_csr);
1388:
1389: LOOP
1390: --
1391: -- Fetch next row

Line 1393: IF (dbms_sql.fetch_rows(l_sql_csr) <= 0) THEN

1389: LOOP
1390: --
1391: -- Fetch next row
1392: --
1393: IF (dbms_sql.fetch_rows(l_sql_csr) <= 0) THEN
1394: --
1395: -- No More rows exist, Exit.
1396: EXIT;
1397: --

Line 1399: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);

1395: -- No More rows exist, Exit.
1396: EXIT;
1397: --
1398: END IF;
1399: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
1400: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
1401: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1402: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1403: dbms_sql.column_value(l_sql_csr,5,l_dob);

Line 1400: dbms_sql.column_value(l_sql_csr,2,l_employee_number);

1396: EXIT;
1397: --
1398: END IF;
1399: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
1400: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
1401: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1402: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1403: dbms_sql.column_value(l_sql_csr,5,l_dob);
1404: dbms_sql.column_value(l_sql_csr,6,l_joining_date);

Line 1401: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);

1397: --
1398: END IF;
1399: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
1400: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
1401: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1402: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1403: dbms_sql.column_value(l_sql_csr,5,l_dob);
1404: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1405: dbms_sql.column_value(l_sql_csr,7,l_ptn);

Line 1402: dbms_sql.column_value(l_sql_csr,4,l_employer_name);

1398: END IF;
1399: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
1400: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
1401: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1402: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1403: dbms_sql.column_value(l_sql_csr,5,l_dob);
1404: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1405: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1406: dbms_sql.column_value(l_sql_csr,8,l_pf_number);

Line 1403: dbms_sql.column_value(l_sql_csr,5,l_dob);

1399: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
1400: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
1401: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1402: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1403: dbms_sql.column_value(l_sql_csr,5,l_dob);
1404: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1405: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1406: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1407: dbms_sql.column_value(l_sql_csr,9,l_esi_number);

Line 1404: dbms_sql.column_value(l_sql_csr,6,l_joining_date);

1400: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
1401: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1402: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1403: dbms_sql.column_value(l_sql_csr,5,l_dob);
1404: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1405: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1406: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1407: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1408: dbms_sql.column_value(l_sql_csr,10,l_emp_name);

Line 1405: dbms_sql.column_value(l_sql_csr,7,l_ptn);

1401: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1402: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1403: dbms_sql.column_value(l_sql_csr,5,l_dob);
1404: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1405: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1406: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1407: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1408: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1409: dbms_sql.column_value(l_sql_csr,11,l_pay_month);

Line 1406: dbms_sql.column_value(l_sql_csr,8,l_pf_number);

1402: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1403: dbms_sql.column_value(l_sql_csr,5,l_dob);
1404: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1405: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1406: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1407: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1408: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1409: dbms_sql.column_value(l_sql_csr,11,l_pay_month);
1410: dbms_sql.column_value(l_sql_csr,12,l_er_location);

Line 1407: dbms_sql.column_value(l_sql_csr,9,l_esi_number);

1403: dbms_sql.column_value(l_sql_csr,5,l_dob);
1404: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1405: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1406: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1407: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1408: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1409: dbms_sql.column_value(l_sql_csr,11,l_pay_month);
1410: dbms_sql.column_value(l_sql_csr,12,l_er_location);
1411: dbms_sql.column_value(l_sql_csr,13,l_job);

Line 1408: dbms_sql.column_value(l_sql_csr,10,l_emp_name);

1404: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1405: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1406: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1407: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1408: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1409: dbms_sql.column_value(l_sql_csr,11,l_pay_month);
1410: dbms_sql.column_value(l_sql_csr,12,l_er_location);
1411: dbms_sql.column_value(l_sql_csr,13,l_job);
1412: dbms_sql.column_value(l_sql_csr,14,l_position);

Line 1409: dbms_sql.column_value(l_sql_csr,11,l_pay_month);

1405: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1406: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1407: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1408: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1409: dbms_sql.column_value(l_sql_csr,11,l_pay_month);
1410: dbms_sql.column_value(l_sql_csr,12,l_er_location);
1411: dbms_sql.column_value(l_sql_csr,13,l_job);
1412: dbms_sql.column_value(l_sql_csr,14,l_position);
1413: dbms_sql.column_value(l_sql_csr,15,l_grade);

Line 1410: dbms_sql.column_value(l_sql_csr,12,l_er_location);

1406: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1407: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1408: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1409: dbms_sql.column_value(l_sql_csr,11,l_pay_month);
1410: dbms_sql.column_value(l_sql_csr,12,l_er_location);
1411: dbms_sql.column_value(l_sql_csr,13,l_job);
1412: dbms_sql.column_value(l_sql_csr,14,l_position);
1413: dbms_sql.column_value(l_sql_csr,15,l_grade);
1414: dbms_sql.column_value(l_sql_csr,16,l_pan);

Line 1411: dbms_sql.column_value(l_sql_csr,13,l_job);

1407: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1408: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1409: dbms_sql.column_value(l_sql_csr,11,l_pay_month);
1410: dbms_sql.column_value(l_sql_csr,12,l_er_location);
1411: dbms_sql.column_value(l_sql_csr,13,l_job);
1412: dbms_sql.column_value(l_sql_csr,14,l_position);
1413: dbms_sql.column_value(l_sql_csr,15,l_grade);
1414: dbms_sql.column_value(l_sql_csr,16,l_pan);
1415: dbms_sql.column_value(l_sql_csr,17,l_superannuation);

Line 1412: dbms_sql.column_value(l_sql_csr,14,l_position);

1408: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1409: dbms_sql.column_value(l_sql_csr,11,l_pay_month);
1410: dbms_sql.column_value(l_sql_csr,12,l_er_location);
1411: dbms_sql.column_value(l_sql_csr,13,l_job);
1412: dbms_sql.column_value(l_sql_csr,14,l_position);
1413: dbms_sql.column_value(l_sql_csr,15,l_grade);
1414: dbms_sql.column_value(l_sql_csr,16,l_pan);
1415: dbms_sql.column_value(l_sql_csr,17,l_superannuation);
1416:

Line 1413: dbms_sql.column_value(l_sql_csr,15,l_grade);

1409: dbms_sql.column_value(l_sql_csr,11,l_pay_month);
1410: dbms_sql.column_value(l_sql_csr,12,l_er_location);
1411: dbms_sql.column_value(l_sql_csr,13,l_job);
1412: dbms_sql.column_value(l_sql_csr,14,l_position);
1413: dbms_sql.column_value(l_sql_csr,15,l_grade);
1414: dbms_sql.column_value(l_sql_csr,16,l_pan);
1415: dbms_sql.column_value(l_sql_csr,17,l_superannuation);
1416:
1417: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);

Line 1414: dbms_sql.column_value(l_sql_csr,16,l_pan);

1410: dbms_sql.column_value(l_sql_csr,12,l_er_location);
1411: dbms_sql.column_value(l_sql_csr,13,l_job);
1412: dbms_sql.column_value(l_sql_csr,14,l_position);
1413: dbms_sql.column_value(l_sql_csr,15,l_grade);
1414: dbms_sql.column_value(l_sql_csr,16,l_pan);
1415: dbms_sql.column_value(l_sql_csr,17,l_superannuation);
1416:
1417: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
1418: pay_in_utils.set_location(g_debug,l_procedure,20);

Line 1415: dbms_sql.column_value(l_sql_csr,17,l_superannuation);

1411: dbms_sql.column_value(l_sql_csr,13,l_job);
1412: dbms_sql.column_value(l_sql_csr,14,l_position);
1413: dbms_sql.column_value(l_sql_csr,15,l_grade);
1414: dbms_sql.column_value(l_sql_csr,16,l_pan);
1415: dbms_sql.column_value(l_sql_csr,17,l_superannuation);
1416:
1417: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
1418: pay_in_utils.set_location(g_debug,l_procedure,20);
1419: pay_in_utils.trace('l_employee_number : ', l_employee_number);

Line 1531: dbms_sql.close_cursor(l_sql_csr);

1527: --
1528: END LOOP;
1529:
1530: pay_in_utils.set_location(g_debug,'Close cursor',190);
1531: dbms_sql.close_cursor(l_sql_csr);
1532:
1533: -- Last CLOB is not yet closed
1534: -- So close it.
1535: IF ( g_clob_cnt <> 0) THEN

Line 1560: IF dbms_sql.is_open(l_sql_csr) THEN

1556: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1557: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,230);
1558: pay_in_utils.trace(l_message,l_procedure);
1559:
1560: IF dbms_sql.is_open(l_sql_csr) THEN
1561: dbms_sql.close_cursor(l_sql_csr);
1562: END IF;
1563: RAISE;
1564: --

Line 1561: dbms_sql.close_cursor(l_sql_csr);

1557: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,230);
1558: pay_in_utils.trace(l_message,l_procedure);
1559:
1560: IF dbms_sql.is_open(l_sql_csr) THEN
1561: dbms_sql.close_cursor(l_sql_csr);
1562: END IF;
1563: RAISE;
1564: --
1565: END load_xml;