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

Line 3979: c := dbms_sql.open_cursor;

3975: --+
3976: -- Construct the call to the collect procedure of the package
3977: --+
3978:
3979: c := dbms_sql.open_cursor;
3980:
3981: statement := 'begin cn_sca_map_cn'||l_org_append||
3982: '.map(:sca_proc_batch_id, :start_date, :end_date, :api_version, :init_msg_list, :commit, :validation_level, '||
3983: ':org_id, :return_status, :msg_count, :msg_data); end;';

Line 3985: dbms_sql.parse(c, statement, dbms_sql.native);

3981: statement := 'begin cn_sca_map_cn'||l_org_append||
3982: '.map(:sca_proc_batch_id, :start_date, :end_date, :api_version, :init_msg_list, :commit, :validation_level, '||
3983: ':org_id, :return_status, :msg_count, :msg_data); end;';
3984:
3985: dbms_sql.parse(c, statement, dbms_sql.native);
3986:
3987: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3988: dbms_sql.bind_variable(c,'start_date', p_start_date);
3989: dbms_sql.bind_variable(c,'end_date', p_end_date);

Line 3987: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);

3983: ':org_id, :return_status, :msg_count, :msg_data); end;';
3984:
3985: dbms_sql.parse(c, statement, dbms_sql.native);
3986:
3987: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3988: dbms_sql.bind_variable(c,'start_date', p_start_date);
3989: dbms_sql.bind_variable(c,'end_date', p_end_date);
3990: dbms_sql.bind_variable(c,'api_version', 1.0);
3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);

Line 3988: dbms_sql.bind_variable(c,'start_date', p_start_date);

3984:
3985: dbms_sql.parse(c, statement, dbms_sql.native);
3986:
3987: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3988: dbms_sql.bind_variable(c,'start_date', p_start_date);
3989: dbms_sql.bind_variable(c,'end_date', p_end_date);
3990: dbms_sql.bind_variable(c,'api_version', 1.0);
3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);

Line 3989: dbms_sql.bind_variable(c,'end_date', p_end_date);

3985: dbms_sql.parse(c, statement, dbms_sql.native);
3986:
3987: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3988: dbms_sql.bind_variable(c,'start_date', p_start_date);
3989: dbms_sql.bind_variable(c,'end_date', p_end_date);
3990: dbms_sql.bind_variable(c,'api_version', 1.0);
3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);

Line 3990: dbms_sql.bind_variable(c,'api_version', 1.0);

3986:
3987: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3988: dbms_sql.bind_variable(c,'start_date', p_start_date);
3989: dbms_sql.bind_variable(c,'end_date', p_end_date);
3990: dbms_sql.bind_variable(c,'api_version', 1.0);
3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3994: dbms_sql.bind_variable(c,'org_id', p_org_id);

Line 3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);

3987: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3988: dbms_sql.bind_variable(c,'start_date', p_start_date);
3989: dbms_sql.bind_variable(c,'end_date', p_end_date);
3990: dbms_sql.bind_variable(c,'api_version', 1.0);
3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3994: dbms_sql.bind_variable(c,'org_id', p_org_id);
3995: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);

Line 3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);

3988: dbms_sql.bind_variable(c,'start_date', p_start_date);
3989: dbms_sql.bind_variable(c,'end_date', p_end_date);
3990: dbms_sql.bind_variable(c,'api_version', 1.0);
3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3994: dbms_sql.bind_variable(c,'org_id', p_org_id);
3995: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3996: dbms_sql.bind_variable(c,'msg_count', l_msg_count);

Line 3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);

3989: dbms_sql.bind_variable(c,'end_date', p_end_date);
3990: dbms_sql.bind_variable(c,'api_version', 1.0);
3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3994: dbms_sql.bind_variable(c,'org_id', p_org_id);
3995: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3996: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3997: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);

Line 3994: dbms_sql.bind_variable(c,'org_id', p_org_id);

3990: dbms_sql.bind_variable(c,'api_version', 1.0);
3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3994: dbms_sql.bind_variable(c,'org_id', p_org_id);
3995: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3996: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3997: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);
3998:

Line 3995: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);

3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3994: dbms_sql.bind_variable(c,'org_id', p_org_id);
3995: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3996: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3997: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);
3998:
3999: rows_processed := dbms_sql.execute(c);

Line 3996: dbms_sql.bind_variable(c,'msg_count', l_msg_count);

3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3994: dbms_sql.bind_variable(c,'org_id', p_org_id);
3995: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3996: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3997: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);
3998:
3999: rows_processed := dbms_sql.execute(c);
4000:

Line 3997: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);

3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3994: dbms_sql.bind_variable(c,'org_id', p_org_id);
3995: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3996: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3997: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);
3998:
3999: rows_processed := dbms_sql.execute(c);
4000:
4001: dbms_sql.variable_value(c,'return_status', l_return_status);

Line 3999: rows_processed := dbms_sql.execute(c);

3995: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3996: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3997: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);
3998:
3999: rows_processed := dbms_sql.execute(c);
4000:
4001: dbms_sql.variable_value(c,'return_status', l_return_status);
4002: dbms_sql.variable_value(c,'msg_count', l_msg_count);
4003: dbms_sql.variable_value(c,'msg_data', l_msg_data);

Line 4001: dbms_sql.variable_value(c,'return_status', l_return_status);

3997: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);
3998:
3999: rows_processed := dbms_sql.execute(c);
4000:
4001: dbms_sql.variable_value(c,'return_status', l_return_status);
4002: dbms_sql.variable_value(c,'msg_count', l_msg_count);
4003: dbms_sql.variable_value(c,'msg_data', l_msg_data);
4004: dbms_sql.close_cursor(c);
4005:

Line 4002: dbms_sql.variable_value(c,'msg_count', l_msg_count);

3998:
3999: rows_processed := dbms_sql.execute(c);
4000:
4001: dbms_sql.variable_value(c,'return_status', l_return_status);
4002: dbms_sql.variable_value(c,'msg_count', l_msg_count);
4003: dbms_sql.variable_value(c,'msg_data', l_msg_data);
4004: dbms_sql.close_cursor(c);
4005:
4006: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 4003: dbms_sql.variable_value(c,'msg_data', l_msg_data);

3999: rows_processed := dbms_sql.execute(c);
4000:
4001: dbms_sql.variable_value(c,'return_status', l_return_status);
4002: dbms_sql.variable_value(c,'msg_count', l_msg_count);
4003: dbms_sql.variable_value(c,'msg_data', l_msg_data);
4004: dbms_sql.close_cursor(c);
4005:
4006: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4007:

Line 4004: dbms_sql.close_cursor(c);

4000:
4001: dbms_sql.variable_value(c,'return_status', l_return_status);
4002: dbms_sql.variable_value(c,'msg_count', l_msg_count);
4003: dbms_sql.variable_value(c,'msg_data', l_msg_data);
4004: dbms_sql.close_cursor(c);
4005:
4006: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4007:
4008: RAISE fail_populate;