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.QA_AK_MAPPING_API dependencies on QA_PLANS

Line 1176: l_qa_plans_row qa_plans%ROWTYPE;

1172: l_created_by OUT NOCOPY NUMBER,
1173: l_last_updated_by OUT NOCOPY NUMBER,
1174: l_last_update_login OUT NOCOPY NUMBER) IS
1175:
1176: l_qa_plans_row qa_plans%ROWTYPE;
1177:
1178: CURSOR c IS
1179: SELECT * from qa_plans
1180: WHERE plan_id = p_plan_id;

Line 1179: SELECT * from qa_plans

1175:
1176: l_qa_plans_row qa_plans%ROWTYPE;
1177:
1178: CURSOR c IS
1179: SELECT * from qa_plans
1180: WHERE plan_id = p_plan_id;
1181:
1182: BEGIN
1183:

Line 1191: FETCH c INTO l_qa_plans_row;

1187: -- canbe put in the ak tables. This function retrieves those
1188: -- relevant information.
1189:
1190: OPEN c;
1191: FETCH c INTO l_qa_plans_row;
1192: CLOSE c;
1193:
1194: l_data_type := 'VARCHAR2';
1195: l_label_length := length(l_qa_plans_row.name);

Line 1195: l_label_length := length(l_qa_plans_row.name);

1191: FETCH c INTO l_qa_plans_row;
1192: CLOSE c;
1193:
1194: l_data_type := 'VARCHAR2';
1195: l_label_length := length(l_qa_plans_row.name);
1196: l_name := l_qa_plans_row.name;
1197: l_label := l_qa_plans_row.name;
1198: l_item_style := 'NESTED_REGION';
1199: l_created_by := l_qa_plans_row.created_by;

Line 1196: l_name := l_qa_plans_row.name;

1192: CLOSE c;
1193:
1194: l_data_type := 'VARCHAR2';
1195: l_label_length := length(l_qa_plans_row.name);
1196: l_name := l_qa_plans_row.name;
1197: l_label := l_qa_plans_row.name;
1198: l_item_style := 'NESTED_REGION';
1199: l_created_by := l_qa_plans_row.created_by;
1200: l_last_updated_by := l_qa_plans_row.last_updated_by;

Line 1197: l_label := l_qa_plans_row.name;

1193:
1194: l_data_type := 'VARCHAR2';
1195: l_label_length := length(l_qa_plans_row.name);
1196: l_name := l_qa_plans_row.name;
1197: l_label := l_qa_plans_row.name;
1198: l_item_style := 'NESTED_REGION';
1199: l_created_by := l_qa_plans_row.created_by;
1200: l_last_updated_by := l_qa_plans_row.last_updated_by;
1201: l_last_update_login := l_qa_plans_row.last_update_login;

Line 1199: l_created_by := l_qa_plans_row.created_by;

1195: l_label_length := length(l_qa_plans_row.name);
1196: l_name := l_qa_plans_row.name;
1197: l_label := l_qa_plans_row.name;
1198: l_item_style := 'NESTED_REGION';
1199: l_created_by := l_qa_plans_row.created_by;
1200: l_last_updated_by := l_qa_plans_row.last_updated_by;
1201: l_last_update_login := l_qa_plans_row.last_update_login;
1202:
1203: END get_plan_values;

Line 1200: l_last_updated_by := l_qa_plans_row.last_updated_by;

1196: l_name := l_qa_plans_row.name;
1197: l_label := l_qa_plans_row.name;
1198: l_item_style := 'NESTED_REGION';
1199: l_created_by := l_qa_plans_row.created_by;
1200: l_last_updated_by := l_qa_plans_row.last_updated_by;
1201: l_last_update_login := l_qa_plans_row.last_update_login;
1202:
1203: END get_plan_values;
1204:

Line 1201: l_last_update_login := l_qa_plans_row.last_update_login;

1197: l_label := l_qa_plans_row.name;
1198: l_item_style := 'NESTED_REGION';
1199: l_created_by := l_qa_plans_row.created_by;
1200: l_last_updated_by := l_qa_plans_row.last_updated_by;
1201: l_last_update_login := l_qa_plans_row.last_update_login;
1202:
1203: END get_plan_values;
1204:
1205:

