APPS.PAY_IN_SOE dependencies on DBMS_SQL

Line 1682: l_sql_csr := dbms_sql.open_cursor;

1678: --
1679: l_stmt := l_stmt || l_sort_by;
1680:
1681: pay_in_utils.trace('Before Open Cursor',20);
1682: l_sql_csr := dbms_sql.open_cursor;
1683:
1684: pay_in_utils.set_location(g_debug,'Before parse',30);
1685: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1686: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);

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

1681: pay_in_utils.trace('Before Open Cursor',20);
1682: l_sql_csr := dbms_sql.open_cursor;
1683:
1684: pay_in_utils.set_location(g_debug,'Before parse',30);
1685: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1686: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
1687: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1688: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1689: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);

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

1682: l_sql_csr := dbms_sql.open_cursor;
1683:
1684: pay_in_utils.set_location(g_debug,'Before parse',30);
1685: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1686: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
1687: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1688: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1689: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1690: dbms_sql.define_column(l_sql_csr,5,l_dob);

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

1683:
1684: pay_in_utils.set_location(g_debug,'Before parse',30);
1685: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1686: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
1687: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1688: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1689: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1690: dbms_sql.define_column(l_sql_csr,5,l_dob);
1691: dbms_sql.define_column(l_sql_csr,6,l_joining_date);

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

1684: pay_in_utils.set_location(g_debug,'Before parse',30);
1685: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1686: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
1687: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1688: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1689: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1690: dbms_sql.define_column(l_sql_csr,5,l_dob);
1691: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1692: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);

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

1685: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1686: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
1687: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1688: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1689: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1690: dbms_sql.define_column(l_sql_csr,5,l_dob);
1691: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1692: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1693: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);

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

1686: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
1687: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1688: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1689: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1690: dbms_sql.define_column(l_sql_csr,5,l_dob);
1691: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1692: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1693: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1694: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);

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

1687: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1688: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1689: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1690: dbms_sql.define_column(l_sql_csr,5,l_dob);
1691: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1692: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1693: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1694: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1695: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);

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

1688: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1689: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1690: dbms_sql.define_column(l_sql_csr,5,l_dob);
1691: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1692: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1693: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1694: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1695: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1696: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);

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

1689: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
1690: dbms_sql.define_column(l_sql_csr,5,l_dob);
1691: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1692: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1693: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1694: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1695: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1696: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
1697: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);

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

1690: dbms_sql.define_column(l_sql_csr,5,l_dob);
1691: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1692: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1693: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1694: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1695: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1696: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
1697: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
1698: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);

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

1691: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
1692: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1693: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1694: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1695: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1696: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
1697: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
1698: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
1699: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);

Line 1696: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);

1692: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
1693: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1694: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1695: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1696: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
1697: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
1698: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
1699: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
1700: dbms_sql.define_column(l_sql_csr,15,l_job,240);

Line 1697: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);

1693: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
1694: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1695: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1696: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
1697: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
1698: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
1699: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
1700: dbms_sql.define_column(l_sql_csr,15,l_job,240);
1701: dbms_sql.define_column(l_sql_csr,16,l_position,240);

Line 1698: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);

1694: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
1695: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1696: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
1697: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
1698: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
1699: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
1700: dbms_sql.define_column(l_sql_csr,15,l_job,240);
1701: dbms_sql.define_column(l_sql_csr,16,l_position,240);
1702: dbms_sql.define_column(l_sql_csr,17,l_grade,240);

Line 1699: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);

1695: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
1696: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
1697: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
1698: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
1699: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
1700: dbms_sql.define_column(l_sql_csr,15,l_job,240);
1701: dbms_sql.define_column(l_sql_csr,16,l_position,240);
1702: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
1703: dbms_sql.define_column(l_sql_csr,18,l_pan,240);

Line 1700: dbms_sql.define_column(l_sql_csr,15,l_job,240);

1696: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
1697: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
1698: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
1699: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
1700: dbms_sql.define_column(l_sql_csr,15,l_job,240);
1701: dbms_sql.define_column(l_sql_csr,16,l_position,240);
1702: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
1703: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
1704: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);

