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

Line 1984: l_cursor := dbms_sql.open_cursor;

1980: IF l_debug_mode = 'Y' THEN
1981: pa_debug.write(l_module_name, l_stmnt, l_debug_level3);
1982: END IF;
1983:
1984: l_cursor := dbms_sql.open_cursor;
1985:
1986: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
1987: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
1988:

Line 1986: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);

1982: END IF;
1983:
1984: l_cursor := dbms_sql.open_cursor;
1985:
1986: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
1987: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
1988:
1989: l_rows := DBMS_SQL.EXECUTE(l_cursor);
1990:

Line 1987: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);

1983:
1984: l_cursor := dbms_sql.open_cursor;
1985:
1986: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
1987: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
1988:
1989: l_rows := DBMS_SQL.EXECUTE(l_cursor);
1990:
1991: IF (l_rows < 0) THEN

Line 1989: l_rows := DBMS_SQL.EXECUTE(l_cursor);

1985:
1986: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
1987: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
1988:
1989: l_rows := DBMS_SQL.EXECUTE(l_cursor);
1990:
1991: IF (l_rows < 0) THEN
1992: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1993: ,p_msg_name => 'PA_TO_STATUS_INVALID');

Line 1997: l_rows1 := DBMS_SQL.FETCH_ROWS(l_cursor);

1993: ,p_msg_name => 'PA_TO_STATUS_INVALID');
1994: x_return_status := FND_API.G_RET_STS_ERROR;
1995: l_to_status_flag := 'N';
1996: ELSE
1997: l_rows1 := DBMS_SQL.FETCH_ROWS(l_cursor);
1998:
1999: if l_rows1 > 0 THEN
2000: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);
2001: l_ci_status_code := l_ci_status_code_1;

Line 2000: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);

1996: ELSE
1997: l_rows1 := DBMS_SQL.FETCH_ROWS(l_cursor);
1998:
1999: if l_rows1 > 0 THEN
2000: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);
2001: l_ci_status_code := l_ci_status_code_1;
2002: else
2003: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2004: ,p_msg_name => 'PA_TO_STATUS_INVALID');

Line 2010: IF dbms_sql.is_open(l_cursor) THEN

2006: l_to_status_flag := 'N';
2007: end if;
2008:
2009: END IF;
2010: IF dbms_sql.is_open(l_cursor) THEN
2011: dbms_sql.close_cursor(l_cursor);
2012: END IF;
2013: ELSIF p_ci_status_code IS NULL THEN
2014: l_ci_status_code := p_ci_status_code;

Line 2011: dbms_sql.close_cursor(l_cursor);

2007: end if;
2008:
2009: END IF;
2010: IF dbms_sql.is_open(l_cursor) THEN
2011: dbms_sql.close_cursor(l_cursor);
2012: END IF;
2013: ELSIF p_ci_status_code IS NULL THEN
2014: l_ci_status_code := p_ci_status_code;
2015: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_STATUS');

Line 6984: l_cursor := dbms_sql.open_cursor;

6980: IF l_debug_mode = 'Y' THEN
6981: pa_debug.write(l_module, l_stmnt , l_debug_level3);
6982: END IF;
6983:
6984: l_cursor := dbms_sql.open_cursor;
6985:
6986: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
6987: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
6988:

Line 6986: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);

6982: END IF;
6983:
6984: l_cursor := dbms_sql.open_cursor;
6985:
6986: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
6987: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
6988:
6989: l_rows := DBMS_SQL.EXECUTE(l_cursor);
6990:

Line 6987: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);

6983:
6984: l_cursor := dbms_sql.open_cursor;
6985:
6986: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
6987: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
6988:
6989: l_rows := DBMS_SQL.EXECUTE(l_cursor);
6990:
6991: IF (l_rows < 0) THEN

Line 6989: l_rows := DBMS_SQL.EXECUTE(l_cursor);