Line 1406: l_qa_plans_row qa_plans%ROWTYPE;

1402:
1403: l_region_code VARCHAR2(30);
1404: l_region_style VARCHAR2(30);
1405: l_row_id VARCHAR2(30);
1406: l_qa_plans_row qa_plans%ROWTYPE;
1407:
1408: CURSOR c IS
1409: SELECT * from qa_plans
1410: WHERE plan_id = p_plan_id;

Line 1409: SELECT * from qa_plans

1405: l_row_id VARCHAR2(30);
1406: l_qa_plans_row qa_plans%ROWTYPE;
1407:
1408: CURSOR c IS
1409: SELECT * from qa_plans
1410: WHERE plan_id = p_plan_id;
1411:
1412: BEGIN
1413:

Line 1418: FETCH c INTO l_qa_plans_row;

1414: -- This procedure creates an entry in ak regions table for a collection
1415: -- plan in Quality.
1416:
1417: OPEN c;
1418: FETCH c INTO l_qa_plans_row;
1419: CLOSE c;
1420:
1421: l_region_code := construct_ak_code(p_appendix, p_plan_id);
1422: delete_region (p_region_application_id, l_region_code);

Line 1434: X_NAME => l_qa_plans_row.name,

1430: X_DATABASE_OBJECT_NAME => 'ICX_PROMPTS',
1431: X_REGION_STYLE => l_region_style,
1432: X_NUM_COLUMNS => null,
1433: X_ICX_CUSTOM_CALL => null ,
1434: X_NAME => l_qa_plans_row.name,
1435: X_DESCRIPTION => l_qa_plans_row.description,
1436: X_REGION_DEFAULTING_API_PKG => null,
1437: X_REGION_DEFAULTING_API_PROC => null,
1438: X_REGION_VALIDATION_API_PKG => null,

Line 1435: X_DESCRIPTION => l_qa_plans_row.description,

1431: X_REGION_STYLE => l_region_style,
1432: X_NUM_COLUMNS => null,
1433: X_ICX_CUSTOM_CALL => null ,
1434: X_NAME => l_qa_plans_row.name,
1435: X_DESCRIPTION => l_qa_plans_row.description,
1436: X_REGION_DEFAULTING_API_PKG => null,
1437: X_REGION_DEFAULTING_API_PROC => null,
1438: X_REGION_VALIDATION_API_PKG => null,
1439: X_REGION_VALIDATION_API_PROC => null,

Line 1460: X_CREATED_BY => l_qa_plans_row.created_by,

1456: X_DEFAULT_SEARCH_PANEL => null, --5.5
1457: X_RESULTS_BASED_SEARCH => null, --5.5
1458: X_DISPLAY_GRAPH_TABLE => null, --5.5
1459: X_CREATION_DATE => g_sysdate,
1460: X_CREATED_BY => l_qa_plans_row.created_by,
1461: X_LAST_UPDATE_DATE => g_sysdate,
1462: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1463: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login,
1464: X_ATTRIBUTE_CATEGORY => null,

Line 1462: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,

1458: X_DISPLAY_GRAPH_TABLE => null, --5.5
1459: X_CREATION_DATE => g_sysdate,
1460: X_CREATED_BY => l_qa_plans_row.created_by,
1461: X_LAST_UPDATE_DATE => g_sysdate,
1462: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1463: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login,
1464: X_ATTRIBUTE_CATEGORY => null,
1465: X_ATTRIBUTE1 => null,
1466: X_ATTRIBUTE2 => null,

Line 1463: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login,

1459: X_CREATION_DATE => g_sysdate,
1460: X_CREATED_BY => l_qa_plans_row.created_by,
1461: X_LAST_UPDATE_DATE => g_sysdate,
1462: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1463: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login,
1464: X_ATTRIBUTE_CATEGORY => null,
1465: X_ATTRIBUTE1 => null,
1466: X_ATTRIBUTE2 => null,
1467: X_ATTRIBUTE3 => null,

Line 1506: l_qa_plans_row qa_plans%ROWTYPE;