Line 1701: dbms_sql.define_column(l_sql_csr,16,l_position,240);

1697: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
1698: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
1699: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
1700: dbms_sql.define_column(l_sql_csr,15,l_job,240);
1701: dbms_sql.define_column(l_sql_csr,16,l_position,240);
1702: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
1703: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
1704: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
1705:

Line 1702: dbms_sql.define_column(l_sql_csr,17,l_grade,240);

1698: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
1699: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
1700: dbms_sql.define_column(l_sql_csr,15,l_job,240);
1701: dbms_sql.define_column(l_sql_csr,16,l_position,240);
1702: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
1703: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
1704: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
1705:
1706: pay_in_utils.set_location(g_debug,'Before Bind',40);

Line 1703: dbms_sql.define_column(l_sql_csr,18,l_pan,240);

1699: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
1700: dbms_sql.define_column(l_sql_csr,15,l_job,240);
1701: dbms_sql.define_column(l_sql_csr,16,l_position,240);
1702: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
1703: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
1704: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
1705:
1706: pay_in_utils.set_location(g_debug,'Before Bind',40);
1707: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);

Line 1704: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);

1700: dbms_sql.define_column(l_sql_csr,15,l_job,240);
1701: dbms_sql.define_column(l_sql_csr,16,l_position,240);
1702: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
1703: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
1704: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
1705:
1706: pay_in_utils.set_location(g_debug,'Before Bind',40);
1707: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
1708: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);

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

1703: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
1704: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
1705:
1706: pay_in_utils.set_location(g_debug,'Before Bind',40);
1707: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
1708: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
1709: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
1710: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1711: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);

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

1704: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
1705:
1706: pay_in_utils.set_location(g_debug,'Before Bind',40);
1707: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
1708: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
1709: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
1710: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1711: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
1712: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);

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

1705:
1706: pay_in_utils.set_location(g_debug,'Before Bind',40);
1707: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
1708: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
1709: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
1710: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1711: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
1712: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);
1713: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);

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

1706: pay_in_utils.set_location(g_debug,'Before Bind',40);
1707: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
1708: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
1709: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
1710: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1711: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
1712: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);
1713: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);
1714:

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

1707: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
1708: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
1709: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
1710: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1711: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
1712: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);
1713: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);
1714:
1715:

Line 1712: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);

1708: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
1709: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
1710: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1711: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
1712: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);
1713: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);
1714:
1715:
1716: pay_in_utils.set_location(g_debug,'Before execute',50);

Line 1713: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);

1709: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
1710: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1711: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
1712: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);
1713: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);
1714:
1715:
1716: pay_in_utils.set_location(g_debug,'Before execute',50);
1717: l_dummy := dbms_sql.execute(l_sql_csr);

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

1713: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);
1714:
1715:
1716: pay_in_utils.set_location(g_debug,'Before execute',50);
1717: l_dummy := dbms_sql.execute(l_sql_csr);
1718:
1719: LOOP
1720: --
1721: -- Fetch next row

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

1719: LOOP
1720: --
1721: -- Fetch next row
1722: --
1723: IF (dbms_sql.fetch_rows(l_sql_csr) <= 0) THEN
1724: --
1725: -- No More rows exist, Exit.
1726: EXIT;
1727: --

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

1725: -- No More rows exist, Exit.
1726: EXIT;
1727: --
1728: END IF;
1729: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
1730: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
1731: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1732: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1733: dbms_sql.column_value(l_sql_csr,5,l_dob);

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

1726: EXIT;
1727: --
1728: END IF;
1729: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
1730: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
1731: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1732: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1733: dbms_sql.column_value(l_sql_csr,5,l_dob);
1734: dbms_sql.column_value(l_sql_csr,6,l_joining_date);

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

1727: --
1728: END IF;
1729: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
1730: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
1731: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1732: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1733: dbms_sql.column_value(l_sql_csr,5,l_dob);
1734: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1735: dbms_sql.column_value(l_sql_csr,7,l_ptn);

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

