DBA Data[Home] [Help]

APPS.CSD_REPAIR_HISTORY_PVT dependencies on AS_FOUNDATION_PVT

Line 1336: l_flex_where_tbl_type AS_FOUNDATION_PVT.flex_where_tbl_type;

1332: l_order_by_cl VARCHAR2(2000);
1333: l_REPH_where VARCHAR2(2000) := '';
1334:
1335: -- For flex field query
1336: l_flex_where_tbl_type AS_FOUNDATION_PVT.flex_where_tbl_type;
1337: l_flex_where VARCHAR2(2000) := NULL;
1338: l_counter NUMBER;
1339:
1340: -- Local scratch record

Line 1425: AS_FOUNDATION_PVT.Gen_Flexfield_Where(

1421: l_flex_where_tbl_type(14).value := P_REPH_Rec.attribute14;
1422: l_flex_where_tbl_type(15).value := P_REPH_Rec.attribute15;
1423: l_flex_where_tbl_type(16).value := P_REPH_Rec.attribute_category;
1424:
1425: AS_FOUNDATION_PVT.Gen_Flexfield_Where(
1426: p_flex_where_tbl_type => l_flex_where_tbl_type,
1427: x_flex_where_clause => l_flex_where);
1428:
1429: -- Hint: if master/detail relationship, generate Where clause for lines level criteria

Line 1451: AS_FOUNDATION_PVT.Bind_Flexfield_Where(

1447: -- p_total_amt_ceiling, p_total_amt_floor,
1448: -- l_cur_get_REPH);
1449:
1450: -- Bind flexfield variables
1451: AS_FOUNDATION_PVT.Bind_Flexfield_Where(
1452: p_cursor_id => l_cur_get_REPH,
1453: p_flex_where_tbl_type => l_flex_where_tbl_type);
1454:
1455: -- Define all Select Columns