1502: l_attribute_code VARCHAR2(30);
1503: l_lov_attribute_code VARCHAR2(30);
1504: l_base_attribute_code VARCHAR2(30);
1505: l_parents ParentArray;
1506: l_qa_plans_row qa_plans%ROWTYPE;
1507:
1508: CURSOR c IS
1509: SELECT * from qa_plans
1510: WHERE plan_id = p_plan_id;

Line 1509: SELECT * from qa_plans

1505: l_parents ParentArray;
1506: l_qa_plans_row qa_plans%ROWTYPE;
1507:
1508: CURSOR c IS
1509: SELECT * from qa_plans
1510: WHERE plan_id = p_plan_id;
1511:
1512: BEGIN
1513:

Line 1518: FETCH c INTO l_qa_plans_row;

1514: -- This function adds lov relations for a region item.
1515: -- Here the region item corresponds to a collection plan element.
1516:
1517: OPEN c;
1518: FETCH c INTO l_qa_plans_row;
1519: CLOSE c;
1520:
1521: AK_LOV_RELATIONS_PKG.INSERT_ROW (
1522: X_ROWID => l_row_id,

Line 1535: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,

1531: X_BASE_ATTRIBUTE_APPL_ID => p_attribute_application_id,
1532: X_BASE_ATTRIBUTE_CODE => p_attribute_code,
1533: X_DIRECTION_FLAG => 'CRITERIA',
1534: X_REQUIRED_FLAG => 'N',
1535: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1536: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1537: X_CREATION_DATE => l_qa_plans_row.creation_date,
1538: X_CREATED_BY => l_qa_plans_row.created_by,
1539: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);

Line 1536: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,

1532: X_BASE_ATTRIBUTE_CODE => p_attribute_code,
1533: X_DIRECTION_FLAG => 'CRITERIA',
1534: X_REQUIRED_FLAG => 'N',
1535: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1536: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1537: X_CREATION_DATE => l_qa_plans_row.creation_date,
1538: X_CREATED_BY => l_qa_plans_row.created_by,
1539: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1540:

Line 1537: X_CREATION_DATE => l_qa_plans_row.creation_date,

1533: X_DIRECTION_FLAG => 'CRITERIA',
1534: X_REQUIRED_FLAG => 'N',
1535: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1536: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1537: X_CREATION_DATE => l_qa_plans_row.creation_date,
1538: X_CREATED_BY => l_qa_plans_row.created_by,
1539: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1540:
1541:

Line 1538: X_CREATED_BY => l_qa_plans_row.created_by,

1534: X_REQUIRED_FLAG => 'N',
1535: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1536: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1537: X_CREATION_DATE => l_qa_plans_row.creation_date,
1538: X_CREATED_BY => l_qa_plans_row.created_by,
1539: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1540:
1541:
1542: AK_LOV_RELATIONS_PKG.INSERT_ROW (

Line 1539: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);

1535: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1536: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1537: X_CREATION_DATE => l_qa_plans_row.creation_date,
1538: X_CREATED_BY => l_qa_plans_row.created_by,
1539: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1540:
1541:
1542: AK_LOV_RELATIONS_PKG.INSERT_ROW (
1543: X_ROWID => l_row_id,

Line 1556: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,

1552: X_BASE_ATTRIBUTE_APPL_ID => p_attribute_application_id,
1553: X_BASE_ATTRIBUTE_CODE => p_attribute_code,
1554: X_DIRECTION_FLAG => 'RESULT',
1555: X_REQUIRED_FLAG => 'N',
1556: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1557: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1558: X_CREATION_DATE => l_qa_plans_row.creation_date,
1559: X_CREATED_BY => l_qa_plans_row.created_by,
1560: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);

Line 1557: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,

1553: X_BASE_ATTRIBUTE_CODE => p_attribute_code,
1554: X_DIRECTION_FLAG => 'RESULT',
1555: X_REQUIRED_FLAG => 'N',
1556: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1557: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1558: X_CREATION_DATE => l_qa_plans_row.creation_date,
1559: X_CREATED_BY => l_qa_plans_row.created_by,
1560: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1561:

