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 3973: c := dbms_sql.open_cursor;

3969: --+
3970: -- Construct the call to the collect procedure of the package
3971: --+
3972:
3973: c := dbms_sql.open_cursor;
3974:
3975: statement := 'begin cn_sca_map_cn'||l_org_append||
3976: '.map(:sca_proc_batch_id, :start_date, :end_date, :api_version, :init_msg_list, :commit, :validation_level, '||
3977: ':org_id, :return_status, :msg_count, :msg_data); end;';

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

3975: statement := 'begin cn_sca_map_cn'||l_org_append||
3976: '.map(:sca_proc_batch_id, :start_date, :end_date, :api_version, :init_msg_list, :commit, :validation_level, '||
3977: ':org_id, :return_status, :msg_count, :msg_data); end;';
3978:
3979: dbms_sql.parse(c, statement, dbms_sql.native);
3980:
3981: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3982: dbms_sql.bind_variable(c,'start_date', p_start_date);
3983: dbms_sql.bind_variable(c,'end_date', p_end_date);

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

3977: ':org_id, :return_status, :msg_count, :msg_data); end;';
3978:
3979: dbms_sql.parse(c, statement, dbms_sql.native);
3980:
3981: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3982: dbms_sql.bind_variable(c,'start_date', p_start_date);
3983: dbms_sql.bind_variable(c,'end_date', p_end_date);
3984: dbms_sql.bind_variable(c,'api_version', 1.0);
3985: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);

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

3978:
3979: dbms_sql.parse(c, statement, dbms_sql.native);
3980:
3981: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3982: dbms_sql.bind_variable(c,'start_date', p_start_date);
3983: dbms_sql.bind_variable(c,'end_date', p_end_date);
3984: dbms_sql.bind_variable(c,'api_version', 1.0);
3985: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3986: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);

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

3979: dbms_sql.parse(c, statement, dbms_sql.native);
3980:
3981: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3982: dbms_sql.bind_variable(c,'start_date', p_start_date);
3983: dbms_sql.bind_variable(c,'end_date', p_end_date);
3984: dbms_sql.bind_variable(c,'api_version', 1.0);
3985: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3986: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3987: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);

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

3980:
3981: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3982: dbms_sql.bind_variable(c,'start_date', p_start_date);
3983: dbms_sql.bind_variable(c,'end_date', p_end_date);
3984: dbms_sql.bind_variable(c,'api_version', 1.0);
3985: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3986: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3987: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3988: dbms_sql.bind_variable(c,'org_id', p_org_id);

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

3981: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3982: dbms_sql.bind_variable(c,'start_date', p_start_date);
3983: dbms_sql.bind_variable(c,'end_date', p_end_date);
3984: dbms_sql.bind_variable(c,'api_version', 1.0);
3985: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3986: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3987: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3988: dbms_sql.bind_variable(c,'org_id', p_org_id);
3989: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);

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

3982: dbms_sql.bind_variable(c,'start_date', p_start_date);
3983: dbms_sql.bind_variable(c,'end_date', p_end_date);
3984: dbms_sql.bind_variable(c,'api_version', 1.0);
3985: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3986: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3987: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3988: dbms_sql.bind_variable(c,'org_id', p_org_id);
3989: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3990: dbms_sql.bind_variable(c,'msg_count', l_msg_count);

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

3983: dbms_sql.bind_variable(c,'end_date', p_end_date);
3984: dbms_sql.bind_variable(c,'api_version', 1.0);
3985: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3986: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3987: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3988: dbms_sql.bind_variable(c,'org_id', p_org_id);
3989: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3990: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3991: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);

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

3984: dbms_sql.bind_variable(c,'api_version', 1.0);
3985: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3986: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3987: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3988: dbms_sql.bind_variable(c,'org_id', p_org_id);
3989: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3990: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3991: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);
3992:

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

3985: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3986: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3987: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3988: dbms_sql.bind_variable(c,'org_id', p_org_id);
3989: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3990: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3991: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);
3992:
3993: rows_processed := dbms_sql.execute(c);

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

3986: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3987: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3988: dbms_sql.bind_variable(c,'org_id', p_org_id);
3989: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3990: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3991: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);
3992:
3993: rows_processed := dbms_sql.execute(c);
3994:

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

3987: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3988: dbms_sql.bind_variable(c,'org_id', p_org_id);
3989: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3990: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3991: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);
3992:
3993: rows_processed := dbms_sql.execute(c);
3994:
3995: dbms_sql.variable_value(c,'return_status', l_return_status);

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

3989: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3990: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3991: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);
3992:
3993: rows_processed := dbms_sql.execute(c);
3994:
3995: dbms_sql.variable_value(c,'return_status', l_return_status);
3996: dbms_sql.variable_value(c,'msg_count', l_msg_count);
3997: dbms_sql.variable_value(c,'msg_data', l_msg_data);

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

3991: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);
3992:
3993: rows_processed := dbms_sql.execute(c);
3994:
3995: dbms_sql.variable_value(c,'return_status', l_return_status);
3996: dbms_sql.variable_value(c,'msg_count', l_msg_count);
3997: dbms_sql.variable_value(c,'msg_data', l_msg_data);
3998: dbms_sql.close_cursor(c);
3999:

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

3992:
3993: rows_processed := dbms_sql.execute(c);
3994:
3995: dbms_sql.variable_value(c,'return_status', l_return_status);
3996: dbms_sql.variable_value(c,'msg_count', l_msg_count);
3997: dbms_sql.variable_value(c,'msg_data', l_msg_data);
3998: dbms_sql.close_cursor(c);
3999:
4000: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

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

3993: rows_processed := dbms_sql.execute(c);
3994:
3995: dbms_sql.variable_value(c,'return_status', l_return_status);
3996: dbms_sql.variable_value(c,'msg_count', l_msg_count);
3997: dbms_sql.variable_value(c,'msg_data', l_msg_data);
3998: dbms_sql.close_cursor(c);
3999:
4000: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4001:

Line 3998: dbms_sql.close_cursor(c);

3994:
3995: dbms_sql.variable_value(c,'return_status', l_return_status);
3996: dbms_sql.variable_value(c,'msg_count', l_msg_count);
3997: dbms_sql.variable_value(c,'msg_data', l_msg_data);
3998: dbms_sql.close_cursor(c);
3999:
4000: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4001:
4002: RAISE fail_populate;