DBA Data[Home] [Help]

APPS.IEX_REPOSSESSION_PVT dependencies on AS_FOUNDATION_PVT

Line 1132: l_flex_where_tbl_type AS_FOUNDATION_PVT.flex_where_tbl_type;

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

Line 1223: AS_FOUNDATION_PVT.Gen_Flexfield_Where(

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

Line 1247: AS_FOUNDATION_PVT.Bind_Flexfield_Where(

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