Line 1558: X_CREATION_DATE => l_qa_plans_row.creation_date,

1554: X_DIRECTION_FLAG => 'RESULT',
1555: X_REQUIRED_FLAG => 'N',
1556: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1557: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1558: X_CREATION_DATE => l_qa_plans_row.creation_date,
1559: X_CREATED_BY => l_qa_plans_row.created_by,
1560: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1561:
1562:

Line 1559: X_CREATED_BY => l_qa_plans_row.created_by,

1555: X_REQUIRED_FLAG => 'N',
1556: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1557: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1558: X_CREATION_DATE => l_qa_plans_row.creation_date,
1559: X_CREATED_BY => l_qa_plans_row.created_by,
1560: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1561:
1562:
1563: AK_LOV_RELATIONS_PKG.INSERT_ROW (

Line 1560: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);

1556: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1557: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1558: X_CREATION_DATE => l_qa_plans_row.creation_date,
1559: X_CREATED_BY => l_qa_plans_row.created_by,
1560: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1561:
1562:
1563: AK_LOV_RELATIONS_PKG.INSERT_ROW (
1564: X_ROWID => l_row_id,

Line 1577: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,

1573: X_BASE_ATTRIBUTE_APPL_ID => p_attribute_application_id,
1574: X_BASE_ATTRIBUTE_CODE => g_org_id_attribute,
1575: X_DIRECTION_FLAG => 'PASSIVE_CRITERIA',
1576: X_REQUIRED_FLAG => 'N',
1577: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1578: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1579: X_CREATION_DATE => l_qa_plans_row.creation_date,
1580: X_CREATED_BY => l_qa_plans_row.created_by,
1581: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);

Line 1578: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,

1574: X_BASE_ATTRIBUTE_CODE => g_org_id_attribute,
1575: X_DIRECTION_FLAG => 'PASSIVE_CRITERIA',
1576: X_REQUIRED_FLAG => 'N',
1577: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1578: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1579: X_CREATION_DATE => l_qa_plans_row.creation_date,
1580: X_CREATED_BY => l_qa_plans_row.created_by,
1581: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1582:

Line 1579: X_CREATION_DATE => l_qa_plans_row.creation_date,

1575: X_DIRECTION_FLAG => 'PASSIVE_CRITERIA',
1576: X_REQUIRED_FLAG => 'N',
1577: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1578: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1579: X_CREATION_DATE => l_qa_plans_row.creation_date,
1580: X_CREATED_BY => l_qa_plans_row.created_by,
1581: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1582:
1583:

Line 1580: X_CREATED_BY => l_qa_plans_row.created_by,

1576: X_REQUIRED_FLAG => 'N',
1577: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1578: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1579: X_CREATION_DATE => l_qa_plans_row.creation_date,
1580: X_CREATED_BY => l_qa_plans_row.created_by,
1581: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1582:
1583:
1584: AK_LOV_RELATIONS_PKG.INSERT_ROW (

Line 1581: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);

1577: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1578: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1579: X_CREATION_DATE => l_qa_plans_row.creation_date,
1580: X_CREATED_BY => l_qa_plans_row.created_by,
1581: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1582:
1583:
1584: AK_LOV_RELATIONS_PKG.INSERT_ROW (
1585: X_ROWID => l_row_id,

Line 1598: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,

1594: X_BASE_ATTRIBUTE_APPL_ID => p_attribute_application_id,
1595: X_BASE_ATTRIBUTE_CODE => g_plan_id_attribute,
1596: X_DIRECTION_FLAG => 'PASSIVE_CRITERIA',
1597: X_REQUIRED_FLAG => 'N',
1598: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1599: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1600: X_CREATION_DATE => l_qa_plans_row.creation_date,
1601: X_CREATED_BY => l_qa_plans_row.created_by,
1602: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);

Line 1599: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,

1595: X_BASE_ATTRIBUTE_CODE => g_plan_id_attribute,
1596: X_DIRECTION_FLAG => 'PASSIVE_CRITERIA',
1597: X_REQUIRED_FLAG => 'N',
1598: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1599: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1600: X_CREATION_DATE => l_qa_plans_row.creation_date,
1601: X_CREATED_BY => l_qa_plans_row.created_by,
1602: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1603:

