DBA Data[Home] [Help]

APPS.IEX_REPOSSESSION_PVT dependencies on AS_FOUNDATION_PVT

Line 1134: l_flex_where_tbl_type AS_FOUNDATION_PVT.flex_where_tbl_type;

1130: l_order_by_cl VARCHAR2(2000);
1131: l_RPS_where VARCHAR2(2000) := '';
1132:
1133: -- For flex field query
1134: l_flex_where_tbl_type AS_FOUNDATION_PVT.flex_where_tbl_type;
1135: l_flex_where VARCHAR2(2000) := NULL;
1136: l_counter NUMBER;
1137:
1138: -- Local scratch record

Line 1225: AS_FOUNDATION_PVT.Gen_Flexfield_Where(

1221: l_flex_where_tbl_type(14).value := P_RPS_Rec.attribute14;
1222: l_flex_where_tbl_type(15).value := P_RPS_Rec.attribute15;
1223: l_flex_where_tbl_type(16).value := P_RPS_Rec.attribute_category;
1224:
1225: AS_FOUNDATION_PVT.Gen_Flexfield_Where(
1226: p_flex_where_tbl_type => l_flex_where_tbl_type,
1227: x_flex_where_clause => l_flex_where);
1228:
1229: -- Hint: if master/detail relationship, generate Where clause for lines level criteria

Line 1249: AS_FOUNDATION_PVT.Bind_Flexfield_Where(

1245: -- p_total_amt_ceiling, p_total_amt_floor,
1246: -- l_cur_get_RPS);
1247:
1248: -- Bind flexfield variables
1249: AS_FOUNDATION_PVT.Bind_Flexfield_Where(
1250: p_cursor_id => l_cur_get_RPS,
1251: p_flex_where_tbl_type => l_flex_where_tbl_type);
1252:
1253: -- Define all Select Columns