6985:
6986: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
6987: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
6988:
6989: l_rows := DBMS_SQL.EXECUTE(l_cursor);
6990:
6991: IF (l_rows < 0) THEN
6992: PA_UTILS.Add_Message( p_app_short_name => 'PA'
6993: ,p_msg_name => 'PA_TO_STATUS_INVALID');

Line 6997: l_rows1 := DBMS_SQL.FETCH_ROWS(l_cursor);

6993: ,p_msg_name => 'PA_TO_STATUS_INVALID');
6994: x_return_status := FND_API.G_RET_STS_ERROR;
6995: l_to_status_flag := 'N';
6996: ELSE
6997: l_rows1 := DBMS_SQL.FETCH_ROWS(l_cursor);
6998:
6999: if l_rows1 > 0 THEN
7000: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);
7001: l_ci_status_code := l_ci_status_code_1;

Line 7000: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);

6996: ELSE
6997: l_rows1 := DBMS_SQL.FETCH_ROWS(l_cursor);
6998:
6999: if l_rows1 > 0 THEN
7000: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);
7001: l_ci_status_code := l_ci_status_code_1;
7002: else
7003: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7004: ,p_msg_name => 'PA_TO_STATUS_INVALID');

Line 7014: IF dbms_sql.is_open(l_cursor) THEN

7010: IF l_debug_mode = 'Y' THEN
7011: pa_debug.write(l_module, 'After validating p_ci_status_code', l_debug_level3);
7012: END IF;
7013:
7014: IF dbms_sql.is_open(l_cursor) THEN
7015: dbms_sql.close_cursor(l_cursor);
7016: END IF;
7017: ELSIF p_ci_status_code IS NULL THEN
7018: l_ci_status_code := p_ci_status_code;

Line 7015: dbms_sql.close_cursor(l_cursor);

7011: pa_debug.write(l_module, 'After validating p_ci_status_code', l_debug_level3);
7012: END IF;
7013:
7014: IF dbms_sql.is_open(l_cursor) THEN
7015: dbms_sql.close_cursor(l_cursor);
7016: END IF;
7017: ELSIF p_ci_status_code IS NULL THEN
7018: l_ci_status_code := p_ci_status_code;
7019: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 8239: l_cursor := dbms_sql.open_cursor;

8235: IF l_debug_mode = 'Y' THEN
8236: pa_debug.write(l_module, l_stmnt, l_debug_level3);
8237: END IF;
8238:
8239: l_cursor := dbms_sql.open_cursor;
8240:
8241: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
8242: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
8243:

Line 8241: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);

8237: END IF;
8238:
8239: l_cursor := dbms_sql.open_cursor;
8240:
8241: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
8242: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
8243:
8244: l_rows := DBMS_SQL.EXECUTE(l_cursor);
8245:

Line 8242: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);

8238:
8239: l_cursor := dbms_sql.open_cursor;
8240:
8241: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
8242: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
8243:
8244: l_rows := DBMS_SQL.EXECUTE(l_cursor);
8245:
8246: IF (l_rows < 0) THEN

Line 8244: l_rows := DBMS_SQL.EXECUTE(l_cursor);

8240:
8241: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
8242: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
8243:
8244: l_rows := DBMS_SQL.EXECUTE(l_cursor);
8245:
8246: IF (l_rows < 0) THEN
8247: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8248: ,p_msg_name => 'PA_TO_STATUS_INVALID');

Line 8252: l_rows1 := DBMS_SQL.FETCH_ROWS(l_cursor);

8248: ,p_msg_name => 'PA_TO_STATUS_INVALID');
8249: x_return_status := FND_API.G_RET_STS_ERROR;
8250: l_to_status_flag := 'N';
8251: ELSE
8252: l_rows1 := DBMS_SQL.FETCH_ROWS(l_cursor);
8253:
8254: if l_rows1 > 0 THEN
8255: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);
8256: l_ci_status_code := l_ci_status_code_1;

Line 8255: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);

8251: ELSE
8252: l_rows1 := DBMS_SQL.FETCH_ROWS(l_cursor);
8253:
8254: if l_rows1 > 0 THEN
8255: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);
8256: l_ci_status_code := l_ci_status_code_1;
8257: else
8258: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8259: ,p_msg_name => 'PA_TO_STATUS_INVALID');

