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

Line 123: l_get_party_cursor_id := dbms_sql.open_cursor;

119: -- Build the select statement
120: l_select_stmt := l_select_stmt || ' where '||l_where_clause;
121:
122: -- Open the cursor
123: l_get_party_cursor_id := dbms_sql.open_cursor;
124:
125: --Parse the select statement
126: dbms_sql.parse(l_get_party_cursor_id, l_select_stmt , dbms_sql.native);
127:

Line 126: dbms_sql.parse(l_get_party_cursor_id, l_select_stmt , dbms_sql.native);

122: -- Open the cursor
123: l_get_party_cursor_id := dbms_sql.open_cursor;
124:
125: --Parse the select statement
126: dbms_sql.parse(l_get_party_cursor_id, l_select_stmt , dbms_sql.native);
127:
128: -- Bind the variables
129: csi_party_relationships_pvt.Bind_pty_variable(p_party_query_rec, l_get_party_cursor_id);
130:

Line 135: l_rows_processed := dbms_sql.execute(l_get_party_cursor_id);

131: -- Define output variables
132: csi_party_relationships_pvt.Define_Pty_Columns(l_get_party_cursor_id);
133:
134: -- execute the select statement
135: l_rows_processed := dbms_sql.execute(l_get_party_cursor_id);
136:
137: LOOP
138: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_party_cursor_id) = 0;
139: -- get the values after executing the selecl statement

Line 138: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_party_cursor_id) = 0;

134: -- execute the select statement
135: l_rows_processed := dbms_sql.execute(l_get_party_cursor_id);
136:
137: LOOP
138: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_party_cursor_id) = 0;
139: -- get the values after executing the selecl statement
140: csi_party_relationships_pvt.Get_pty_Column_Values(l_get_party_cursor_id, l_party_rec);
141: l_count := l_count + 1;
142: x_party_header_tbl(l_count) := l_party_rec;

Line 146: DBMS_SQL.CLOSE_CURSOR(l_get_party_cursor_id);

142: x_party_header_tbl(l_count) := l_party_rec;
143: END LOOP;
144:
145: -- Close the cursor
146: DBMS_SQL.CLOSE_CURSOR(l_get_party_cursor_id);
147:
148: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE)) THEN
149:
150: IF p_time_stamp <= sysdate THEN

Line 340: IF DBMS_SQL.IS_OPEN(l_get_party_cursor_id) THEN

336: FND_MSG_PUB.Count_And_Get
337: ( p_count => x_msg_count,
338: p_data => x_msg_data );
339: WHEN OTHERS THEN
340: IF DBMS_SQL.IS_OPEN(l_get_party_cursor_id) THEN
341: DBMS_SQL.CLOSE_CURSOR(l_get_party_cursor_id);
342: END IF;
343: -- ROLLBACK TO get_inst_party_rel_pub;
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 341: DBMS_SQL.CLOSE_CURSOR(l_get_party_cursor_id);

337: ( p_count => x_msg_count,
338: p_data => x_msg_data );
339: WHEN OTHERS THEN
340: IF DBMS_SQL.IS_OPEN(l_get_party_cursor_id) THEN
341: DBMS_SQL.CLOSE_CURSOR(l_get_party_cursor_id);
342: END IF;
343: -- ROLLBACK TO get_inst_party_rel_pub;
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2246: l_get_acct_cursor_id := dbms_sql.open_cursor;

2242: -- Build the select statement
2243: l_select_stmt := l_select_stmt || ' where '||l_where_clause;
2244:
2245: -- Open the cursor
2246: l_get_acct_cursor_id := dbms_sql.open_cursor;
2247:
2248: --Parse the select statement
2249: dbms_sql.parse(l_get_acct_cursor_id, l_select_stmt , dbms_sql.native);
2250:

Line 2249: dbms_sql.parse(l_get_acct_cursor_id, l_select_stmt , dbms_sql.native);

2245: -- Open the cursor
2246: l_get_acct_cursor_id := dbms_sql.open_cursor;
2247:
2248: --Parse the select statement
2249: dbms_sql.parse(l_get_acct_cursor_id, l_select_stmt , dbms_sql.native);
2250:
2251: -- Bind the variables
2252: csi_party_relationships_pvt.Bind_acct_variable(p_account_query_rec, l_get_acct_cursor_id);
2253:

Line 2258: l_rows_processed := dbms_sql.execute(l_get_acct_cursor_id);

2254: -- Define output variables
2255: csi_party_relationships_pvt.Define_Acct_Columns(l_get_acct_cursor_id);
2256:
2257: -- execute the select statement
2258: l_rows_processed := dbms_sql.execute(l_get_acct_cursor_id);
2259:
2260: LOOP
2261: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_acct_cursor_id) = 0;
2262: csi_party_relationships_pvt.Get_acct_Column_Values(l_get_acct_cursor_id, l_party_account_rec);

Line 2261: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_acct_cursor_id) = 0;

2257: -- execute the select statement
2258: l_rows_processed := dbms_sql.execute(l_get_acct_cursor_id);
2259:
2260: LOOP
2261: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_acct_cursor_id) = 0;
2262: csi_party_relationships_pvt.Get_acct_Column_Values(l_get_acct_cursor_id, l_party_account_rec);
2263: l_count := l_count + 1;
2264: x_account_header_tbl(l_count) := l_party_account_rec;
2265: END LOOP;

Line 2268: DBMS_SQL.CLOSE_CURSOR(l_get_acct_cursor_id);

2264: x_account_header_tbl(l_count) := l_party_account_rec;
2265: END LOOP;
2266:
2267: -- Close the cursor
2268: DBMS_SQL.CLOSE_CURSOR(l_get_acct_cursor_id);
2269:
2270: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE)) THEN
2271: IF p_time_stamp <= sysdate THEN
2272: -- Contruct from the history if p_time_stamp is less than sysdate

Line 2327: IF dbms_sql.is_open(l_get_acct_cursor_id) then

2323: FND_MSG_PUB.Count_And_Get
2324: ( p_count => x_msg_count,
2325: p_data => x_msg_data );
2326: WHEN OTHERS THEN
2327: IF dbms_sql.is_open(l_get_acct_cursor_id) then
2328: dbms_sql.close_cursor(l_get_acct_cursor_id);
2329: END IF;
2330: -- ROLLBACK TO get_inst_party_acct_pub;
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2328: dbms_sql.close_cursor(l_get_acct_cursor_id);

2324: ( p_count => x_msg_count,
2325: p_data => x_msg_data );
2326: WHEN OTHERS THEN
2327: IF dbms_sql.is_open(l_get_acct_cursor_id) then
2328: dbms_sql.close_cursor(l_get_acct_cursor_id);
2329: END IF;
2330: -- ROLLBACK TO get_inst_party_acct_pub;
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2332: IF FND_MSG_PUB.Check_Msg_Level