1728: END IF;
1729: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
1730: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
1731: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1732: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1733: dbms_sql.column_value(l_sql_csr,5,l_dob);
1734: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1735: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1736: dbms_sql.column_value(l_sql_csr,8,l_pf_number);

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

1729: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
1730: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
1731: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1732: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1733: dbms_sql.column_value(l_sql_csr,5,l_dob);
1734: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1735: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1736: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1737: dbms_sql.column_value(l_sql_csr,9,l_esi_number);

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

1730: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
1731: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1732: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1733: dbms_sql.column_value(l_sql_csr,5,l_dob);
1734: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1735: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1736: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1737: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1738: dbms_sql.column_value(l_sql_csr,10,l_emp_name);

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

1731: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
1732: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1733: dbms_sql.column_value(l_sql_csr,5,l_dob);
1734: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1735: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1736: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1737: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1738: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1739: dbms_sql.column_value(l_sql_csr,11,l_email_addr);

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

1732: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
1733: dbms_sql.column_value(l_sql_csr,5,l_dob);
1734: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1735: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1736: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1737: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1738: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1739: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
1740: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);

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

1733: dbms_sql.column_value(l_sql_csr,5,l_dob);
1734: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1735: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1736: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1737: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1738: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1739: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
1740: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
1741: dbms_sql.column_value(l_sql_csr,13,l_pay_month);

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

1734: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
1735: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1736: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1737: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1738: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1739: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
1740: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
1741: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
1742: dbms_sql.column_value(l_sql_csr,14,l_er_location);

Line 1739: dbms_sql.column_value(l_sql_csr,11,l_email_addr);

1735: dbms_sql.column_value(l_sql_csr,7,l_ptn);
1736: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1737: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1738: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1739: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
1740: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
1741: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
1742: dbms_sql.column_value(l_sql_csr,14,l_er_location);
1743: dbms_sql.column_value(l_sql_csr,15,l_job);

Line 1740: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);

1736: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
1737: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1738: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1739: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
1740: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
1741: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
1742: dbms_sql.column_value(l_sql_csr,14,l_er_location);
1743: dbms_sql.column_value(l_sql_csr,15,l_job);
1744: dbms_sql.column_value(l_sql_csr,16,l_position);

Line 1741: dbms_sql.column_value(l_sql_csr,13,l_pay_month);

1737: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
1738: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1739: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
1740: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
1741: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
1742: dbms_sql.column_value(l_sql_csr,14,l_er_location);
1743: dbms_sql.column_value(l_sql_csr,15,l_job);
1744: dbms_sql.column_value(l_sql_csr,16,l_position);
1745: dbms_sql.column_value(l_sql_csr,17,l_grade);

Line 1742: dbms_sql.column_value(l_sql_csr,14,l_er_location);

1738: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
1739: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
1740: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
1741: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
1742: dbms_sql.column_value(l_sql_csr,14,l_er_location);
1743: dbms_sql.column_value(l_sql_csr,15,l_job);
1744: dbms_sql.column_value(l_sql_csr,16,l_position);
1745: dbms_sql.column_value(l_sql_csr,17,l_grade);
1746: dbms_sql.column_value(l_sql_csr,18,l_pan);

Line 1743: dbms_sql.column_value(l_sql_csr,15,l_job);

1739: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
1740: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
1741: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
1742: dbms_sql.column_value(l_sql_csr,14,l_er_location);
1743: dbms_sql.column_value(l_sql_csr,15,l_job);
1744: dbms_sql.column_value(l_sql_csr,16,l_position);
1745: dbms_sql.column_value(l_sql_csr,17,l_grade);
1746: dbms_sql.column_value(l_sql_csr,18,l_pan);
1747: dbms_sql.column_value(l_sql_csr,19,l_superannuation);

Line 1744: dbms_sql.column_value(l_sql_csr,16,l_position);

1740: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
1741: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
1742: dbms_sql.column_value(l_sql_csr,14,l_er_location);
1743: dbms_sql.column_value(l_sql_csr,15,l_job);
1744: dbms_sql.column_value(l_sql_csr,16,l_position);
1745: dbms_sql.column_value(l_sql_csr,17,l_grade);
1746: dbms_sql.column_value(l_sql_csr,18,l_pan);
1747: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
1748:

Line 1745: dbms_sql.column_value(l_sql_csr,17,l_grade);

1741: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
1742: dbms_sql.column_value(l_sql_csr,14,l_er_location);
1743: dbms_sql.column_value(l_sql_csr,15,l_job);
1744: dbms_sql.column_value(l_sql_csr,16,l_position);
1745: dbms_sql.column_value(l_sql_csr,17,l_grade);
1746: dbms_sql.column_value(l_sql_csr,18,l_pan);
1747: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
1748:
1749: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);

Line 1746: dbms_sql.column_value(l_sql_csr,18,l_pan);

1742: dbms_sql.column_value(l_sql_csr,14,l_er_location);
1743: dbms_sql.column_value(l_sql_csr,15,l_job);
1744: dbms_sql.column_value(l_sql_csr,16,l_position);
1745: dbms_sql.column_value(l_sql_csr,17,l_grade);
1746: dbms_sql.column_value(l_sql_csr,18,l_pan);
1747: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
1748:
1749: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
1750: pay_in_utils.set_location(g_debug,l_procedure,20);

Line 1747: dbms_sql.column_value(l_sql_csr,19,l_superannuation);

1743: dbms_sql.column_value(l_sql_csr,15,l_job);
1744: dbms_sql.column_value(l_sql_csr,16,l_position);
1745: dbms_sql.column_value(l_sql_csr,17,l_grade);
1746: dbms_sql.column_value(l_sql_csr,18,l_pan);
1747: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
1748:
1749: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
1750: pay_in_utils.set_location(g_debug,l_procedure,20);
1751: pay_in_utils.trace('l_employee_number : ', l_employee_number);

Line 1865: dbms_sql.close_cursor(l_sql_csr);

1861: --
1862: END LOOP;
1863:
1864: pay_in_utils.set_location(g_debug,'Close cursor',190);
1865: dbms_sql.close_cursor(l_sql_csr);
1866:
1867: -- Last CLOB is not yet closed
1868: -- So close it.
1869: IF ( g_clob_cnt <> 0) THEN

Line 1895: IF dbms_sql.is_open(l_sql_csr) THEN

1891: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1892: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,230);
1893: pay_in_utils.trace(l_message,l_procedure);
1894:
1895: IF dbms_sql.is_open(l_sql_csr) THEN
1896: dbms_sql.close_cursor(l_sql_csr);
1897: END IF;
1898: RAISE;
1899: --

Line 1896: dbms_sql.close_cursor(l_sql_csr);

1892: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,230);
1893: pay_in_utils.trace(l_message,l_procedure);
1894:
1895: IF dbms_sql.is_open(l_sql_csr) THEN
1896: dbms_sql.close_cursor(l_sql_csr);
1897: END IF;
1898: RAISE;
1899: --
1900: END load_xml;

Line 2087: l_sql_csr := dbms_sql.open_cursor;

2083: --
2084: l_stmt := l_stmt || l_sort_by;
2085:
2086: pay_in_utils.trace('Before Open Cursor',20);
2087: l_sql_csr := dbms_sql.open_cursor;
2088:
2089: pay_in_utils.set_location(g_debug,'Before parse',30);
2090: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
2091: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);

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

2086: pay_in_utils.trace('Before Open Cursor',20);
2087: l_sql_csr := dbms_sql.open_cursor;
2088:
2089: pay_in_utils.set_location(g_debug,'Before parse',30);
2090: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
2091: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
2092: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
2093: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
2094: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);

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

2087: l_sql_csr := dbms_sql.open_cursor;
2088:
2089: pay_in_utils.set_location(g_debug,'Before parse',30);
2090: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
2091: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
2092: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
2093: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
2094: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
2095: dbms_sql.define_column(l_sql_csr,5,l_dob);

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

2088:
2089: pay_in_utils.set_location(g_debug,'Before parse',30);
2090: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
2091: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
2092: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
2093: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
2094: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
2095: dbms_sql.define_column(l_sql_csr,5,l_dob);
2096: dbms_sql.define_column(l_sql_csr,6,l_joining_date);

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

2089: pay_in_utils.set_location(g_debug,'Before parse',30);
2090: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
2091: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
2092: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
2093: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
2094: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
2095: dbms_sql.define_column(l_sql_csr,5,l_dob);
2096: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
2097: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);

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

2090: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
2091: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
2092: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
2093: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
2094: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
2095: dbms_sql.define_column(l_sql_csr,5,l_dob);
2096: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
2097: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
2098: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);

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

2091: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
2092: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
2093: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
2094: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
2095: dbms_sql.define_column(l_sql_csr,5,l_dob);
2096: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
2097: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
2098: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
2099: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);

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

2092: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
2093: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
2094: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
2095: dbms_sql.define_column(l_sql_csr,5,l_dob);
2096: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
2097: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
2098: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
2099: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
2100: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);

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

2093: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
2094: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
2095: dbms_sql.define_column(l_sql_csr,5,l_dob);
2096: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
2097: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
2098: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
2099: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
2100: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
2101: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);

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

2094: dbms_sql.define_column(l_sql_csr,4,l_employer_name,240);
2095: dbms_sql.define_column(l_sql_csr,5,l_dob);
2096: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
2097: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
2098: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
2099: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
2100: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
2101: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
2102: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);

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

2095: dbms_sql.define_column(l_sql_csr,5,l_dob);
2096: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
2097: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
2098: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
2099: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
2100: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
2101: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
2102: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
2103: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);

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

2096: dbms_sql.define_column(l_sql_csr,6,l_joining_date);
2097: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
2098: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
2099: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
2100: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
2101: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
2102: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
2103: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
2104: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);

Line 2101: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);

2097: dbms_sql.define_column(l_sql_csr,7,l_ptn,240);
2098: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
2099: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
2100: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
2101: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
2102: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
2103: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
2104: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
2105: dbms_sql.define_column(l_sql_csr,15,l_job,240);

Line 2102: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);

2098: dbms_sql.define_column(l_sql_csr,8,l_pf_number,240);
2099: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
2100: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
2101: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
2102: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
2103: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
2104: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
2105: dbms_sql.define_column(l_sql_csr,15,l_job,240);
2106: dbms_sql.define_column(l_sql_csr,16,l_position,240);

Line 2103: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);

2099: dbms_sql.define_column(l_sql_csr,9,l_esi_number,240);
2100: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
2101: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
2102: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
2103: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
2104: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
2105: dbms_sql.define_column(l_sql_csr,15,l_job,240);
2106: dbms_sql.define_column(l_sql_csr,16,l_position,240);
2107: dbms_sql.define_column(l_sql_csr,17,l_grade,240);

Line 2104: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);

2100: dbms_sql.define_column(l_sql_csr,10,l_emp_name,240);
2101: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
2102: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
2103: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
2104: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
2105: dbms_sql.define_column(l_sql_csr,15,l_job,240);
2106: dbms_sql.define_column(l_sql_csr,16,l_position,240);
2107: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
2108: dbms_sql.define_column(l_sql_csr,18,l_pan,240);

Line 2105: dbms_sql.define_column(l_sql_csr,15,l_job,240);

2101: dbms_sql.define_column(l_sql_csr,11,l_email_addr,240);
2102: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
2103: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
2104: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
2105: dbms_sql.define_column(l_sql_csr,15,l_job,240);
2106: dbms_sql.define_column(l_sql_csr,16,l_position,240);
2107: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
2108: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
2109: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);

Line 2106: dbms_sql.define_column(l_sql_csr,16,l_position,240);

2102: dbms_sql.define_column(l_sql_csr,12,l_emp_addr,500);
2103: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
2104: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
2105: dbms_sql.define_column(l_sql_csr,15,l_job,240);
2106: dbms_sql.define_column(l_sql_csr,16,l_position,240);
2107: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
2108: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
2109: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
2110:

Line 2107: dbms_sql.define_column(l_sql_csr,17,l_grade,240);

2103: dbms_sql.define_column(l_sql_csr,13,l_pay_month,240);
2104: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
2105: dbms_sql.define_column(l_sql_csr,15,l_job,240);
2106: dbms_sql.define_column(l_sql_csr,16,l_position,240);
2107: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
2108: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
2109: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
2110:
2111: pay_in_utils.set_location(g_debug,'Before Bind',40);

Line 2108: dbms_sql.define_column(l_sql_csr,18,l_pan,240);

2104: dbms_sql.define_column(l_sql_csr,14,l_er_location,240);
2105: dbms_sql.define_column(l_sql_csr,15,l_job,240);
2106: dbms_sql.define_column(l_sql_csr,16,l_position,240);
2107: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
2108: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
2109: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
2110:
2111: pay_in_utils.set_location(g_debug,'Before Bind',40);
2112: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);

Line 2109: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);

2105: dbms_sql.define_column(l_sql_csr,15,l_job,240);
2106: dbms_sql.define_column(l_sql_csr,16,l_position,240);
2107: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
2108: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
2109: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
2110:
2111: pay_in_utils.set_location(g_debug,'Before Bind',40);
2112: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
2113: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);

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

2108: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
2109: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
2110:
2111: pay_in_utils.set_location(g_debug,'Before Bind',40);
2112: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
2113: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
2114: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
2115: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
2116: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);

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

2109: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
2110:
2111: pay_in_utils.set_location(g_debug,'Before Bind',40);
2112: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
2113: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
2114: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
2115: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
2116: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
2117: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);

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

2110:
2111: pay_in_utils.set_location(g_debug,'Before Bind',40);
2112: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
2113: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
2114: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
2115: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
2116: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
2117: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);
2118: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);

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

2111: pay_in_utils.set_location(g_debug,'Before Bind',40);
2112: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
2113: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
2114: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
2115: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
2116: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
2117: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);
2118: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);
2119:

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

2112: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
2113: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
2114: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
2115: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
2116: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
2117: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);
2118: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);
2119:
2120:

Line 2117: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);

2113: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
2114: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
2115: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
2116: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
2117: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);
2118: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);
2119:
2120:
2121: pay_in_utils.set_location(g_debug,'Before execute',50);

Line 2118: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);

2114: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
2115: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
2116: dbms_sql.bind_variable(l_sql_csr,':cons_set_id',p_consolidation_set_id);
2117: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);
2118: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);
2119:
2120:
2121: pay_in_utils.set_location(g_debug,'Before execute',50);
2122: l_dummy := dbms_sql.execute(l_sql_csr);

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

2118: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);
2119:
2120:
2121: pay_in_utils.set_location(g_debug,'Before execute',50);
2122: l_dummy := dbms_sql.execute(l_sql_csr);
2123:
2124: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2125: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2126: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

2129: LOOP
2130: --
2131: -- Fetch next row
2132: --
2133: IF (dbms_sql.fetch_rows(l_sql_csr) <= 0) THEN
2134: --
2135: -- No More rows exist, Exit.
2136: EXIT;
2137: --

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

2135: -- No More rows exist, Exit.
2136: EXIT;
2137: --
2138: END IF;
2139: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
2140: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
2141: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
2142: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
2143: dbms_sql.column_value(l_sql_csr,5,l_dob);

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

2136: EXIT;
2137: --
2138: END IF;
2139: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
2140: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
2141: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
2142: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
2143: dbms_sql.column_value(l_sql_csr,5,l_dob);
2144: dbms_sql.column_value(l_sql_csr,6,l_joining_date);

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

2137: --
2138: END IF;
2139: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
2140: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
2141: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
2142: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
2143: dbms_sql.column_value(l_sql_csr,5,l_dob);
2144: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
2145: dbms_sql.column_value(l_sql_csr,7,l_ptn);

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

2138: END IF;
2139: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
2140: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
2141: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
2142: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
2143: dbms_sql.column_value(l_sql_csr,5,l_dob);
2144: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
2145: dbms_sql.column_value(l_sql_csr,7,l_ptn);
2146: dbms_sql.column_value(l_sql_csr,8,l_pf_number);

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

2139: dbms_sql.column_value(l_sql_csr,1,l_action_context_id);
2140: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
2141: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
2142: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
2143: dbms_sql.column_value(l_sql_csr,5,l_dob);
2144: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
2145: dbms_sql.column_value(l_sql_csr,7,l_ptn);
2146: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
2147: dbms_sql.column_value(l_sql_csr,9,l_esi_number);

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

2140: dbms_sql.column_value(l_sql_csr,2,l_employee_number);
2141: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
2142: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
2143: dbms_sql.column_value(l_sql_csr,5,l_dob);
2144: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
2145: dbms_sql.column_value(l_sql_csr,7,l_ptn);
2146: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
2147: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
2148: dbms_sql.column_value(l_sql_csr,10,l_emp_name);

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

2141: dbms_sql.column_value(l_sql_csr,3,l_assignment_number);
2142: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
2143: dbms_sql.column_value(l_sql_csr,5,l_dob);
2144: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
2145: dbms_sql.column_value(l_sql_csr,7,l_ptn);
2146: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
2147: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
2148: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
2149: dbms_sql.column_value(l_sql_csr,11,l_email_addr);

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

2142: dbms_sql.column_value(l_sql_csr,4,l_employer_name);
2143: dbms_sql.column_value(l_sql_csr,5,l_dob);
2144: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
2145: dbms_sql.column_value(l_sql_csr,7,l_ptn);
2146: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
2147: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
2148: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
2149: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
2150: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);

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

2143: dbms_sql.column_value(l_sql_csr,5,l_dob);
2144: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
2145: dbms_sql.column_value(l_sql_csr,7,l_ptn);
2146: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
2147: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
2148: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
2149: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
2150: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
2151: dbms_sql.column_value(l_sql_csr,13,l_pay_month);

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

2144: dbms_sql.column_value(l_sql_csr,6,l_joining_date);
2145: dbms_sql.column_value(l_sql_csr,7,l_ptn);
2146: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
2147: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
2148: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
2149: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
2150: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
2151: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
2152: dbms_sql.column_value(l_sql_csr,14,l_er_location);

Line 2149: dbms_sql.column_value(l_sql_csr,11,l_email_addr);

2145: dbms_sql.column_value(l_sql_csr,7,l_ptn);
2146: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
2147: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
2148: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
2149: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
2150: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
2151: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
2152: dbms_sql.column_value(l_sql_csr,14,l_er_location);
2153: dbms_sql.column_value(l_sql_csr,15,l_job);

Line 2150: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);

2146: dbms_sql.column_value(l_sql_csr,8,l_pf_number);
2147: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
2148: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
2149: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
2150: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
2151: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
2152: dbms_sql.column_value(l_sql_csr,14,l_er_location);
2153: dbms_sql.column_value(l_sql_csr,15,l_job);
2154: dbms_sql.column_value(l_sql_csr,16,l_position);

Line 2151: dbms_sql.column_value(l_sql_csr,13,l_pay_month);

2147: dbms_sql.column_value(l_sql_csr,9,l_esi_number);
2148: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
2149: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
2150: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
2151: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
2152: dbms_sql.column_value(l_sql_csr,14,l_er_location);
2153: dbms_sql.column_value(l_sql_csr,15,l_job);
2154: dbms_sql.column_value(l_sql_csr,16,l_position);
2155: dbms_sql.column_value(l_sql_csr,17,l_grade);

Line 2152: dbms_sql.column_value(l_sql_csr,14,l_er_location);

2148: dbms_sql.column_value(l_sql_csr,10,l_emp_name);
2149: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
2150: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
2151: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
2152: dbms_sql.column_value(l_sql_csr,14,l_er_location);
2153: dbms_sql.column_value(l_sql_csr,15,l_job);
2154: dbms_sql.column_value(l_sql_csr,16,l_position);
2155: dbms_sql.column_value(l_sql_csr,17,l_grade);
2156: dbms_sql.column_value(l_sql_csr,18,l_pan);