Line 8265: IF dbms_sql.is_open(l_cursor) THEN

8261: l_to_status_flag := 'N';
8262: end if;
8263:
8264: END IF;
8265: IF dbms_sql.is_open(l_cursor) THEN
8266: dbms_sql.close_cursor(l_cursor);
8267: END IF;
8268: ELSIF p_ci_status_code IS NULL THEN
8269: l_ci_status_code := p_ci_status_code;

Line 8266: dbms_sql.close_cursor(l_cursor);

8262: end if;
8263:
8264: END IF;
8265: IF dbms_sql.is_open(l_cursor) THEN
8266: dbms_sql.close_cursor(l_cursor);
8267: END IF;
8268: ELSIF p_ci_status_code IS NULL THEN
8269: l_ci_status_code := p_ci_status_code;
8270: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_STATUS');

Line 9496: l_cursor := dbms_sql.open_cursor;

9492: IF l_debug_mode = 'Y' THEN
9493: pa_debug.write(l_module, l_stmnt, l_debug_level3);
9494: END IF;
9495:
9496: l_cursor := dbms_sql.open_cursor;
9497:
9498: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
9499: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
9500:

Line 9498: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);

9494: END IF;
9495:
9496: l_cursor := dbms_sql.open_cursor;
9497:
9498: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
9499: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
9500:
9501: l_rows := DBMS_SQL.EXECUTE(l_cursor);
9502:

Line 9499: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);

9495:
9496: l_cursor := dbms_sql.open_cursor;
9497:
9498: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
9499: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
9500:
9501: l_rows := DBMS_SQL.EXECUTE(l_cursor);
9502:
9503: IF (l_rows < 0) THEN

Line 9501: l_rows := DBMS_SQL.EXECUTE(l_cursor);

9497:
9498: DBMS_SQL.PARSE(l_cursor, l_stmnt, DBMS_SQL.v7);
9499: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ci_status_code_1, 30);
9500:
9501: l_rows := DBMS_SQL.EXECUTE(l_cursor);
9502:
9503: IF (l_rows < 0) THEN
9504: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9505: ,p_msg_name => 'PA_TO_STATUS_INVALID');

Line 9509: l_rows1 := DBMS_SQL.FETCH_ROWS(l_cursor);

9505: ,p_msg_name => 'PA_TO_STATUS_INVALID');
9506: x_return_status := FND_API.G_RET_STS_ERROR;
9507: l_to_status_flag := 'N';
9508: ELSE
9509: l_rows1 := DBMS_SQL.FETCH_ROWS(l_cursor);
9510:
9511: if l_rows1 > 0 THEN
9512: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);
9513: l_ci_status_code := l_ci_status_code_1;

Line 9512: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);

9508: ELSE
9509: l_rows1 := DBMS_SQL.FETCH_ROWS(l_cursor);
9510:
9511: if l_rows1 > 0 THEN
9512: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);
9513: l_ci_status_code := l_ci_status_code_1;
9514: else
9515: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9516: ,p_msg_name => 'PA_TO_STATUS_INVALID');

Line 9522: IF dbms_sql.is_open(l_cursor) THEN

9518: l_to_status_flag := 'N';
9519: end if;
9520:
9521: END IF;
9522: IF dbms_sql.is_open(l_cursor) THEN
9523: dbms_sql.close_cursor(l_cursor);
9524: END IF;
9525: ELSIF p_ci_status_code IS NULL THEN
9526: l_ci_status_code := p_ci_status_code;

Line 9523: dbms_sql.close_cursor(l_cursor);

9519: end if;
9520:
9521: END IF;
9522: IF dbms_sql.is_open(l_cursor) THEN
9523: dbms_sql.close_cursor(l_cursor);
9524: END IF;
9525: ELSIF p_ci_status_code IS NULL THEN
9526: l_ci_status_code := p_ci_status_code;
9527: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_STATUS');