Line 1600: X_CREATION_DATE => l_qa_plans_row.creation_date,

1596: X_DIRECTION_FLAG => 'PASSIVE_CRITERIA',
1597: X_REQUIRED_FLAG => 'N',
1598: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1599: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1600: X_CREATION_DATE => l_qa_plans_row.creation_date,
1601: X_CREATED_BY => l_qa_plans_row.created_by,
1602: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1603:
1604: get_dependencies(p_char_id, l_parents);

Line 1601: X_CREATED_BY => l_qa_plans_row.created_by,

1597: X_REQUIRED_FLAG => 'N',
1598: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1599: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1600: X_CREATION_DATE => l_qa_plans_row.creation_date,
1601: X_CREATED_BY => l_qa_plans_row.created_by,
1602: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1603:
1604: get_dependencies(p_char_id, l_parents);
1605:

Line 1602: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);

1598: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1599: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1600: X_CREATION_DATE => l_qa_plans_row.creation_date,
1601: X_CREATED_BY => l_qa_plans_row.created_by,
1602: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1603:
1604: get_dependencies(p_char_id, l_parents);
1605:
1606: FOR i IN 1..l_parents.COUNT LOOP

Line 1626: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,

1622: X_BASE_ATTRIBUTE_APPL_ID => p_attribute_application_id,
1623: X_BASE_ATTRIBUTE_CODE => l_base_attribute_code,
1624: X_DIRECTION_FLAG => 'PASSIVE_CRITERIA',
1625: X_REQUIRED_FLAG => 'N',
1626: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1627: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1628: X_CREATION_DATE => l_qa_plans_row.creation_date,
1629: X_CREATED_BY => l_qa_plans_row.created_by,
1630: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);

Line 1627: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,

1623: X_BASE_ATTRIBUTE_CODE => l_base_attribute_code,
1624: X_DIRECTION_FLAG => 'PASSIVE_CRITERIA',
1625: X_REQUIRED_FLAG => 'N',
1626: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1627: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1628: X_CREATION_DATE => l_qa_plans_row.creation_date,
1629: X_CREATED_BY => l_qa_plans_row.created_by,
1630: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1631:

Line 1628: X_CREATION_DATE => l_qa_plans_row.creation_date,

1624: X_DIRECTION_FLAG => 'PASSIVE_CRITERIA',
1625: X_REQUIRED_FLAG => 'N',
1626: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1627: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1628: X_CREATION_DATE => l_qa_plans_row.creation_date,
1629: X_CREATED_BY => l_qa_plans_row.created_by,
1630: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1631:
1632: END LOOP;

Line 1629: X_CREATED_BY => l_qa_plans_row.created_by,

1625: X_REQUIRED_FLAG => 'N',
1626: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1627: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1628: X_CREATION_DATE => l_qa_plans_row.creation_date,
1629: X_CREATED_BY => l_qa_plans_row.created_by,
1630: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1631:
1632: END LOOP;
1633:

Line 1630: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);

1626: X_LAST_UPDATE_DATE => l_qa_plans_row.last_update_date,
1627: X_LAST_UPDATED_BY => l_qa_plans_row.last_updated_by,
1628: X_CREATION_DATE => l_qa_plans_row.creation_date,
1629: X_CREATED_BY => l_qa_plans_row.created_by,
1630: X_LAST_UPDATE_LOGIN => l_qa_plans_row.last_update_login);
1631:
1632: END LOOP;
1633:
1634: -- dbms_output.put_line('Adding LOV rel : ');

Line 2088: l_label_long := 'Plan Name: ' || qa_plans_api.plan_name(p_plan_id);

2084: -- l_region_code := g_eqr_top_region;
2085: l_region_code := get_eqr_header_region_code(p_attribute_code);
2086: l_display_sequence := get_display_sequence(l_region_code,
2087: p_region_application_id);
2088: l_label_long := 'Plan Name: ' || qa_plans_api.plan_name(p_plan_id);
2089:
2090: ELSE
2091: -- we come here if we are adding plan region to the vqr top
2092: