APPS.CSD_REPAIR_JOB_XREF_PVT dependencies on AS_FOUNDATION_PVT

Line 1117: l_flex_where_tbl_type AS_FOUNDATION_PVT.flex_where_tbl_type;

1113: l_order_by_cl VARCHAR2(2000);
1114: l_REPJOBXREF_where VARCHAR2(2000) := '';
1115:
1116: -- For flex field query
1117: l_flex_where_tbl_type AS_FOUNDATION_PVT.flex_where_tbl_type;
1118: l_flex_where VARCHAR2(2000) := NULL;
1119: l_counter NUMBER;
1120:
1121: -- Local scratch record

Line 1207: AS_FOUNDATION_PVT.Gen_Flexfield_Where(

1203: l_flex_where_tbl_type(15).value := P_REPJOBXREF_Rec.attribute15;
1204: l_flex_where_tbl_type(16).value := P_REPJOBXREF_Rec.attribute_category;
1205:
1206:
1207: AS_FOUNDATION_PVT.Gen_Flexfield_Where(
1208: p_flex_where_tbl_type => l_flex_where_tbl_type,
1209: x_flex_where_clause => l_flex_where);
1210:
1211: -- Hint: if master/detail relationship, generate Where clause for lines level criteria

Line 1233: AS_FOUNDATION_PVT.Bind_Flexfield_Where(

1229: -- p_total_amt_ceiling, p_total_amt_floor,
1230: -- l_cur_get_REPJOBXREF);
1231:
1232: -- Bind flexfield variables
1233: AS_FOUNDATION_PVT.Bind_Flexfield_Where(
1234: p_cursor_id => l_cur_get_REPJOBXREF,
1235: p_flex_where_tbl_type => l_flex_where_tbl_type);
1236:
1237: -- Define all Select Columns