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

Line 3933: -- 2. Used dbms_SQL to build the query.

3929: -- PROCEDURE : purge_expense_lines_itf_data
3930: -- ASSUMES : UI validates location code, property code and expense extr code
3931: -- DESCRIPTION:
3932: -- 1. Purges data from interface table based on the given parameters.
3933: -- 2. Used dbms_SQL to build the query.
3934: --
3935: -- HISTORY:
3936: -- 18-APR-03 ftanudja o created
3937: -- 24-MAY-04 ftanudja o fixed from date / to date logic

Line 3991: l_cursor := dbms_sql.open_cursor;

3987: DELETE pn_rec_exp_itf;
3988: return;
3989: END IF;
3990: pnp_debug_pkg.log('p_extract_code='||p_extract_code);
3991: l_cursor := dbms_sql.open_cursor;
3992: l_sqlhead := 'DELETE pn_rec_exp_itf WHERE ';
3993:
3994: l_info := ' figuring expense extract code';
3995: pnp_debug_pkg.log(l_info);

Line 4070: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);

4066: pnp_debug_pkg.log(l_sqltail);
4067: pnp_debug_pkg.log('');
4068:
4069: l_statement := l_sqlhead || l_sqltail;
4070: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
4071: IF p_extract_code IS NOT NULL THEN
4072: dbms_sql.bind_variable(l_cursor,'l_extract_code',l_extract_code);
4073: END IF;
4074:

Line 4072: dbms_sql.bind_variable(l_cursor,'l_extract_code',l_extract_code);

4068:
4069: l_statement := l_sqlhead || l_sqltail;
4070: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
4071: IF p_extract_code IS NOT NULL THEN
4072: dbms_sql.bind_variable(l_cursor,'l_extract_code',l_extract_code);
4073: END IF;
4074:
4075: IF p_transfer_flag IS NOT NULL THEN
4076: dbms_sql.bind_variable(l_cursor,'l_transfer_flag',l_transfer_flag);

Line 4076: dbms_sql.bind_variable(l_cursor,'l_transfer_flag',l_transfer_flag);

4072: dbms_sql.bind_variable(l_cursor,'l_extract_code',l_extract_code);
4073: END IF;
4074:
4075: IF p_transfer_flag IS NOT NULL THEN
4076: dbms_sql.bind_variable(l_cursor,'l_transfer_flag',l_transfer_flag);
4077: END IF;
4078:
4079: IF p_from_date IS NOT NULL THEN
4080: dbms_sql.bind_variable(l_cursor,'l_from_date',l_from_date);

Line 4080: dbms_sql.bind_variable(l_cursor,'l_from_date',l_from_date);

4076: dbms_sql.bind_variable(l_cursor,'l_transfer_flag',l_transfer_flag);
4077: END IF;
4078:
4079: IF p_from_date IS NOT NULL THEN
4080: dbms_sql.bind_variable(l_cursor,'l_from_date',l_from_date);
4081: END IF;
4082:
4083: IF p_to_date IS NOT NULL THEN
4084: dbms_sql.bind_variable(l_cursor,'l_to_date',l_to_date);

Line 4084: dbms_sql.bind_variable(l_cursor,'l_to_date',l_to_date);

4080: dbms_sql.bind_variable(l_cursor,'l_from_date',l_from_date);
4081: END IF;
4082:
4083: IF p_to_date IS NOT NULL THEN
4084: dbms_sql.bind_variable(l_cursor,'l_to_date',l_to_date);
4085: END IF;
4086:
4087: IF p_location_code IS NOT NULL THEN
4088: dbms_sql.bind_variable(l_cursor,'l_loc_id',l_loc_id);

Line 4088: dbms_sql.bind_variable(l_cursor,'l_loc_id',l_loc_id);

4084: dbms_sql.bind_variable(l_cursor,'l_to_date',l_to_date);
4085: END IF;
4086:
4087: IF p_location_code IS NOT NULL THEN
4088: dbms_sql.bind_variable(l_cursor,'l_loc_id',l_loc_id);
4089: END IF;
4090:
4091: IF p_property_code IS NOT NULL THEN
4092: dbms_sql.bind_variable(l_cursor,'l_prop_id',l_prop_id);

Line 4092: dbms_sql.bind_variable(l_cursor,'l_prop_id',l_prop_id);

4088: dbms_sql.bind_variable(l_cursor,'l_loc_id',l_loc_id);
4089: END IF;
4090:
4091: IF p_property_code IS NOT NULL THEN
4092: dbms_sql.bind_variable(l_cursor,'l_prop_id',l_prop_id);
4093: END IF;
4094: l_rows := dbms_sql.execute(l_cursor);
4095:
4096:

Line 4094: l_rows := dbms_sql.execute(l_cursor);

4090:
4091: IF p_property_code IS NOT NULL THEN
4092: dbms_sql.bind_variable(l_cursor,'l_prop_id',l_prop_id);
4093: END IF;
4094: l_rows := dbms_sql.execute(l_cursor);
4095:
4096:
4097: END IF;
4098:

Line 4099: IF dbms_sql.is_open (l_cursor) THEN

4095:
4096:
4097: END IF;
4098:
4099: IF dbms_sql.is_open (l_cursor) THEN
4100: dbms_sql.close_cursor (l_cursor);
4101: END IF;
4102: pnp_debug_pkg.log(l_desc ||' (-)');
4103:

Line 4100: dbms_sql.close_cursor (l_cursor);

4096:
4097: END IF;
4098:
4099: IF dbms_sql.is_open (l_cursor) THEN
4100: dbms_sql.close_cursor (l_cursor);
4101: END IF;
4102: pnp_debug_pkg.log(l_desc ||' (-)');
4103:
4104: EXCEPTION