Line 2153: dbms_sql.column_value(l_sql_csr,15,l_job);

2149: dbms_sql.column_value(l_sql_csr,11,l_email_addr);
2150: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
2151: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
2152: dbms_sql.column_value(l_sql_csr,14,l_er_location);
2153: dbms_sql.column_value(l_sql_csr,15,l_job);
2154: dbms_sql.column_value(l_sql_csr,16,l_position);
2155: dbms_sql.column_value(l_sql_csr,17,l_grade);
2156: dbms_sql.column_value(l_sql_csr,18,l_pan);
2157: dbms_sql.column_value(l_sql_csr,19,l_superannuation);

Line 2154: dbms_sql.column_value(l_sql_csr,16,l_position);

2150: dbms_sql.column_value(l_sql_csr,12,l_emp_addr);
2151: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
2152: dbms_sql.column_value(l_sql_csr,14,l_er_location);
2153: dbms_sql.column_value(l_sql_csr,15,l_job);
2154: dbms_sql.column_value(l_sql_csr,16,l_position);
2155: dbms_sql.column_value(l_sql_csr,17,l_grade);
2156: dbms_sql.column_value(l_sql_csr,18,l_pan);
2157: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
2158:

Line 2155: dbms_sql.column_value(l_sql_csr,17,l_grade);

2151: dbms_sql.column_value(l_sql_csr,13,l_pay_month);
2152: dbms_sql.column_value(l_sql_csr,14,l_er_location);
2153: dbms_sql.column_value(l_sql_csr,15,l_job);
2154: dbms_sql.column_value(l_sql_csr,16,l_position);
2155: dbms_sql.column_value(l_sql_csr,17,l_grade);
2156: dbms_sql.column_value(l_sql_csr,18,l_pan);
2157: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
2158:
2159: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);

Line 2156: dbms_sql.column_value(l_sql_csr,18,l_pan);

2152: dbms_sql.column_value(l_sql_csr,14,l_er_location);
2153: dbms_sql.column_value(l_sql_csr,15,l_job);
2154: dbms_sql.column_value(l_sql_csr,16,l_position);
2155: dbms_sql.column_value(l_sql_csr,17,l_grade);
2156: dbms_sql.column_value(l_sql_csr,18,l_pan);
2157: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
2158:
2159: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
2160: pay_in_utils.set_location(g_debug,l_procedure,20);

Line 2157: dbms_sql.column_value(l_sql_csr,19,l_superannuation);

2153: dbms_sql.column_value(l_sql_csr,15,l_job);
2154: dbms_sql.column_value(l_sql_csr,16,l_position);
2155: dbms_sql.column_value(l_sql_csr,17,l_grade);
2156: dbms_sql.column_value(l_sql_csr,18,l_pan);
2157: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
2158:
2159: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
2160: pay_in_utils.set_location(g_debug,l_procedure,20);
2161: pay_in_utils.trace('l_employee_number : ', l_employee_number);

Line 2241: dbms_sql.close_cursor(l_sql_csr);

2237: --
2238: END LOOP;
2239: close_tag('IN_SOE');
2240: pay_in_utils.set_location(g_debug,'Close cursor',190);
2241: dbms_sql.close_cursor(l_sql_csr);
2242:
2243:
2244:
2245: dbms_lob.close(g_tmp_clob);

Line 2255: IF dbms_sql.is_open(l_sql_csr) THEN

2251: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
2252: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,230);
2253: pay_in_utils.trace(l_message,l_procedure);
2254:
2255: IF dbms_sql.is_open(l_sql_csr) THEN
2256: dbms_sql.close_cursor(l_sql_csr);
2257: END IF;
2258: RAISE;
2259: --

Line 2256: dbms_sql.close_cursor(l_sql_csr);

2252: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,230);
2253: pay_in_utils.trace(l_message,l_procedure);
2254:
2255: IF dbms_sql.is_open(l_sql_csr) THEN
2256: dbms_sql.close_cursor(l_sql_csr);
2257: END IF;
2258: RAISE;
2259: --
2260: END load_xml_burst;