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.CN_MASS_ADJUST_UTIL dependencies on FND_API

Line 74: x_return_status := FND_API.G_RET_STS_SUCCESS;

70: AND conversion_type = p_conversion_type
71: AND conversion_date < p_conversion_date;
72: --
73: BEGIN
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75: FOR rec IN c1
76: LOOP
77: l_conversion_date := rec.conversion_date;
78: l_check_max := 'N';

Line 111: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,

107: x_return_status := 'ERROR';
108: END find_functional_amount;
109: --
110: PROCEDURE search_result (
111: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
113: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
114: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
115: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,

Line 112: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,

108: END find_functional_amount;
109: --
110: PROCEDURE search_result (
111: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
113: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
114: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
115: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
116: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,

Line 113: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,

109: --
110: PROCEDURE search_result (
111: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
113: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
114: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
115: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
116: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,

Line 114: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,

110: PROCEDURE search_result (
111: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
113: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
114: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
115: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
116: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
118: p_order_num IN NUMBER := FND_API.G_MISS_NUM,

Line 115: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,

111: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
113: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
114: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
115: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
116: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
118: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
119: p_org_id IN NUMBER := FND_API.G_MISS_NUM,

Line 116: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,

112: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
113: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
114: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
115: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
116: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
118: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
119: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,

Line 117: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,

113: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
114: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
115: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
116: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
118: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
119: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
121: x_return_status OUT NOCOPY VARCHAR2,

Line 118: p_order_num IN NUMBER := FND_API.G_MISS_NUM,

114: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
115: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
116: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
118: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
119: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_adj_tbl OUT NOCOPY cn_get_tx_data_pub.adj_tbl_type,

Line 119: p_org_id IN NUMBER := FND_API.G_MISS_NUM,

115: p_adj_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
116: p_load_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
118: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
119: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_adj_tbl OUT NOCOPY cn_get_tx_data_pub.adj_tbl_type,
123: x_source_counter OUT NOCOPY NUMBER) IS

Line 529: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN

525: from cn_comm_lines_api
526: where comm_lines_api_id = p_comm_lines_api_id;
527:
528: BEGIN
529: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN
530: l_salesrep_id := p_salesrep_id;
531: ELSE
532: l_salesrep_id := null;
533: END IF;

Line 534: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN

530: l_salesrep_id := p_salesrep_id;
531: ELSE
532: l_salesrep_id := null;
533: END IF;
534: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
535: l_pr_date_from := p_pr_date_from;
536: ELSE
537: l_pr_date_from := null;
538: END IF;

Line 539: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN

535: l_pr_date_from := p_pr_date_from;
536: ELSE
537: l_pr_date_from := null;
538: END IF;
539: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
540: l_pr_date_to := p_pr_date_to;
541: ELSE
542: l_pr_date_to := null;
543: END IF;

Line 544: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN

540: l_pr_date_to := p_pr_date_to;
541: ELSE
542: l_pr_date_to := null;
543: END IF;
544: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
545: l_invoice_num := p_invoice_num;
546: ELSE
547: l_invoice_num := null;
548: END IF;

Line 549: IF (p_order_num <> FND_API.G_MISS_NUM) THEN

545: l_invoice_num := p_invoice_num;
546: ELSE
547: l_invoice_num := null;
548: END IF;
549: IF (p_order_num <> FND_API.G_MISS_NUM) THEN
550: l_order_num := p_order_num;
551: ELSE
552: l_order_num := null;
553: END IF;

Line 714: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN

710: 'AND CPSP.ORG_ID = CCLA.ORG_ID '||
711: 'AND RSD.ORG_ID = CCLA.ORG_ID '||
712: 'AND CNR.ORG_ID(+) = CCLA.ORG_id ';
713:
714: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN
715: l_header_sql := l_header_sql|| ' AND CCH.direct_salesrep_id = :p_salesrep_id';
716: l_api_sql := l_api_sql || ' AND CCLA.salesrep_id = :p_salesrep_id';
717: ELSE
718: --l_header_sql := l_header_sql|| ' AND :p_salesrep_id = '||FND_API.G_MISS_NUM;

Line 718: --l_header_sql := l_header_sql|| ' AND :p_salesrep_id = '||FND_API.G_MISS_NUM;

714: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN
715: l_header_sql := l_header_sql|| ' AND CCH.direct_salesrep_id = :p_salesrep_id';
716: l_api_sql := l_api_sql || ' AND CCLA.salesrep_id = :p_salesrep_id';
717: ELSE
718: --l_header_sql := l_header_sql|| ' AND :p_salesrep_id = '||FND_API.G_MISS_NUM;
719: --l_api_sql := l_api_sql|| ' AND :p_salesrep_id = '||FND_API.G_MISS_NUM;
720: l_header_sql := l_header_sql|| ' AND :p_salesrep_id IS NULL ';
721: l_api_sql := l_api_sql|| ' AND :p_salesrep_id IS NULL ';
722: END IF;

Line 719: --l_api_sql := l_api_sql|| ' AND :p_salesrep_id = '||FND_API.G_MISS_NUM;

715: l_header_sql := l_header_sql|| ' AND CCH.direct_salesrep_id = :p_salesrep_id';
716: l_api_sql := l_api_sql || ' AND CCLA.salesrep_id = :p_salesrep_id';
717: ELSE
718: --l_header_sql := l_header_sql|| ' AND :p_salesrep_id = '||FND_API.G_MISS_NUM;
719: --l_api_sql := l_api_sql|| ' AND :p_salesrep_id = '||FND_API.G_MISS_NUM;
720: l_header_sql := l_header_sql|| ' AND :p_salesrep_id IS NULL ';
721: l_api_sql := l_api_sql|| ' AND :p_salesrep_id IS NULL ';
722: END IF;
723:

Line 724: IF (p_org_id <> FND_API.G_MISS_NUM) THEN

720: l_header_sql := l_header_sql|| ' AND :p_salesrep_id IS NULL ';
721: l_api_sql := l_api_sql|| ' AND :p_salesrep_id IS NULL ';
722: END IF;
723:
724: IF (p_org_id <> FND_API.G_MISS_NUM) THEN
725: l_header_sql := l_header_sql|| ' AND CCH.org_id = :p_org_id';
726: l_api_sql := l_api_sql || ' AND CCLA.org_id = :p_org_id';
727: ELSE
728: l_header_sql := l_header_sql|| ' AND :p_org_id = '||FND_API.G_MISS_NUM;

Line 728: l_header_sql := l_header_sql|| ' AND :p_org_id = '||FND_API.G_MISS_NUM;

724: IF (p_org_id <> FND_API.G_MISS_NUM) THEN
725: l_header_sql := l_header_sql|| ' AND CCH.org_id = :p_org_id';
726: l_api_sql := l_api_sql || ' AND CCLA.org_id = :p_org_id';
727: ELSE
728: l_header_sql := l_header_sql|| ' AND :p_org_id = '||FND_API.G_MISS_NUM;
729: l_api_sql := l_api_sql|| ' AND :p_org_id = '||FND_API.G_MISS_NUM;
730: END IF;
731:
732: --

Line 729: l_api_sql := l_api_sql|| ' AND :p_org_id = '||FND_API.G_MISS_NUM;

725: l_header_sql := l_header_sql|| ' AND CCH.org_id = :p_org_id';
726: l_api_sql := l_api_sql || ' AND CCLA.org_id = :p_org_id';
727: ELSE
728: l_header_sql := l_header_sql|| ' AND :p_org_id = '||FND_API.G_MISS_NUM;
729: l_api_sql := l_api_sql|| ' AND :p_org_id = '||FND_API.G_MISS_NUM;
730: END IF;
731:
732: --
733:

Line 746: IF (l_keep_flag <> FND_API.G_MISS_CHAR AND l_keep_flag IS NOT NULL) THEN

742: l_api_sql := l_api_sql || ' AND CCLA.terr_id is null';
743: END IF;
744:
745: l_keep_flag := p_srch_attr_rec.preserve_credit_override_flag;
746: IF (l_keep_flag <> FND_API.G_MISS_CHAR AND l_keep_flag IS NOT NULL) THEN
747: IF (l_keep_flag = 'Y')
748: THEN
749: l_header_sql := l_header_sql|| ' AND API.preserve_credit_override_flag = :l_keep_flag';
750: l_api_sql := l_api_sql || ' AND CCLA.preserve_credit_override_flag = :l_keep_flag';

Line 763: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN

759: l_api_sql := l_api_sql || ' AND :l_keep_flag IS NULL';
760: END IF;
761:
762:
763: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
764: l_header_sql := l_header_sql|| ' AND trunc(CCH.processed_date) >= :l_pr_date_from';
765: l_api_sql := l_api_sql || ' AND trunc(CCLA.processed_date) >= :l_pr_date_from';
766: ELSE
767: l_header_sql := l_header_sql|| ' AND :l_pr_date_from IS NULL';

Line 771: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN

767: l_header_sql := l_header_sql|| ' AND :l_pr_date_from IS NULL';
768: l_api_sql := l_api_sql|| ' AND :l_pr_date_from IS NULL';
769: END IF;
770: --
771: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
772: l_header_sql := l_header_sql|| ' AND trunc(CCH.processed_date) <= :l_pr_date_to';
773: l_api_sql := l_api_sql || ' AND trunc(CCLA.processed_date) <= :l_pr_date_to';
774: ELSE
775: l_header_sql := l_header_sql|| ' AND :l_pr_date_to IS NULL';

Line 779: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN

775: l_header_sql := l_header_sql|| ' AND :l_pr_date_to IS NULL';
776: l_api_sql := l_api_sql|| ' AND :l_pr_date_to IS NULL';
777: END IF;
778: --
779: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
780: l_header_sql := l_header_sql|| ' AND CCH.invoice_number LIKE :l_invoice_num';
781: l_api_sql := l_api_sql || ' AND CCLA.invoice_number LIKE :l_invoice_num';
782: ELSE
783: l_header_sql := l_header_sql|| ' AND :l_invoice_num IS NULL';

Line 787: IF (p_order_num <> FND_API.G_MISS_NUM) THEN

783: l_header_sql := l_header_sql|| ' AND :l_invoice_num IS NULL';
784: l_api_sql := l_api_sql|| ' AND :l_invoice_num IS NULL';
785: END IF;
786: --
787: IF (p_order_num <> FND_API.G_MISS_NUM) THEN
788: l_header_sql := l_header_sql|| ' AND CCH.order_number = :p_order_num';
789: l_api_sql := l_api_sql || ' AND CCLA.order_number = :p_order_num';
790: ELSE
791: l_header_sql := l_header_sql|| ' AND :p_order_num IS NULL';

Line 1300: IF (p_srch_attr_rec.attribute1 <> FND_API.G_MISS_CHAR) THEN

1296: BEGIN
1297: x_attribute_tbl(1).attribute_name := NULL;
1298: x_attribute_tbl(1).attribute_value := NULL;
1299: l_counter := l_counter + 1;
1300: IF (p_srch_attr_rec.attribute1 <> FND_API.G_MISS_CHAR) THEN
1301: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE1';
1302: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute1;
1303: l_counter := l_counter + 1;
1304: END IF;

Line 1305: IF (p_srch_attr_rec.attribute2 <> FND_API.G_MISS_CHAR) THEN

1301: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE1';
1302: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute1;
1303: l_counter := l_counter + 1;
1304: END IF;
1305: IF (p_srch_attr_rec.attribute2 <> FND_API.G_MISS_CHAR) THEN
1306: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE2';
1307: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute2;
1308: l_counter := l_counter + 1;
1309: END IF;

Line 1310: IF (p_srch_attr_rec.attribute3 <> FND_API.G_MISS_CHAR) THEN

1306: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE2';
1307: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute2;
1308: l_counter := l_counter + 1;
1309: END IF;
1310: IF (p_srch_attr_rec.attribute3 <> FND_API.G_MISS_CHAR) THEN
1311: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE3';
1312: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute3;
1313: l_counter := l_counter + 1;
1314: END IF;

Line 1315: IF (p_srch_attr_rec.attribute4 <> FND_API.G_MISS_CHAR) THEN

1311: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE3';
1312: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute3;
1313: l_counter := l_counter + 1;
1314: END IF;
1315: IF (p_srch_attr_rec.attribute4 <> FND_API.G_MISS_CHAR) THEN
1316: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE4';
1317: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute4;
1318: l_counter := l_counter + 1;
1319: END IF;

Line 1320: IF (p_srch_attr_rec.attribute5 <> FND_API.G_MISS_CHAR) THEN

1316: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE4';
1317: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute4;
1318: l_counter := l_counter + 1;
1319: END IF;
1320: IF (p_srch_attr_rec.attribute5 <> FND_API.G_MISS_CHAR) THEN
1321: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE5';
1322: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute5;
1323: l_counter := l_counter + 1;
1324: END IF;

Line 1325: IF (p_srch_attr_rec.attribute6 <> FND_API.G_MISS_CHAR) THEN

1321: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE5';
1322: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute5;
1323: l_counter := l_counter + 1;
1324: END IF;
1325: IF (p_srch_attr_rec.attribute6 <> FND_API.G_MISS_CHAR) THEN
1326: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE6';
1327: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute6;
1328: l_counter := l_counter + 1;
1329: END IF;

Line 1330: IF (p_srch_attr_rec.attribute7 <> FND_API.G_MISS_CHAR) THEN

1326: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE6';
1327: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute6;
1328: l_counter := l_counter + 1;
1329: END IF;
1330: IF (p_srch_attr_rec.attribute7 <> FND_API.G_MISS_CHAR) THEN
1331: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE7';
1332: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute7;
1333: l_counter := l_counter + 1;
1334: END IF;

Line 1335: IF (p_srch_attr_rec.attribute8 <> FND_API.G_MISS_CHAR) THEN

1331: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE7';
1332: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute7;
1333: l_counter := l_counter + 1;
1334: END IF;
1335: IF (p_srch_attr_rec.attribute8 <> FND_API.G_MISS_CHAR) THEN
1336: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE8';
1337: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute8;
1338: l_counter := l_counter + 1;
1339: END IF;

Line 1340: IF (p_srch_attr_rec.attribute9 <> FND_API.G_MISS_CHAR) THEN

1336: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE8';
1337: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute8;
1338: l_counter := l_counter + 1;
1339: END IF;
1340: IF (p_srch_attr_rec.attribute9 <> FND_API.G_MISS_CHAR) THEN
1341: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE9';
1342: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute9;
1343: l_counter := l_counter + 1;
1344: END IF;

Line 1345: IF (p_srch_attr_rec.attribute10 <> FND_API.G_MISS_CHAR) THEN

1341: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE9';
1342: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute9;
1343: l_counter := l_counter + 1;
1344: END IF;
1345: IF (p_srch_attr_rec.attribute10 <> FND_API.G_MISS_CHAR) THEN
1346: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE10';
1347: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute10;
1348: l_counter := l_counter + 1;
1349: END IF;

Line 1350: IF (p_srch_attr_rec.attribute11 <> FND_API.G_MISS_CHAR) THEN

1346: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE10';
1347: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute10;
1348: l_counter := l_counter + 1;
1349: END IF;
1350: IF (p_srch_attr_rec.attribute11 <> FND_API.G_MISS_CHAR) THEN
1351: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE11';
1352: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute11;
1353: l_counter := l_counter + 1;
1354: END IF;

Line 1355: IF (p_srch_attr_rec.attribute12 <> FND_API.G_MISS_CHAR) THEN

1351: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE11';
1352: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute11;
1353: l_counter := l_counter + 1;
1354: END IF;
1355: IF (p_srch_attr_rec.attribute12 <> FND_API.G_MISS_CHAR) THEN
1356: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE12';
1357: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute12;
1358: l_counter := l_counter + 1;
1359: END IF;

Line 1360: IF (p_srch_attr_rec.attribute13 <> FND_API.G_MISS_CHAR) THEN

1356: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE12';
1357: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute12;
1358: l_counter := l_counter + 1;
1359: END IF;
1360: IF (p_srch_attr_rec.attribute13 <> FND_API.G_MISS_CHAR) THEN
1361: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE13';
1362: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute13;
1363: l_counter := l_counter + 1;
1364: END IF;

Line 1365: IF (p_srch_attr_rec.attribute14 <> FND_API.G_MISS_CHAR) THEN

1361: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE13';
1362: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute13;
1363: l_counter := l_counter + 1;
1364: END IF;
1365: IF (p_srch_attr_rec.attribute14 <> FND_API.G_MISS_CHAR) THEN
1366: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE14';
1367: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute14;
1368: l_counter := l_counter + 1;
1369: END IF;

Line 1370: IF (p_srch_attr_rec.attribute15 <> FND_API.G_MISS_CHAR) THEN

1366: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE14';
1367: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute14;
1368: l_counter := l_counter + 1;
1369: END IF;
1370: IF (p_srch_attr_rec.attribute15 <> FND_API.G_MISS_CHAR) THEN
1371: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE15';
1372: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute15;
1373: l_counter := l_counter + 1;
1374: END IF;

Line 1375: IF (p_srch_attr_rec.attribute16 <> FND_API.G_MISS_CHAR) THEN

1371: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE15';
1372: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute15;
1373: l_counter := l_counter + 1;
1374: END IF;
1375: IF (p_srch_attr_rec.attribute16 <> FND_API.G_MISS_CHAR) THEN
1376: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE16';
1377: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute16;
1378: l_counter := l_counter + 1;
1379: END IF;

Line 1380: IF (p_srch_attr_rec.attribute17 <> FND_API.G_MISS_CHAR) THEN

1376: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE16';
1377: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute16;
1378: l_counter := l_counter + 1;
1379: END IF;
1380: IF (p_srch_attr_rec.attribute17 <> FND_API.G_MISS_CHAR) THEN
1381: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE17';
1382: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute17;
1383: l_counter := l_counter + 1;
1384: END IF;

Line 1385: IF (p_srch_attr_rec.attribute18 <> FND_API.G_MISS_CHAR) THEN

1381: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE17';
1382: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute17;
1383: l_counter := l_counter + 1;
1384: END IF;
1385: IF (p_srch_attr_rec.attribute18 <> FND_API.G_MISS_CHAR) THEN
1386: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE18';
1387: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute18;
1388: l_counter := l_counter + 1;
1389: END IF;

Line 1390: IF (p_srch_attr_rec.attribute19 <> FND_API.G_MISS_CHAR) THEN

1386: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE18';
1387: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute18;
1388: l_counter := l_counter + 1;
1389: END IF;
1390: IF (p_srch_attr_rec.attribute19 <> FND_API.G_MISS_CHAR) THEN
1391: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE19';
1392: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute19;
1393: l_counter := l_counter + 1;
1394: END IF;

Line 1395: IF (p_srch_attr_rec.attribute20 <> FND_API.G_MISS_CHAR) THEN

1391: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE19';
1392: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute19;
1393: l_counter := l_counter + 1;
1394: END IF;
1395: IF (p_srch_attr_rec.attribute20 <> FND_API.G_MISS_CHAR) THEN
1396: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE20';
1397: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute20;
1398: l_counter := l_counter + 1;
1399: END IF;

Line 1400: IF (p_srch_attr_rec.attribute21 <> FND_API.G_MISS_CHAR) THEN

1396: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE20';
1397: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute20;
1398: l_counter := l_counter + 1;
1399: END IF;
1400: IF (p_srch_attr_rec.attribute21 <> FND_API.G_MISS_CHAR) THEN
1401: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE21';
1402: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute21;
1403: l_counter := l_counter + 1;
1404: END IF;

Line 1405: IF (p_srch_attr_rec.attribute22 <> FND_API.G_MISS_CHAR) THEN

1401: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE21';
1402: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute21;
1403: l_counter := l_counter + 1;
1404: END IF;
1405: IF (p_srch_attr_rec.attribute22 <> FND_API.G_MISS_CHAR) THEN
1406: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE22';
1407: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute22;
1408: l_counter := l_counter + 1;
1409: END IF;

Line 1410: IF (p_srch_attr_rec.attribute23 <> FND_API.G_MISS_CHAR) THEN

1406: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE22';
1407: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute22;
1408: l_counter := l_counter + 1;
1409: END IF;
1410: IF (p_srch_attr_rec.attribute23 <> FND_API.G_MISS_CHAR) THEN
1411: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE23';
1412: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute23;
1413: l_counter := l_counter + 1;
1414: END IF;

Line 1415: IF (p_srch_attr_rec.attribute24 <> FND_API.G_MISS_CHAR) THEN

1411: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE23';
1412: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute23;
1413: l_counter := l_counter + 1;
1414: END IF;
1415: IF (p_srch_attr_rec.attribute24 <> FND_API.G_MISS_CHAR) THEN
1416: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE24';
1417: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute24;
1418: l_counter := l_counter + 1;
1419: END IF;

Line 1420: IF (p_srch_attr_rec.attribute25 <> FND_API.G_MISS_CHAR) THEN

1416: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE24';
1417: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute24;
1418: l_counter := l_counter + 1;
1419: END IF;
1420: IF (p_srch_attr_rec.attribute25 <> FND_API.G_MISS_CHAR) THEN
1421: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE25';
1422: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute25;
1423: l_counter := l_counter + 1;
1424: END IF;

Line 1425: IF (p_srch_attr_rec.attribute26 <> FND_API.G_MISS_CHAR) THEN

1421: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE25';
1422: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute25;
1423: l_counter := l_counter + 1;
1424: END IF;
1425: IF (p_srch_attr_rec.attribute26 <> FND_API.G_MISS_CHAR) THEN
1426: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE26';
1427: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute26;
1428: l_counter := l_counter + 1;
1429: END IF;

Line 1430: IF (p_srch_attr_rec.attribute27 <> FND_API.G_MISS_CHAR) THEN

1426: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE26';
1427: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute26;
1428: l_counter := l_counter + 1;
1429: END IF;
1430: IF (p_srch_attr_rec.attribute27 <> FND_API.G_MISS_CHAR) THEN
1431: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE27';
1432: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute27;
1433: l_counter := l_counter + 1;
1434: END IF;

Line 1435: IF (p_srch_attr_rec.attribute28 <> FND_API.G_MISS_CHAR) THEN

1431: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE27';
1432: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute27;
1433: l_counter := l_counter + 1;
1434: END IF;
1435: IF (p_srch_attr_rec.attribute28 <> FND_API.G_MISS_CHAR) THEN
1436: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE28';
1437: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute28;
1438: l_counter := l_counter + 1;
1439: END IF;

Line 1440: IF (p_srch_attr_rec.attribute29 <> FND_API.G_MISS_CHAR) THEN

1436: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE28';
1437: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute28;
1438: l_counter := l_counter + 1;
1439: END IF;
1440: IF (p_srch_attr_rec.attribute29 <> FND_API.G_MISS_CHAR) THEN
1441: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE29';
1442: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute29;
1443: l_counter := l_counter + 1;
1444: END IF;

Line 1445: IF (p_srch_attr_rec.attribute30 <> FND_API.G_MISS_CHAR) THEN

1441: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE29';
1442: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute29;
1443: l_counter := l_counter + 1;
1444: END IF;
1445: IF (p_srch_attr_rec.attribute30 <> FND_API.G_MISS_CHAR) THEN
1446: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE30';
1447: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute30;
1448: l_counter := l_counter + 1;
1449: END IF;

Line 1450: IF (p_srch_attr_rec.attribute31 <> FND_API.G_MISS_CHAR) THEN

1446: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE30';
1447: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute30;
1448: l_counter := l_counter + 1;
1449: END IF;
1450: IF (p_srch_attr_rec.attribute31 <> FND_API.G_MISS_CHAR) THEN
1451: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE31';
1452: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute31;
1453: l_counter := l_counter + 1;
1454: END IF;

Line 1455: IF (p_srch_attr_rec.attribute32 <> FND_API.G_MISS_CHAR) THEN

1451: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE31';
1452: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute31;
1453: l_counter := l_counter + 1;
1454: END IF;
1455: IF (p_srch_attr_rec.attribute32 <> FND_API.G_MISS_CHAR) THEN
1456: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE32';
1457: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute32;
1458: l_counter := l_counter + 1;
1459: END IF;

Line 1460: IF (p_srch_attr_rec.attribute33 <> FND_API.G_MISS_CHAR) THEN

1456: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE32';
1457: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute32;
1458: l_counter := l_counter + 1;
1459: END IF;
1460: IF (p_srch_attr_rec.attribute33 <> FND_API.G_MISS_CHAR) THEN
1461: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE33';
1462: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute33;
1463: l_counter := l_counter + 1;
1464: END IF;

Line 1465: IF (p_srch_attr_rec.attribute34 <> FND_API.G_MISS_CHAR) THEN

1461: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE33';
1462: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute33;
1463: l_counter := l_counter + 1;
1464: END IF;
1465: IF (p_srch_attr_rec.attribute34 <> FND_API.G_MISS_CHAR) THEN
1466: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE34';
1467: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute34;
1468: l_counter := l_counter + 1;
1469: END IF;

Line 1470: IF (p_srch_attr_rec.attribute35 <> FND_API.G_MISS_CHAR) THEN

1466: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE34';
1467: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute34;
1468: l_counter := l_counter + 1;
1469: END IF;
1470: IF (p_srch_attr_rec.attribute35 <> FND_API.G_MISS_CHAR) THEN
1471: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE35';
1472: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute35;
1473: l_counter := l_counter + 1;
1474: END IF;

Line 1475: IF (p_srch_attr_rec.attribute36 <> FND_API.G_MISS_CHAR) THEN

1471: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE35';
1472: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute35;
1473: l_counter := l_counter + 1;
1474: END IF;
1475: IF (p_srch_attr_rec.attribute36 <> FND_API.G_MISS_CHAR) THEN
1476: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE36';
1477: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute36;
1478: l_counter := l_counter + 1;
1479: END IF;

Line 1480: IF (p_srch_attr_rec.attribute37 <> FND_API.G_MISS_CHAR) THEN

1476: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE36';
1477: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute36;
1478: l_counter := l_counter + 1;
1479: END IF;
1480: IF (p_srch_attr_rec.attribute37 <> FND_API.G_MISS_CHAR) THEN
1481: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE37';
1482: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute37;
1483: l_counter := l_counter + 1;
1484: END IF;

Line 1485: IF (p_srch_attr_rec.attribute38 <> FND_API.G_MISS_CHAR) THEN

1481: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE37';
1482: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute37;
1483: l_counter := l_counter + 1;
1484: END IF;
1485: IF (p_srch_attr_rec.attribute38 <> FND_API.G_MISS_CHAR) THEN
1486: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE38';
1487: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute38;
1488: l_counter := l_counter + 1;
1489: END IF;

Line 1490: IF (p_srch_attr_rec.attribute39 <> FND_API.G_MISS_CHAR) THEN

1486: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE38';
1487: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute38;
1488: l_counter := l_counter + 1;
1489: END IF;
1490: IF (p_srch_attr_rec.attribute39 <> FND_API.G_MISS_CHAR) THEN
1491: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE39';
1492: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute39;
1493: l_counter := l_counter + 1;
1494: END IF;

Line 1495: IF (p_srch_attr_rec.attribute40 <> FND_API.G_MISS_CHAR) THEN

1491: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE39';
1492: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute39;
1493: l_counter := l_counter + 1;
1494: END IF;
1495: IF (p_srch_attr_rec.attribute40 <> FND_API.G_MISS_CHAR) THEN
1496: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE40';
1497: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute40;
1498: l_counter := l_counter + 1;
1499: END IF;

Line 1500: IF (p_srch_attr_rec.attribute41 <> FND_API.G_MISS_CHAR) THEN

1496: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE40';
1497: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute40;
1498: l_counter := l_counter + 1;
1499: END IF;
1500: IF (p_srch_attr_rec.attribute41 <> FND_API.G_MISS_CHAR) THEN
1501: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE41';
1502: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute41;
1503: l_counter := l_counter + 1;
1504: END IF;

Line 1505: IF (p_srch_attr_rec.attribute42 <> FND_API.G_MISS_CHAR) THEN

1501: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE41';
1502: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute41;
1503: l_counter := l_counter + 1;
1504: END IF;
1505: IF (p_srch_attr_rec.attribute42 <> FND_API.G_MISS_CHAR) THEN
1506: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE42';
1507: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute42;
1508: l_counter := l_counter + 1;
1509: END IF;

Line 1510: IF (p_srch_attr_rec.attribute43 <> FND_API.G_MISS_CHAR) THEN

1506: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE42';
1507: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute42;
1508: l_counter := l_counter + 1;
1509: END IF;
1510: IF (p_srch_attr_rec.attribute43 <> FND_API.G_MISS_CHAR) THEN
1511: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE43';
1512: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute43;
1513: l_counter := l_counter + 1;
1514: END IF;

Line 1515: IF (p_srch_attr_rec.attribute44 <> FND_API.G_MISS_CHAR) THEN

1511: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE43';
1512: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute43;
1513: l_counter := l_counter + 1;
1514: END IF;
1515: IF (p_srch_attr_rec.attribute44 <> FND_API.G_MISS_CHAR) THEN
1516: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE44';
1517: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute44;
1518: l_counter := l_counter + 1;
1519: END IF;

Line 1520: IF (p_srch_attr_rec.attribute45 <> FND_API.G_MISS_CHAR) THEN

1516: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE44';
1517: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute44;
1518: l_counter := l_counter + 1;
1519: END IF;
1520: IF (p_srch_attr_rec.attribute45 <> FND_API.G_MISS_CHAR) THEN
1521: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE45';
1522: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute45;
1523: l_counter := l_counter + 1;
1524: END IF;

Line 1525: IF (p_srch_attr_rec.attribute46 <> FND_API.G_MISS_CHAR) THEN

1521: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE45';
1522: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute45;
1523: l_counter := l_counter + 1;
1524: END IF;
1525: IF (p_srch_attr_rec.attribute46 <> FND_API.G_MISS_CHAR) THEN
1526: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE46';
1527: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute46;
1528: l_counter := l_counter + 1;
1529: END IF;

Line 1530: IF (p_srch_attr_rec.attribute47 <> FND_API.G_MISS_CHAR) THEN

1526: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE46';
1527: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute46;
1528: l_counter := l_counter + 1;
1529: END IF;
1530: IF (p_srch_attr_rec.attribute47 <> FND_API.G_MISS_CHAR) THEN
1531: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE47';
1532: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute47;
1533: l_counter := l_counter + 1;
1534: END IF;

Line 1535: IF (p_srch_attr_rec.attribute48 <> FND_API.G_MISS_CHAR) THEN

1531: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE47';
1532: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute47;
1533: l_counter := l_counter + 1;
1534: END IF;
1535: IF (p_srch_attr_rec.attribute48 <> FND_API.G_MISS_CHAR) THEN
1536: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE48';
1537: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute48;
1538: l_counter := l_counter + 1;
1539: END IF;

Line 1540: IF (p_srch_attr_rec.attribute49 <> FND_API.G_MISS_CHAR) THEN

1536: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE48';
1537: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute48;
1538: l_counter := l_counter + 1;
1539: END IF;
1540: IF (p_srch_attr_rec.attribute49 <> FND_API.G_MISS_CHAR) THEN
1541: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE49';
1542: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute49;
1543: l_counter := l_counter + 1;
1544: END IF;

Line 1545: IF (p_srch_attr_rec.attribute50 <> FND_API.G_MISS_CHAR) THEN

1541: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE49';
1542: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute49;
1543: l_counter := l_counter + 1;
1544: END IF;
1545: IF (p_srch_attr_rec.attribute50 <> FND_API.G_MISS_CHAR) THEN
1546: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE50';
1547: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute50;
1548: l_counter := l_counter + 1;
1549: END IF;

Line 1550: IF (p_srch_attr_rec.attribute51 <> FND_API.G_MISS_CHAR) THEN

1546: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE50';
1547: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute50;
1548: l_counter := l_counter + 1;
1549: END IF;
1550: IF (p_srch_attr_rec.attribute51 <> FND_API.G_MISS_CHAR) THEN
1551: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE51';
1552: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute51;
1553: l_counter := l_counter + 1;
1554: END IF;

Line 1555: IF (p_srch_attr_rec.attribute52 <> FND_API.G_MISS_CHAR) THEN

1551: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE51';
1552: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute51;
1553: l_counter := l_counter + 1;
1554: END IF;
1555: IF (p_srch_attr_rec.attribute52 <> FND_API.G_MISS_CHAR) THEN
1556: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE52';
1557: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute52;
1558: l_counter := l_counter + 1;
1559: END IF;

Line 1560: IF (p_srch_attr_rec.attribute53 <> FND_API.G_MISS_CHAR) THEN

1556: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE52';
1557: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute52;
1558: l_counter := l_counter + 1;
1559: END IF;
1560: IF (p_srch_attr_rec.attribute53 <> FND_API.G_MISS_CHAR) THEN
1561: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE53';
1562: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute53;
1563: l_counter := l_counter + 1;
1564: END IF;

Line 1565: IF (p_srch_attr_rec.attribute54 <> FND_API.G_MISS_CHAR) THEN

1561: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE53';
1562: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute53;
1563: l_counter := l_counter + 1;
1564: END IF;
1565: IF (p_srch_attr_rec.attribute54 <> FND_API.G_MISS_CHAR) THEN
1566: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE54';
1567: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute54;
1568: l_counter := l_counter + 1;
1569: END IF;

Line 1570: IF (p_srch_attr_rec.attribute55 <> FND_API.G_MISS_CHAR) THEN

1566: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE54';
1567: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute54;
1568: l_counter := l_counter + 1;
1569: END IF;
1570: IF (p_srch_attr_rec.attribute55 <> FND_API.G_MISS_CHAR) THEN
1571: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE55';
1572: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute55;
1573: l_counter := l_counter + 1;
1574: END IF;

Line 1575: IF (p_srch_attr_rec.attribute56 <> FND_API.G_MISS_CHAR) THEN

1571: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE55';
1572: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute55;
1573: l_counter := l_counter + 1;
1574: END IF;
1575: IF (p_srch_attr_rec.attribute56 <> FND_API.G_MISS_CHAR) THEN
1576: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE56';
1577: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute56;
1578: l_counter := l_counter + 1;
1579: END IF;

Line 1580: IF (p_srch_attr_rec.attribute57 <> FND_API.G_MISS_CHAR) THEN

1576: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE56';
1577: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute56;
1578: l_counter := l_counter + 1;
1579: END IF;
1580: IF (p_srch_attr_rec.attribute57 <> FND_API.G_MISS_CHAR) THEN
1581: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE57';
1582: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute57;
1583: l_counter := l_counter + 1;
1584: END IF;

Line 1585: IF (p_srch_attr_rec.attribute58 <> FND_API.G_MISS_CHAR) THEN

1581: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE57';
1582: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute57;
1583: l_counter := l_counter + 1;
1584: END IF;
1585: IF (p_srch_attr_rec.attribute58 <> FND_API.G_MISS_CHAR) THEN
1586: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE58';
1587: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute58;
1588: l_counter := l_counter + 1;
1589: END IF;

Line 1590: IF (p_srch_attr_rec.attribute59 <> FND_API.G_MISS_CHAR) THEN

1586: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE58';
1587: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute58;
1588: l_counter := l_counter + 1;
1589: END IF;
1590: IF (p_srch_attr_rec.attribute59 <> FND_API.G_MISS_CHAR) THEN
1591: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE59';
1592: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute59;
1593: l_counter := l_counter + 1;
1594: END IF;

Line 1595: IF (p_srch_attr_rec.attribute60 <> FND_API.G_MISS_CHAR) THEN

1591: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE59';
1592: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute59;
1593: l_counter := l_counter + 1;
1594: END IF;
1595: IF (p_srch_attr_rec.attribute60 <> FND_API.G_MISS_CHAR) THEN
1596: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE60';
1597: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute60;
1598: l_counter := l_counter + 1;
1599: END IF;

Line 1600: IF (p_srch_attr_rec.attribute61 <> FND_API.G_MISS_CHAR) THEN

1596: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE60';
1597: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute60;
1598: l_counter := l_counter + 1;
1599: END IF;
1600: IF (p_srch_attr_rec.attribute61 <> FND_API.G_MISS_CHAR) THEN
1601: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE61';
1602: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute61;
1603: l_counter := l_counter + 1;
1604: END IF;

Line 1605: IF (p_srch_attr_rec.attribute62 <> FND_API.G_MISS_CHAR) THEN

1601: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE61';
1602: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute61;
1603: l_counter := l_counter + 1;
1604: END IF;
1605: IF (p_srch_attr_rec.attribute62 <> FND_API.G_MISS_CHAR) THEN
1606: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE62';
1607: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute62;
1608: l_counter := l_counter + 1;
1609: END IF;

Line 1610: IF (p_srch_attr_rec.attribute63 <> FND_API.G_MISS_CHAR) THEN

1606: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE62';
1607: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute62;
1608: l_counter := l_counter + 1;
1609: END IF;
1610: IF (p_srch_attr_rec.attribute63 <> FND_API.G_MISS_CHAR) THEN
1611: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE63';
1612: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute63;
1613: l_counter := l_counter + 1;
1614: END IF;

Line 1615: IF (p_srch_attr_rec.attribute64 <> FND_API.G_MISS_CHAR) THEN

1611: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE63';
1612: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute63;
1613: l_counter := l_counter + 1;
1614: END IF;
1615: IF (p_srch_attr_rec.attribute64 <> FND_API.G_MISS_CHAR) THEN
1616: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE64';
1617: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute64;
1618: l_counter := l_counter + 1;
1619: END IF;

Line 1620: IF (p_srch_attr_rec.attribute65 <> FND_API.G_MISS_CHAR) THEN

1616: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE64';
1617: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute64;
1618: l_counter := l_counter + 1;
1619: END IF;
1620: IF (p_srch_attr_rec.attribute65 <> FND_API.G_MISS_CHAR) THEN
1621: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE65';
1622: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute65;
1623: l_counter := l_counter + 1;
1624: END IF;

Line 1625: IF (p_srch_attr_rec.attribute66 <> FND_API.G_MISS_CHAR) THEN

1621: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE65';
1622: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute65;
1623: l_counter := l_counter + 1;
1624: END IF;
1625: IF (p_srch_attr_rec.attribute66 <> FND_API.G_MISS_CHAR) THEN
1626: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE66';
1627: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute66;
1628: l_counter := l_counter + 1;
1629: END IF;

Line 1630: IF (p_srch_attr_rec.attribute67 <> FND_API.G_MISS_CHAR) THEN

1626: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE66';
1627: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute66;
1628: l_counter := l_counter + 1;
1629: END IF;
1630: IF (p_srch_attr_rec.attribute67 <> FND_API.G_MISS_CHAR) THEN
1631: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE67';
1632: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute67;
1633: l_counter := l_counter + 1;
1634: END IF;

Line 1635: IF (p_srch_attr_rec.attribute68 <> FND_API.G_MISS_CHAR) THEN

1631: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE67';
1632: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute67;
1633: l_counter := l_counter + 1;
1634: END IF;
1635: IF (p_srch_attr_rec.attribute68 <> FND_API.G_MISS_CHAR) THEN
1636: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE68';
1637: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute68;
1638: l_counter := l_counter + 1;
1639: END IF;

Line 1640: IF (p_srch_attr_rec.attribute69 <> FND_API.G_MISS_CHAR) THEN

1636: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE68';
1637: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute68;
1638: l_counter := l_counter + 1;
1639: END IF;
1640: IF (p_srch_attr_rec.attribute69 <> FND_API.G_MISS_CHAR) THEN
1641: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE69';
1642: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute69;
1643: l_counter := l_counter + 1;
1644: END IF;

Line 1645: IF (p_srch_attr_rec.attribute70 <> FND_API.G_MISS_CHAR) THEN

1641: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE69';
1642: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute69;
1643: l_counter := l_counter + 1;
1644: END IF;
1645: IF (p_srch_attr_rec.attribute70 <> FND_API.G_MISS_CHAR) THEN
1646: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE70';
1647: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute70;
1648: l_counter := l_counter + 1;
1649: END IF;

Line 1650: IF (p_srch_attr_rec.attribute71 <> FND_API.G_MISS_CHAR) THEN

1646: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE70';
1647: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute70;
1648: l_counter := l_counter + 1;
1649: END IF;
1650: IF (p_srch_attr_rec.attribute71 <> FND_API.G_MISS_CHAR) THEN
1651: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE71';
1652: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute71;
1653: l_counter := l_counter + 1;
1654: END IF;

Line 1655: IF (p_srch_attr_rec.attribute72 <> FND_API.G_MISS_CHAR) THEN

1651: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE71';
1652: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute71;
1653: l_counter := l_counter + 1;
1654: END IF;
1655: IF (p_srch_attr_rec.attribute72 <> FND_API.G_MISS_CHAR) THEN
1656: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE72';
1657: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute72;
1658: l_counter := l_counter + 1;
1659: END IF;

Line 1660: IF (p_srch_attr_rec.attribute73 <> FND_API.G_MISS_CHAR) THEN

1656: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE72';
1657: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute72;
1658: l_counter := l_counter + 1;
1659: END IF;
1660: IF (p_srch_attr_rec.attribute73 <> FND_API.G_MISS_CHAR) THEN
1661: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE73';
1662: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute73;
1663: l_counter := l_counter + 1;
1664: END IF;

Line 1665: IF (p_srch_attr_rec.attribute74 <> FND_API.G_MISS_CHAR) THEN

1661: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE73';
1662: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute73;
1663: l_counter := l_counter + 1;
1664: END IF;
1665: IF (p_srch_attr_rec.attribute74 <> FND_API.G_MISS_CHAR) THEN
1666: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE74';
1667: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute74;
1668: l_counter := l_counter + 1;
1669: END IF;

Line 1670: IF (p_srch_attr_rec.attribute75 <> FND_API.G_MISS_CHAR) THEN

1666: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE74';
1667: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute74;
1668: l_counter := l_counter + 1;
1669: END IF;
1670: IF (p_srch_attr_rec.attribute75 <> FND_API.G_MISS_CHAR) THEN
1671: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE75';
1672: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute75;
1673: l_counter := l_counter + 1;
1674: END IF;

Line 1675: IF (p_srch_attr_rec.attribute76 <> FND_API.G_MISS_CHAR) THEN

1671: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE75';
1672: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute75;
1673: l_counter := l_counter + 1;
1674: END IF;
1675: IF (p_srch_attr_rec.attribute76 <> FND_API.G_MISS_CHAR) THEN
1676: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE76';
1677: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute76;
1678: l_counter := l_counter + 1;
1679: END IF;

Line 1680: IF (p_srch_attr_rec.attribute77 <> FND_API.G_MISS_CHAR) THEN

1676: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE76';
1677: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute76;
1678: l_counter := l_counter + 1;
1679: END IF;
1680: IF (p_srch_attr_rec.attribute77 <> FND_API.G_MISS_CHAR) THEN
1681: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE77';
1682: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute77;
1683: l_counter := l_counter + 1;
1684: END IF;

Line 1685: IF (p_srch_attr_rec.attribute78 <> FND_API.G_MISS_CHAR) THEN

1681: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE77';
1682: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute77;
1683: l_counter := l_counter + 1;
1684: END IF;
1685: IF (p_srch_attr_rec.attribute78 <> FND_API.G_MISS_CHAR) THEN
1686: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE78';
1687: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute78;
1688: l_counter := l_counter + 1;
1689: END IF;

Line 1690: IF (p_srch_attr_rec.attribute79 <> FND_API.G_MISS_CHAR) THEN

1686: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE78';
1687: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute78;
1688: l_counter := l_counter + 1;
1689: END IF;
1690: IF (p_srch_attr_rec.attribute79 <> FND_API.G_MISS_CHAR) THEN
1691: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE79';
1692: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute79;
1693: l_counter := l_counter + 1;
1694: END IF;

Line 1695: IF (p_srch_attr_rec.attribute80 <> FND_API.G_MISS_CHAR) THEN

1691: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE79';
1692: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute79;
1693: l_counter := l_counter + 1;
1694: END IF;
1695: IF (p_srch_attr_rec.attribute80 <> FND_API.G_MISS_CHAR) THEN
1696: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE80';
1697: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute80;
1698: l_counter := l_counter + 1;
1699: END IF;

Line 1700: IF (p_srch_attr_rec.attribute81 <> FND_API.G_MISS_CHAR) THEN

1696: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE80';
1697: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute80;
1698: l_counter := l_counter + 1;
1699: END IF;
1700: IF (p_srch_attr_rec.attribute81 <> FND_API.G_MISS_CHAR) THEN
1701: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE81';
1702: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute81;
1703: l_counter := l_counter + 1;
1704: END IF;

Line 1705: IF (p_srch_attr_rec.attribute82 <> FND_API.G_MISS_CHAR) THEN

1701: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE81';
1702: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute81;
1703: l_counter := l_counter + 1;
1704: END IF;
1705: IF (p_srch_attr_rec.attribute82 <> FND_API.G_MISS_CHAR) THEN
1706: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE82';
1707: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute82;
1708: l_counter := l_counter + 1;
1709: END IF;

Line 1710: IF (p_srch_attr_rec.attribute83 <> FND_API.G_MISS_CHAR) THEN

1706: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE82';
1707: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute82;
1708: l_counter := l_counter + 1;
1709: END IF;
1710: IF (p_srch_attr_rec.attribute83 <> FND_API.G_MISS_CHAR) THEN
1711: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE83';
1712: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute83;
1713: l_counter := l_counter + 1;
1714: END IF;

Line 1715: IF (p_srch_attr_rec.attribute84 <> FND_API.G_MISS_CHAR) THEN

1711: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE83';
1712: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute83;
1713: l_counter := l_counter + 1;
1714: END IF;
1715: IF (p_srch_attr_rec.attribute84 <> FND_API.G_MISS_CHAR) THEN
1716: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE84';
1717: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute84;
1718: l_counter := l_counter + 1;
1719: END IF;

Line 1720: IF (p_srch_attr_rec.attribute85 <> FND_API.G_MISS_CHAR) THEN

1716: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE84';
1717: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute84;
1718: l_counter := l_counter + 1;
1719: END IF;
1720: IF (p_srch_attr_rec.attribute85 <> FND_API.G_MISS_CHAR) THEN
1721: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE85';
1722: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute85;
1723: l_counter := l_counter + 1;
1724: END IF;

Line 1725: IF (p_srch_attr_rec.attribute86 <> FND_API.G_MISS_CHAR) THEN

1721: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE85';
1722: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute85;
1723: l_counter := l_counter + 1;
1724: END IF;
1725: IF (p_srch_attr_rec.attribute86 <> FND_API.G_MISS_CHAR) THEN
1726: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE86';
1727: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute86;
1728: l_counter := l_counter + 1;
1729: END IF;

Line 1730: IF (p_srch_attr_rec.attribute87 <> FND_API.G_MISS_CHAR) THEN

1726: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE86';
1727: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute86;
1728: l_counter := l_counter + 1;
1729: END IF;
1730: IF (p_srch_attr_rec.attribute87 <> FND_API.G_MISS_CHAR) THEN
1731: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE87';
1732: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute87;
1733: l_counter := l_counter + 1;
1734: END IF;

Line 1735: IF (p_srch_attr_rec.attribute88 <> FND_API.G_MISS_CHAR) THEN

1731: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE87';
1732: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute87;
1733: l_counter := l_counter + 1;
1734: END IF;
1735: IF (p_srch_attr_rec.attribute88 <> FND_API.G_MISS_CHAR) THEN
1736: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE88';
1737: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute88;
1738: l_counter := l_counter + 1;
1739: END IF;

Line 1740: IF (p_srch_attr_rec.attribute89 <> FND_API.G_MISS_CHAR) THEN

1736: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE88';
1737: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute88;
1738: l_counter := l_counter + 1;
1739: END IF;
1740: IF (p_srch_attr_rec.attribute89 <> FND_API.G_MISS_CHAR) THEN
1741: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE89';
1742: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute89;
1743: l_counter := l_counter + 1;
1744: END IF;

Line 1745: IF (p_srch_attr_rec.attribute90 <> FND_API.G_MISS_CHAR) THEN

1741: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE89';
1742: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute89;
1743: l_counter := l_counter + 1;
1744: END IF;
1745: IF (p_srch_attr_rec.attribute90 <> FND_API.G_MISS_CHAR) THEN
1746: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE90';
1747: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute90;
1748: l_counter := l_counter + 1;
1749: END IF;

Line 1750: IF (p_srch_attr_rec.attribute91 <> FND_API.G_MISS_CHAR) THEN

1746: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE90';
1747: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute90;
1748: l_counter := l_counter + 1;
1749: END IF;
1750: IF (p_srch_attr_rec.attribute91 <> FND_API.G_MISS_CHAR) THEN
1751: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE91';
1752: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute91;
1753: l_counter := l_counter + 1;
1754: END IF;

Line 1755: IF (p_srch_attr_rec.attribute92 <> FND_API.G_MISS_CHAR) THEN

1751: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE91';
1752: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute91;
1753: l_counter := l_counter + 1;
1754: END IF;
1755: IF (p_srch_attr_rec.attribute92 <> FND_API.G_MISS_CHAR) THEN
1756: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE92';
1757: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute92;
1758: l_counter := l_counter + 1;
1759: END IF;

Line 1760: IF (p_srch_attr_rec.attribute93 <> FND_API.G_MISS_CHAR) THEN

1756: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE92';
1757: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute92;
1758: l_counter := l_counter + 1;
1759: END IF;
1760: IF (p_srch_attr_rec.attribute93 <> FND_API.G_MISS_CHAR) THEN
1761: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE93';
1762: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute93;
1763: l_counter := l_counter + 1;
1764: END IF;

Line 1765: IF (p_srch_attr_rec.attribute94 <> FND_API.G_MISS_CHAR) THEN

1761: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE93';
1762: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute93;
1763: l_counter := l_counter + 1;
1764: END IF;
1765: IF (p_srch_attr_rec.attribute94 <> FND_API.G_MISS_CHAR) THEN
1766: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE94';
1767: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute94;
1768: l_counter := l_counter + 1;
1769: END IF;

Line 1770: IF (p_srch_attr_rec.attribute95 <> FND_API.G_MISS_CHAR) THEN

1766: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE94';
1767: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute94;
1768: l_counter := l_counter + 1;
1769: END IF;
1770: IF (p_srch_attr_rec.attribute95 <> FND_API.G_MISS_CHAR) THEN
1771: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE95';
1772: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute95;
1773: l_counter := l_counter + 1;
1774: END IF;

Line 1775: IF (p_srch_attr_rec.attribute96 <> FND_API.G_MISS_CHAR) THEN

1771: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE95';
1772: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute95;
1773: l_counter := l_counter + 1;
1774: END IF;
1775: IF (p_srch_attr_rec.attribute96 <> FND_API.G_MISS_CHAR) THEN
1776: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE96';
1777: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute96;
1778: l_counter := l_counter + 1;
1779: END IF;

Line 1780: IF (p_srch_attr_rec.attribute97 <> FND_API.G_MISS_CHAR) THEN

1776: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE96';
1777: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute96;
1778: l_counter := l_counter + 1;
1779: END IF;
1780: IF (p_srch_attr_rec.attribute97 <> FND_API.G_MISS_CHAR) THEN
1781: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE97';
1782: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute97;
1783: l_counter := l_counter + 1;
1784: END IF;

Line 1785: IF (p_srch_attr_rec.attribute98 <> FND_API.G_MISS_CHAR) THEN

1781: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE97';
1782: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute97;
1783: l_counter := l_counter + 1;
1784: END IF;
1785: IF (p_srch_attr_rec.attribute98 <> FND_API.G_MISS_CHAR) THEN
1786: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE98';
1787: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute98;
1788: l_counter := l_counter + 1;
1789: END IF;

Line 1790: IF (p_srch_attr_rec.attribute99 <> FND_API.G_MISS_CHAR) THEN

1786: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE98';
1787: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute98;
1788: l_counter := l_counter + 1;
1789: END IF;
1790: IF (p_srch_attr_rec.attribute99 <> FND_API.G_MISS_CHAR) THEN
1791: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE99';
1792: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute99;
1793: l_counter := l_counter + 1;
1794: END IF;

Line 1795: IF (p_srch_attr_rec.attribute100 <> FND_API.G_MISS_CHAR) THEN

1791: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE99';
1792: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute99;
1793: l_counter := l_counter + 1;
1794: END IF;
1795: IF (p_srch_attr_rec.attribute100 <> FND_API.G_MISS_CHAR) THEN
1796: x_attribute_tbl(l_counter).attribute_name := 'ATTRIBUTE100';
1797: x_attribute_tbl(l_counter).attribute_value := p_srch_attr_rec.attribute100;
1798: l_counter := l_counter + 1;
1799: END IF;

Line 1808: SELECT DECODE(p_rec.direct_salesrep_id, null, fnd_api.g_miss_num, p_rec.direct_salesrep_id),

1804: x_api_rec OUT NOCOPY cn_get_tx_data_pub.adj_rec_type) IS
1805:
1806: BEGIN
1807:
1808: SELECT DECODE(p_rec.direct_salesrep_id, null, fnd_api.g_miss_num, p_rec.direct_salesrep_id),
1809: DECODE(p_rec.processed_date, null, fnd_api.g_miss_date, p_rec.processed_date),
1810: DECODE(p_rec.processed_period_id, null, fnd_api.g_miss_num, p_rec.processed_period_id),
1811: DECODE(p_rec.transaction_amount, null, fnd_api.g_miss_num, p_rec.transaction_amount),
1812: DECODE(p_rec.trx_type, null, fnd_api.g_miss_char,p_rec.trx_type),

Line 1809: DECODE(p_rec.processed_date, null, fnd_api.g_miss_date, p_rec.processed_date),

1805:
1806: BEGIN
1807:
1808: SELECT DECODE(p_rec.direct_salesrep_id, null, fnd_api.g_miss_num, p_rec.direct_salesrep_id),
1809: DECODE(p_rec.processed_date, null, fnd_api.g_miss_date, p_rec.processed_date),
1810: DECODE(p_rec.processed_period_id, null, fnd_api.g_miss_num, p_rec.processed_period_id),
1811: DECODE(p_rec.transaction_amount, null, fnd_api.g_miss_num, p_rec.transaction_amount),
1812: DECODE(p_rec.trx_type, null, fnd_api.g_miss_char,p_rec.trx_type),
1813: DECODE(p_rec.revenue_class_id, null, fnd_api.g_miss_num, p_rec.revenue_class_id),

Line 1810: DECODE(p_rec.processed_period_id, null, fnd_api.g_miss_num, p_rec.processed_period_id),

1806: BEGIN
1807:
1808: SELECT DECODE(p_rec.direct_salesrep_id, null, fnd_api.g_miss_num, p_rec.direct_salesrep_id),
1809: DECODE(p_rec.processed_date, null, fnd_api.g_miss_date, p_rec.processed_date),
1810: DECODE(p_rec.processed_period_id, null, fnd_api.g_miss_num, p_rec.processed_period_id),
1811: DECODE(p_rec.transaction_amount, null, fnd_api.g_miss_num, p_rec.transaction_amount),
1812: DECODE(p_rec.trx_type, null, fnd_api.g_miss_char,p_rec.trx_type),
1813: DECODE(p_rec.revenue_class_id, null, fnd_api.g_miss_num, p_rec.revenue_class_id),
1814: DECODE(p_rec.load_status, null, fnd_api.g_miss_char, p_rec.load_status),

Line 1811: DECODE(p_rec.transaction_amount, null, fnd_api.g_miss_num, p_rec.transaction_amount),

1807:
1808: SELECT DECODE(p_rec.direct_salesrep_id, null, fnd_api.g_miss_num, p_rec.direct_salesrep_id),
1809: DECODE(p_rec.processed_date, null, fnd_api.g_miss_date, p_rec.processed_date),
1810: DECODE(p_rec.processed_period_id, null, fnd_api.g_miss_num, p_rec.processed_period_id),
1811: DECODE(p_rec.transaction_amount, null, fnd_api.g_miss_num, p_rec.transaction_amount),
1812: DECODE(p_rec.trx_type, null, fnd_api.g_miss_char,p_rec.trx_type),
1813: DECODE(p_rec.revenue_class_id, null, fnd_api.g_miss_num, p_rec.revenue_class_id),
1814: DECODE(p_rec.load_status, null, fnd_api.g_miss_char, p_rec.load_status),
1815: DECODE(p_rec.attribute1,null, fnd_api.g_miss_char, p_rec.attribute1),

Line 1812: DECODE(p_rec.trx_type, null, fnd_api.g_miss_char,p_rec.trx_type),

1808: SELECT DECODE(p_rec.direct_salesrep_id, null, fnd_api.g_miss_num, p_rec.direct_salesrep_id),
1809: DECODE(p_rec.processed_date, null, fnd_api.g_miss_date, p_rec.processed_date),
1810: DECODE(p_rec.processed_period_id, null, fnd_api.g_miss_num, p_rec.processed_period_id),
1811: DECODE(p_rec.transaction_amount, null, fnd_api.g_miss_num, p_rec.transaction_amount),
1812: DECODE(p_rec.trx_type, null, fnd_api.g_miss_char,p_rec.trx_type),
1813: DECODE(p_rec.revenue_class_id, null, fnd_api.g_miss_num, p_rec.revenue_class_id),
1814: DECODE(p_rec.load_status, null, fnd_api.g_miss_char, p_rec.load_status),
1815: DECODE(p_rec.attribute1,null, fnd_api.g_miss_char, p_rec.attribute1),
1816: DECODE(p_rec.attribute2,null, fnd_api.g_miss_char, p_rec.attribute2),

Line 1813: DECODE(p_rec.revenue_class_id, null, fnd_api.g_miss_num, p_rec.revenue_class_id),

1809: DECODE(p_rec.processed_date, null, fnd_api.g_miss_date, p_rec.processed_date),
1810: DECODE(p_rec.processed_period_id, null, fnd_api.g_miss_num, p_rec.processed_period_id),
1811: DECODE(p_rec.transaction_amount, null, fnd_api.g_miss_num, p_rec.transaction_amount),
1812: DECODE(p_rec.trx_type, null, fnd_api.g_miss_char,p_rec.trx_type),
1813: DECODE(p_rec.revenue_class_id, null, fnd_api.g_miss_num, p_rec.revenue_class_id),
1814: DECODE(p_rec.load_status, null, fnd_api.g_miss_char, p_rec.load_status),
1815: DECODE(p_rec.attribute1,null, fnd_api.g_miss_char, p_rec.attribute1),
1816: DECODE(p_rec.attribute2,null, fnd_api.g_miss_char, p_rec.attribute2),
1817: DECODE(p_rec.attribute3,null, fnd_api.g_miss_char, p_rec.attribute3),

Line 1814: DECODE(p_rec.load_status, null, fnd_api.g_miss_char, p_rec.load_status),

1810: DECODE(p_rec.processed_period_id, null, fnd_api.g_miss_num, p_rec.processed_period_id),
1811: DECODE(p_rec.transaction_amount, null, fnd_api.g_miss_num, p_rec.transaction_amount),
1812: DECODE(p_rec.trx_type, null, fnd_api.g_miss_char,p_rec.trx_type),
1813: DECODE(p_rec.revenue_class_id, null, fnd_api.g_miss_num, p_rec.revenue_class_id),
1814: DECODE(p_rec.load_status, null, fnd_api.g_miss_char, p_rec.load_status),
1815: DECODE(p_rec.attribute1,null, fnd_api.g_miss_char, p_rec.attribute1),
1816: DECODE(p_rec.attribute2,null, fnd_api.g_miss_char, p_rec.attribute2),
1817: DECODE(p_rec.attribute3,null, fnd_api.g_miss_char, p_rec.attribute3),
1818: DECODE(p_rec.attribute4,null, fnd_api.g_miss_char, p_rec.attribute4),

Line 1815: DECODE(p_rec.attribute1,null, fnd_api.g_miss_char, p_rec.attribute1),

1811: DECODE(p_rec.transaction_amount, null, fnd_api.g_miss_num, p_rec.transaction_amount),
1812: DECODE(p_rec.trx_type, null, fnd_api.g_miss_char,p_rec.trx_type),
1813: DECODE(p_rec.revenue_class_id, null, fnd_api.g_miss_num, p_rec.revenue_class_id),
1814: DECODE(p_rec.load_status, null, fnd_api.g_miss_char, p_rec.load_status),
1815: DECODE(p_rec.attribute1,null, fnd_api.g_miss_char, p_rec.attribute1),
1816: DECODE(p_rec.attribute2,null, fnd_api.g_miss_char, p_rec.attribute2),
1817: DECODE(p_rec.attribute3,null, fnd_api.g_miss_char, p_rec.attribute3),
1818: DECODE(p_rec.attribute4,null, fnd_api.g_miss_char, p_rec.attribute4),
1819: DECODE(p_rec.attribute5,null, fnd_api.g_miss_char, p_rec.attribute5),

Line 1816: DECODE(p_rec.attribute2,null, fnd_api.g_miss_char, p_rec.attribute2),

1812: DECODE(p_rec.trx_type, null, fnd_api.g_miss_char,p_rec.trx_type),
1813: DECODE(p_rec.revenue_class_id, null, fnd_api.g_miss_num, p_rec.revenue_class_id),
1814: DECODE(p_rec.load_status, null, fnd_api.g_miss_char, p_rec.load_status),
1815: DECODE(p_rec.attribute1,null, fnd_api.g_miss_char, p_rec.attribute1),
1816: DECODE(p_rec.attribute2,null, fnd_api.g_miss_char, p_rec.attribute2),
1817: DECODE(p_rec.attribute3,null, fnd_api.g_miss_char, p_rec.attribute3),
1818: DECODE(p_rec.attribute4,null, fnd_api.g_miss_char, p_rec.attribute4),
1819: DECODE(p_rec.attribute5,null, fnd_api.g_miss_char, p_rec.attribute5),
1820: DECODE(p_rec.attribute6,null, fnd_api.g_miss_char, p_rec.attribute6),

Line 1817: DECODE(p_rec.attribute3,null, fnd_api.g_miss_char, p_rec.attribute3),

1813: DECODE(p_rec.revenue_class_id, null, fnd_api.g_miss_num, p_rec.revenue_class_id),
1814: DECODE(p_rec.load_status, null, fnd_api.g_miss_char, p_rec.load_status),
1815: DECODE(p_rec.attribute1,null, fnd_api.g_miss_char, p_rec.attribute1),
1816: DECODE(p_rec.attribute2,null, fnd_api.g_miss_char, p_rec.attribute2),
1817: DECODE(p_rec.attribute3,null, fnd_api.g_miss_char, p_rec.attribute3),
1818: DECODE(p_rec.attribute4,null, fnd_api.g_miss_char, p_rec.attribute4),
1819: DECODE(p_rec.attribute5,null, fnd_api.g_miss_char, p_rec.attribute5),
1820: DECODE(p_rec.attribute6,null, fnd_api.g_miss_char, p_rec.attribute6),
1821: DECODE(p_rec.attribute7,null, fnd_api.g_miss_char, p_rec.attribute7),

Line 1818: DECODE(p_rec.attribute4,null, fnd_api.g_miss_char, p_rec.attribute4),

1814: DECODE(p_rec.load_status, null, fnd_api.g_miss_char, p_rec.load_status),
1815: DECODE(p_rec.attribute1,null, fnd_api.g_miss_char, p_rec.attribute1),
1816: DECODE(p_rec.attribute2,null, fnd_api.g_miss_char, p_rec.attribute2),
1817: DECODE(p_rec.attribute3,null, fnd_api.g_miss_char, p_rec.attribute3),
1818: DECODE(p_rec.attribute4,null, fnd_api.g_miss_char, p_rec.attribute4),
1819: DECODE(p_rec.attribute5,null, fnd_api.g_miss_char, p_rec.attribute5),
1820: DECODE(p_rec.attribute6,null, fnd_api.g_miss_char, p_rec.attribute6),
1821: DECODE(p_rec.attribute7,null, fnd_api.g_miss_char, p_rec.attribute7),
1822: DECODE(p_rec.attribute8,null, fnd_api.g_miss_char, p_rec.attribute8),

Line 1819: DECODE(p_rec.attribute5,null, fnd_api.g_miss_char, p_rec.attribute5),

1815: DECODE(p_rec.attribute1,null, fnd_api.g_miss_char, p_rec.attribute1),
1816: DECODE(p_rec.attribute2,null, fnd_api.g_miss_char, p_rec.attribute2),
1817: DECODE(p_rec.attribute3,null, fnd_api.g_miss_char, p_rec.attribute3),
1818: DECODE(p_rec.attribute4,null, fnd_api.g_miss_char, p_rec.attribute4),
1819: DECODE(p_rec.attribute5,null, fnd_api.g_miss_char, p_rec.attribute5),
1820: DECODE(p_rec.attribute6,null, fnd_api.g_miss_char, p_rec.attribute6),
1821: DECODE(p_rec.attribute7,null, fnd_api.g_miss_char, p_rec.attribute7),
1822: DECODE(p_rec.attribute8,null, fnd_api.g_miss_char, p_rec.attribute8),
1823: DECODE(p_rec.attribute9,null, fnd_api.g_miss_char, p_rec.attribute9),

Line 1820: DECODE(p_rec.attribute6,null, fnd_api.g_miss_char, p_rec.attribute6),

1816: DECODE(p_rec.attribute2,null, fnd_api.g_miss_char, p_rec.attribute2),
1817: DECODE(p_rec.attribute3,null, fnd_api.g_miss_char, p_rec.attribute3),
1818: DECODE(p_rec.attribute4,null, fnd_api.g_miss_char, p_rec.attribute4),
1819: DECODE(p_rec.attribute5,null, fnd_api.g_miss_char, p_rec.attribute5),
1820: DECODE(p_rec.attribute6,null, fnd_api.g_miss_char, p_rec.attribute6),
1821: DECODE(p_rec.attribute7,null, fnd_api.g_miss_char, p_rec.attribute7),
1822: DECODE(p_rec.attribute8,null, fnd_api.g_miss_char, p_rec.attribute8),
1823: DECODE(p_rec.attribute9,null, fnd_api.g_miss_char, p_rec.attribute9),
1824: DECODE(p_rec.attribute10,null, fnd_api.g_miss_char, p_rec.attribute10),

Line 1821: DECODE(p_rec.attribute7,null, fnd_api.g_miss_char, p_rec.attribute7),

1817: DECODE(p_rec.attribute3,null, fnd_api.g_miss_char, p_rec.attribute3),
1818: DECODE(p_rec.attribute4,null, fnd_api.g_miss_char, p_rec.attribute4),
1819: DECODE(p_rec.attribute5,null, fnd_api.g_miss_char, p_rec.attribute5),
1820: DECODE(p_rec.attribute6,null, fnd_api.g_miss_char, p_rec.attribute6),
1821: DECODE(p_rec.attribute7,null, fnd_api.g_miss_char, p_rec.attribute7),
1822: DECODE(p_rec.attribute8,null, fnd_api.g_miss_char, p_rec.attribute8),
1823: DECODE(p_rec.attribute9,null, fnd_api.g_miss_char, p_rec.attribute9),
1824: DECODE(p_rec.attribute10,null, fnd_api.g_miss_char, p_rec.attribute10),
1825: DECODE(p_rec.attribute11,null, fnd_api.g_miss_char, p_rec.attribute11),

Line 1822: DECODE(p_rec.attribute8,null, fnd_api.g_miss_char, p_rec.attribute8),

1818: DECODE(p_rec.attribute4,null, fnd_api.g_miss_char, p_rec.attribute4),
1819: DECODE(p_rec.attribute5,null, fnd_api.g_miss_char, p_rec.attribute5),
1820: DECODE(p_rec.attribute6,null, fnd_api.g_miss_char, p_rec.attribute6),
1821: DECODE(p_rec.attribute7,null, fnd_api.g_miss_char, p_rec.attribute7),
1822: DECODE(p_rec.attribute8,null, fnd_api.g_miss_char, p_rec.attribute8),
1823: DECODE(p_rec.attribute9,null, fnd_api.g_miss_char, p_rec.attribute9),
1824: DECODE(p_rec.attribute10,null, fnd_api.g_miss_char, p_rec.attribute10),
1825: DECODE(p_rec.attribute11,null, fnd_api.g_miss_char, p_rec.attribute11),
1826: DECODE(p_rec.attribute12,null, fnd_api.g_miss_char, p_rec.attribute12),

Line 1823: DECODE(p_rec.attribute9,null, fnd_api.g_miss_char, p_rec.attribute9),

1819: DECODE(p_rec.attribute5,null, fnd_api.g_miss_char, p_rec.attribute5),
1820: DECODE(p_rec.attribute6,null, fnd_api.g_miss_char, p_rec.attribute6),
1821: DECODE(p_rec.attribute7,null, fnd_api.g_miss_char, p_rec.attribute7),
1822: DECODE(p_rec.attribute8,null, fnd_api.g_miss_char, p_rec.attribute8),
1823: DECODE(p_rec.attribute9,null, fnd_api.g_miss_char, p_rec.attribute9),
1824: DECODE(p_rec.attribute10,null, fnd_api.g_miss_char, p_rec.attribute10),
1825: DECODE(p_rec.attribute11,null, fnd_api.g_miss_char, p_rec.attribute11),
1826: DECODE(p_rec.attribute12,null, fnd_api.g_miss_char, p_rec.attribute12),
1827: DECODE(p_rec.attribute13,null, fnd_api.g_miss_char, p_rec.attribute13),

Line 1824: DECODE(p_rec.attribute10,null, fnd_api.g_miss_char, p_rec.attribute10),

1820: DECODE(p_rec.attribute6,null, fnd_api.g_miss_char, p_rec.attribute6),
1821: DECODE(p_rec.attribute7,null, fnd_api.g_miss_char, p_rec.attribute7),
1822: DECODE(p_rec.attribute8,null, fnd_api.g_miss_char, p_rec.attribute8),
1823: DECODE(p_rec.attribute9,null, fnd_api.g_miss_char, p_rec.attribute9),
1824: DECODE(p_rec.attribute10,null, fnd_api.g_miss_char, p_rec.attribute10),
1825: DECODE(p_rec.attribute11,null, fnd_api.g_miss_char, p_rec.attribute11),
1826: DECODE(p_rec.attribute12,null, fnd_api.g_miss_char, p_rec.attribute12),
1827: DECODE(p_rec.attribute13,null, fnd_api.g_miss_char, p_rec.attribute13),
1828: DECODE(p_rec.attribute14,null, fnd_api.g_miss_char, p_rec.attribute14),

Line 1825: DECODE(p_rec.attribute11,null, fnd_api.g_miss_char, p_rec.attribute11),

1821: DECODE(p_rec.attribute7,null, fnd_api.g_miss_char, p_rec.attribute7),
1822: DECODE(p_rec.attribute8,null, fnd_api.g_miss_char, p_rec.attribute8),
1823: DECODE(p_rec.attribute9,null, fnd_api.g_miss_char, p_rec.attribute9),
1824: DECODE(p_rec.attribute10,null, fnd_api.g_miss_char, p_rec.attribute10),
1825: DECODE(p_rec.attribute11,null, fnd_api.g_miss_char, p_rec.attribute11),
1826: DECODE(p_rec.attribute12,null, fnd_api.g_miss_char, p_rec.attribute12),
1827: DECODE(p_rec.attribute13,null, fnd_api.g_miss_char, p_rec.attribute13),
1828: DECODE(p_rec.attribute14,null, fnd_api.g_miss_char, p_rec.attribute14),
1829: DECODE(p_rec.attribute15,null, fnd_api.g_miss_char, p_rec.attribute15),

Line 1826: DECODE(p_rec.attribute12,null, fnd_api.g_miss_char, p_rec.attribute12),

1822: DECODE(p_rec.attribute8,null, fnd_api.g_miss_char, p_rec.attribute8),
1823: DECODE(p_rec.attribute9,null, fnd_api.g_miss_char, p_rec.attribute9),
1824: DECODE(p_rec.attribute10,null, fnd_api.g_miss_char, p_rec.attribute10),
1825: DECODE(p_rec.attribute11,null, fnd_api.g_miss_char, p_rec.attribute11),
1826: DECODE(p_rec.attribute12,null, fnd_api.g_miss_char, p_rec.attribute12),
1827: DECODE(p_rec.attribute13,null, fnd_api.g_miss_char, p_rec.attribute13),
1828: DECODE(p_rec.attribute14,null, fnd_api.g_miss_char, p_rec.attribute14),
1829: DECODE(p_rec.attribute15,null, fnd_api.g_miss_char, p_rec.attribute15),
1830: DECODE(p_rec.attribute16,null, fnd_api.g_miss_char, p_rec.attribute16),

Line 1827: DECODE(p_rec.attribute13,null, fnd_api.g_miss_char, p_rec.attribute13),

1823: DECODE(p_rec.attribute9,null, fnd_api.g_miss_char, p_rec.attribute9),
1824: DECODE(p_rec.attribute10,null, fnd_api.g_miss_char, p_rec.attribute10),
1825: DECODE(p_rec.attribute11,null, fnd_api.g_miss_char, p_rec.attribute11),
1826: DECODE(p_rec.attribute12,null, fnd_api.g_miss_char, p_rec.attribute12),
1827: DECODE(p_rec.attribute13,null, fnd_api.g_miss_char, p_rec.attribute13),
1828: DECODE(p_rec.attribute14,null, fnd_api.g_miss_char, p_rec.attribute14),
1829: DECODE(p_rec.attribute15,null, fnd_api.g_miss_char, p_rec.attribute15),
1830: DECODE(p_rec.attribute16,null, fnd_api.g_miss_char, p_rec.attribute16),
1831: DECODE(p_rec.attribute17,null, fnd_api.g_miss_char, p_rec.attribute17),

Line 1828: DECODE(p_rec.attribute14,null, fnd_api.g_miss_char, p_rec.attribute14),

1824: DECODE(p_rec.attribute10,null, fnd_api.g_miss_char, p_rec.attribute10),
1825: DECODE(p_rec.attribute11,null, fnd_api.g_miss_char, p_rec.attribute11),
1826: DECODE(p_rec.attribute12,null, fnd_api.g_miss_char, p_rec.attribute12),
1827: DECODE(p_rec.attribute13,null, fnd_api.g_miss_char, p_rec.attribute13),
1828: DECODE(p_rec.attribute14,null, fnd_api.g_miss_char, p_rec.attribute14),
1829: DECODE(p_rec.attribute15,null, fnd_api.g_miss_char, p_rec.attribute15),
1830: DECODE(p_rec.attribute16,null, fnd_api.g_miss_char, p_rec.attribute16),
1831: DECODE(p_rec.attribute17,null, fnd_api.g_miss_char, p_rec.attribute17),
1832: DECODE(p_rec.attribute18,null, fnd_api.g_miss_char, p_rec.attribute18),

Line 1829: DECODE(p_rec.attribute15,null, fnd_api.g_miss_char, p_rec.attribute15),

1825: DECODE(p_rec.attribute11,null, fnd_api.g_miss_char, p_rec.attribute11),
1826: DECODE(p_rec.attribute12,null, fnd_api.g_miss_char, p_rec.attribute12),
1827: DECODE(p_rec.attribute13,null, fnd_api.g_miss_char, p_rec.attribute13),
1828: DECODE(p_rec.attribute14,null, fnd_api.g_miss_char, p_rec.attribute14),
1829: DECODE(p_rec.attribute15,null, fnd_api.g_miss_char, p_rec.attribute15),
1830: DECODE(p_rec.attribute16,null, fnd_api.g_miss_char, p_rec.attribute16),
1831: DECODE(p_rec.attribute17,null, fnd_api.g_miss_char, p_rec.attribute17),
1832: DECODE(p_rec.attribute18,null, fnd_api.g_miss_char, p_rec.attribute18),
1833: DECODE(p_rec.attribute19,null, fnd_api.g_miss_char, p_rec.attribute19),

Line 1830: DECODE(p_rec.attribute16,null, fnd_api.g_miss_char, p_rec.attribute16),

1826: DECODE(p_rec.attribute12,null, fnd_api.g_miss_char, p_rec.attribute12),
1827: DECODE(p_rec.attribute13,null, fnd_api.g_miss_char, p_rec.attribute13),
1828: DECODE(p_rec.attribute14,null, fnd_api.g_miss_char, p_rec.attribute14),
1829: DECODE(p_rec.attribute15,null, fnd_api.g_miss_char, p_rec.attribute15),
1830: DECODE(p_rec.attribute16,null, fnd_api.g_miss_char, p_rec.attribute16),
1831: DECODE(p_rec.attribute17,null, fnd_api.g_miss_char, p_rec.attribute17),
1832: DECODE(p_rec.attribute18,null, fnd_api.g_miss_char, p_rec.attribute18),
1833: DECODE(p_rec.attribute19,null, fnd_api.g_miss_char, p_rec.attribute19),
1834: DECODE(p_rec.attribute20,null, fnd_api.g_miss_char, p_rec.attribute20),

Line 1831: DECODE(p_rec.attribute17,null, fnd_api.g_miss_char, p_rec.attribute17),

1827: DECODE(p_rec.attribute13,null, fnd_api.g_miss_char, p_rec.attribute13),
1828: DECODE(p_rec.attribute14,null, fnd_api.g_miss_char, p_rec.attribute14),
1829: DECODE(p_rec.attribute15,null, fnd_api.g_miss_char, p_rec.attribute15),
1830: DECODE(p_rec.attribute16,null, fnd_api.g_miss_char, p_rec.attribute16),
1831: DECODE(p_rec.attribute17,null, fnd_api.g_miss_char, p_rec.attribute17),
1832: DECODE(p_rec.attribute18,null, fnd_api.g_miss_char, p_rec.attribute18),
1833: DECODE(p_rec.attribute19,null, fnd_api.g_miss_char, p_rec.attribute19),
1834: DECODE(p_rec.attribute20,null, fnd_api.g_miss_char, p_rec.attribute20),
1835: DECODE(p_rec.attribute21,null, fnd_api.g_miss_char, p_rec.attribute21),

Line 1832: DECODE(p_rec.attribute18,null, fnd_api.g_miss_char, p_rec.attribute18),

1828: DECODE(p_rec.attribute14,null, fnd_api.g_miss_char, p_rec.attribute14),
1829: DECODE(p_rec.attribute15,null, fnd_api.g_miss_char, p_rec.attribute15),
1830: DECODE(p_rec.attribute16,null, fnd_api.g_miss_char, p_rec.attribute16),
1831: DECODE(p_rec.attribute17,null, fnd_api.g_miss_char, p_rec.attribute17),
1832: DECODE(p_rec.attribute18,null, fnd_api.g_miss_char, p_rec.attribute18),
1833: DECODE(p_rec.attribute19,null, fnd_api.g_miss_char, p_rec.attribute19),
1834: DECODE(p_rec.attribute20,null, fnd_api.g_miss_char, p_rec.attribute20),
1835: DECODE(p_rec.attribute21,null, fnd_api.g_miss_char, p_rec.attribute21),
1836: DECODE(p_rec.attribute22,null, fnd_api.g_miss_char, p_rec.attribute22),

Line 1833: DECODE(p_rec.attribute19,null, fnd_api.g_miss_char, p_rec.attribute19),

1829: DECODE(p_rec.attribute15,null, fnd_api.g_miss_char, p_rec.attribute15),
1830: DECODE(p_rec.attribute16,null, fnd_api.g_miss_char, p_rec.attribute16),
1831: DECODE(p_rec.attribute17,null, fnd_api.g_miss_char, p_rec.attribute17),
1832: DECODE(p_rec.attribute18,null, fnd_api.g_miss_char, p_rec.attribute18),
1833: DECODE(p_rec.attribute19,null, fnd_api.g_miss_char, p_rec.attribute19),
1834: DECODE(p_rec.attribute20,null, fnd_api.g_miss_char, p_rec.attribute20),
1835: DECODE(p_rec.attribute21,null, fnd_api.g_miss_char, p_rec.attribute21),
1836: DECODE(p_rec.attribute22,null, fnd_api.g_miss_char, p_rec.attribute22),
1837: DECODE(p_rec.attribute23,null, fnd_api.g_miss_char, p_rec.attribute23),

Line 1834: DECODE(p_rec.attribute20,null, fnd_api.g_miss_char, p_rec.attribute20),

1830: DECODE(p_rec.attribute16,null, fnd_api.g_miss_char, p_rec.attribute16),
1831: DECODE(p_rec.attribute17,null, fnd_api.g_miss_char, p_rec.attribute17),
1832: DECODE(p_rec.attribute18,null, fnd_api.g_miss_char, p_rec.attribute18),
1833: DECODE(p_rec.attribute19,null, fnd_api.g_miss_char, p_rec.attribute19),
1834: DECODE(p_rec.attribute20,null, fnd_api.g_miss_char, p_rec.attribute20),
1835: DECODE(p_rec.attribute21,null, fnd_api.g_miss_char, p_rec.attribute21),
1836: DECODE(p_rec.attribute22,null, fnd_api.g_miss_char, p_rec.attribute22),
1837: DECODE(p_rec.attribute23,null, fnd_api.g_miss_char, p_rec.attribute23),
1838: DECODE(p_rec.attribute24,null, fnd_api.g_miss_char, p_rec.attribute24),

Line 1835: DECODE(p_rec.attribute21,null, fnd_api.g_miss_char, p_rec.attribute21),

1831: DECODE(p_rec.attribute17,null, fnd_api.g_miss_char, p_rec.attribute17),
1832: DECODE(p_rec.attribute18,null, fnd_api.g_miss_char, p_rec.attribute18),
1833: DECODE(p_rec.attribute19,null, fnd_api.g_miss_char, p_rec.attribute19),
1834: DECODE(p_rec.attribute20,null, fnd_api.g_miss_char, p_rec.attribute20),
1835: DECODE(p_rec.attribute21,null, fnd_api.g_miss_char, p_rec.attribute21),
1836: DECODE(p_rec.attribute22,null, fnd_api.g_miss_char, p_rec.attribute22),
1837: DECODE(p_rec.attribute23,null, fnd_api.g_miss_char, p_rec.attribute23),
1838: DECODE(p_rec.attribute24,null, fnd_api.g_miss_char, p_rec.attribute24),
1839: DECODE(p_rec.attribute25,null, fnd_api.g_miss_char, p_rec.attribute25),

Line 1836: DECODE(p_rec.attribute22,null, fnd_api.g_miss_char, p_rec.attribute22),

1832: DECODE(p_rec.attribute18,null, fnd_api.g_miss_char, p_rec.attribute18),
1833: DECODE(p_rec.attribute19,null, fnd_api.g_miss_char, p_rec.attribute19),
1834: DECODE(p_rec.attribute20,null, fnd_api.g_miss_char, p_rec.attribute20),
1835: DECODE(p_rec.attribute21,null, fnd_api.g_miss_char, p_rec.attribute21),
1836: DECODE(p_rec.attribute22,null, fnd_api.g_miss_char, p_rec.attribute22),
1837: DECODE(p_rec.attribute23,null, fnd_api.g_miss_char, p_rec.attribute23),
1838: DECODE(p_rec.attribute24,null, fnd_api.g_miss_char, p_rec.attribute24),
1839: DECODE(p_rec.attribute25,null, fnd_api.g_miss_char, p_rec.attribute25),
1840: DECODE(p_rec.attribute26,null, fnd_api.g_miss_char, p_rec.attribute26),

Line 1837: DECODE(p_rec.attribute23,null, fnd_api.g_miss_char, p_rec.attribute23),

1833: DECODE(p_rec.attribute19,null, fnd_api.g_miss_char, p_rec.attribute19),
1834: DECODE(p_rec.attribute20,null, fnd_api.g_miss_char, p_rec.attribute20),
1835: DECODE(p_rec.attribute21,null, fnd_api.g_miss_char, p_rec.attribute21),
1836: DECODE(p_rec.attribute22,null, fnd_api.g_miss_char, p_rec.attribute22),
1837: DECODE(p_rec.attribute23,null, fnd_api.g_miss_char, p_rec.attribute23),
1838: DECODE(p_rec.attribute24,null, fnd_api.g_miss_char, p_rec.attribute24),
1839: DECODE(p_rec.attribute25,null, fnd_api.g_miss_char, p_rec.attribute25),
1840: DECODE(p_rec.attribute26,null, fnd_api.g_miss_char, p_rec.attribute26),
1841: DECODE(p_rec.attribute27,null, fnd_api.g_miss_char, p_rec.attribute27),

Line 1838: DECODE(p_rec.attribute24,null, fnd_api.g_miss_char, p_rec.attribute24),

1834: DECODE(p_rec.attribute20,null, fnd_api.g_miss_char, p_rec.attribute20),
1835: DECODE(p_rec.attribute21,null, fnd_api.g_miss_char, p_rec.attribute21),
1836: DECODE(p_rec.attribute22,null, fnd_api.g_miss_char, p_rec.attribute22),
1837: DECODE(p_rec.attribute23,null, fnd_api.g_miss_char, p_rec.attribute23),
1838: DECODE(p_rec.attribute24,null, fnd_api.g_miss_char, p_rec.attribute24),
1839: DECODE(p_rec.attribute25,null, fnd_api.g_miss_char, p_rec.attribute25),
1840: DECODE(p_rec.attribute26,null, fnd_api.g_miss_char, p_rec.attribute26),
1841: DECODE(p_rec.attribute27,null, fnd_api.g_miss_char, p_rec.attribute27),
1842: DECODE(p_rec.attribute28,null, fnd_api.g_miss_char, p_rec.attribute28),

Line 1839: DECODE(p_rec.attribute25,null, fnd_api.g_miss_char, p_rec.attribute25),

1835: DECODE(p_rec.attribute21,null, fnd_api.g_miss_char, p_rec.attribute21),
1836: DECODE(p_rec.attribute22,null, fnd_api.g_miss_char, p_rec.attribute22),
1837: DECODE(p_rec.attribute23,null, fnd_api.g_miss_char, p_rec.attribute23),
1838: DECODE(p_rec.attribute24,null, fnd_api.g_miss_char, p_rec.attribute24),
1839: DECODE(p_rec.attribute25,null, fnd_api.g_miss_char, p_rec.attribute25),
1840: DECODE(p_rec.attribute26,null, fnd_api.g_miss_char, p_rec.attribute26),
1841: DECODE(p_rec.attribute27,null, fnd_api.g_miss_char, p_rec.attribute27),
1842: DECODE(p_rec.attribute28,null, fnd_api.g_miss_char, p_rec.attribute28),
1843: DECODE(p_rec.attribute29,null, fnd_api.g_miss_char, p_rec.attribute29),

Line 1840: DECODE(p_rec.attribute26,null, fnd_api.g_miss_char, p_rec.attribute26),

1836: DECODE(p_rec.attribute22,null, fnd_api.g_miss_char, p_rec.attribute22),
1837: DECODE(p_rec.attribute23,null, fnd_api.g_miss_char, p_rec.attribute23),
1838: DECODE(p_rec.attribute24,null, fnd_api.g_miss_char, p_rec.attribute24),
1839: DECODE(p_rec.attribute25,null, fnd_api.g_miss_char, p_rec.attribute25),
1840: DECODE(p_rec.attribute26,null, fnd_api.g_miss_char, p_rec.attribute26),
1841: DECODE(p_rec.attribute27,null, fnd_api.g_miss_char, p_rec.attribute27),
1842: DECODE(p_rec.attribute28,null, fnd_api.g_miss_char, p_rec.attribute28),
1843: DECODE(p_rec.attribute29,null, fnd_api.g_miss_char, p_rec.attribute29),
1844: DECODE(p_rec.attribute30,null, fnd_api.g_miss_char, p_rec.attribute30),

Line 1841: DECODE(p_rec.attribute27,null, fnd_api.g_miss_char, p_rec.attribute27),

1837: DECODE(p_rec.attribute23,null, fnd_api.g_miss_char, p_rec.attribute23),
1838: DECODE(p_rec.attribute24,null, fnd_api.g_miss_char, p_rec.attribute24),
1839: DECODE(p_rec.attribute25,null, fnd_api.g_miss_char, p_rec.attribute25),
1840: DECODE(p_rec.attribute26,null, fnd_api.g_miss_char, p_rec.attribute26),
1841: DECODE(p_rec.attribute27,null, fnd_api.g_miss_char, p_rec.attribute27),
1842: DECODE(p_rec.attribute28,null, fnd_api.g_miss_char, p_rec.attribute28),
1843: DECODE(p_rec.attribute29,null, fnd_api.g_miss_char, p_rec.attribute29),
1844: DECODE(p_rec.attribute30,null, fnd_api.g_miss_char, p_rec.attribute30),
1845: DECODE(p_rec.attribute31,null, fnd_api.g_miss_char, p_rec.attribute31),

Line 1842: DECODE(p_rec.attribute28,null, fnd_api.g_miss_char, p_rec.attribute28),

1838: DECODE(p_rec.attribute24,null, fnd_api.g_miss_char, p_rec.attribute24),
1839: DECODE(p_rec.attribute25,null, fnd_api.g_miss_char, p_rec.attribute25),
1840: DECODE(p_rec.attribute26,null, fnd_api.g_miss_char, p_rec.attribute26),
1841: DECODE(p_rec.attribute27,null, fnd_api.g_miss_char, p_rec.attribute27),
1842: DECODE(p_rec.attribute28,null, fnd_api.g_miss_char, p_rec.attribute28),
1843: DECODE(p_rec.attribute29,null, fnd_api.g_miss_char, p_rec.attribute29),
1844: DECODE(p_rec.attribute30,null, fnd_api.g_miss_char, p_rec.attribute30),
1845: DECODE(p_rec.attribute31,null, fnd_api.g_miss_char, p_rec.attribute31),
1846: DECODE(p_rec.attribute32,null, fnd_api.g_miss_char, p_rec.attribute32),

Line 1843: DECODE(p_rec.attribute29,null, fnd_api.g_miss_char, p_rec.attribute29),

1839: DECODE(p_rec.attribute25,null, fnd_api.g_miss_char, p_rec.attribute25),
1840: DECODE(p_rec.attribute26,null, fnd_api.g_miss_char, p_rec.attribute26),
1841: DECODE(p_rec.attribute27,null, fnd_api.g_miss_char, p_rec.attribute27),
1842: DECODE(p_rec.attribute28,null, fnd_api.g_miss_char, p_rec.attribute28),
1843: DECODE(p_rec.attribute29,null, fnd_api.g_miss_char, p_rec.attribute29),
1844: DECODE(p_rec.attribute30,null, fnd_api.g_miss_char, p_rec.attribute30),
1845: DECODE(p_rec.attribute31,null, fnd_api.g_miss_char, p_rec.attribute31),
1846: DECODE(p_rec.attribute32,null, fnd_api.g_miss_char, p_rec.attribute32),
1847: DECODE(p_rec.attribute33,null, fnd_api.g_miss_char, p_rec.attribute33),

Line 1844: DECODE(p_rec.attribute30,null, fnd_api.g_miss_char, p_rec.attribute30),

1840: DECODE(p_rec.attribute26,null, fnd_api.g_miss_char, p_rec.attribute26),
1841: DECODE(p_rec.attribute27,null, fnd_api.g_miss_char, p_rec.attribute27),
1842: DECODE(p_rec.attribute28,null, fnd_api.g_miss_char, p_rec.attribute28),
1843: DECODE(p_rec.attribute29,null, fnd_api.g_miss_char, p_rec.attribute29),
1844: DECODE(p_rec.attribute30,null, fnd_api.g_miss_char, p_rec.attribute30),
1845: DECODE(p_rec.attribute31,null, fnd_api.g_miss_char, p_rec.attribute31),
1846: DECODE(p_rec.attribute32,null, fnd_api.g_miss_char, p_rec.attribute32),
1847: DECODE(p_rec.attribute33,null, fnd_api.g_miss_char, p_rec.attribute33),
1848: DECODE(p_rec.attribute34,null, fnd_api.g_miss_char, p_rec.attribute34),

Line 1845: DECODE(p_rec.attribute31,null, fnd_api.g_miss_char, p_rec.attribute31),

1841: DECODE(p_rec.attribute27,null, fnd_api.g_miss_char, p_rec.attribute27),
1842: DECODE(p_rec.attribute28,null, fnd_api.g_miss_char, p_rec.attribute28),
1843: DECODE(p_rec.attribute29,null, fnd_api.g_miss_char, p_rec.attribute29),
1844: DECODE(p_rec.attribute30,null, fnd_api.g_miss_char, p_rec.attribute30),
1845: DECODE(p_rec.attribute31,null, fnd_api.g_miss_char, p_rec.attribute31),
1846: DECODE(p_rec.attribute32,null, fnd_api.g_miss_char, p_rec.attribute32),
1847: DECODE(p_rec.attribute33,null, fnd_api.g_miss_char, p_rec.attribute33),
1848: DECODE(p_rec.attribute34,null, fnd_api.g_miss_char, p_rec.attribute34),
1849: DECODE(p_rec.attribute35,null, fnd_api.g_miss_char, p_rec.attribute35),

Line 1846: DECODE(p_rec.attribute32,null, fnd_api.g_miss_char, p_rec.attribute32),

1842: DECODE(p_rec.attribute28,null, fnd_api.g_miss_char, p_rec.attribute28),
1843: DECODE(p_rec.attribute29,null, fnd_api.g_miss_char, p_rec.attribute29),
1844: DECODE(p_rec.attribute30,null, fnd_api.g_miss_char, p_rec.attribute30),
1845: DECODE(p_rec.attribute31,null, fnd_api.g_miss_char, p_rec.attribute31),
1846: DECODE(p_rec.attribute32,null, fnd_api.g_miss_char, p_rec.attribute32),
1847: DECODE(p_rec.attribute33,null, fnd_api.g_miss_char, p_rec.attribute33),
1848: DECODE(p_rec.attribute34,null, fnd_api.g_miss_char, p_rec.attribute34),
1849: DECODE(p_rec.attribute35,null, fnd_api.g_miss_char, p_rec.attribute35),
1850: DECODE(p_rec.attribute36,null, fnd_api.g_miss_char, p_rec.attribute36),

Line 1847: DECODE(p_rec.attribute33,null, fnd_api.g_miss_char, p_rec.attribute33),

1843: DECODE(p_rec.attribute29,null, fnd_api.g_miss_char, p_rec.attribute29),
1844: DECODE(p_rec.attribute30,null, fnd_api.g_miss_char, p_rec.attribute30),
1845: DECODE(p_rec.attribute31,null, fnd_api.g_miss_char, p_rec.attribute31),
1846: DECODE(p_rec.attribute32,null, fnd_api.g_miss_char, p_rec.attribute32),
1847: DECODE(p_rec.attribute33,null, fnd_api.g_miss_char, p_rec.attribute33),
1848: DECODE(p_rec.attribute34,null, fnd_api.g_miss_char, p_rec.attribute34),
1849: DECODE(p_rec.attribute35,null, fnd_api.g_miss_char, p_rec.attribute35),
1850: DECODE(p_rec.attribute36,null, fnd_api.g_miss_char, p_rec.attribute36),
1851: DECODE(p_rec.attribute37,null, fnd_api.g_miss_char, p_rec.attribute37),

Line 1848: DECODE(p_rec.attribute34,null, fnd_api.g_miss_char, p_rec.attribute34),

1844: DECODE(p_rec.attribute30,null, fnd_api.g_miss_char, p_rec.attribute30),
1845: DECODE(p_rec.attribute31,null, fnd_api.g_miss_char, p_rec.attribute31),
1846: DECODE(p_rec.attribute32,null, fnd_api.g_miss_char, p_rec.attribute32),
1847: DECODE(p_rec.attribute33,null, fnd_api.g_miss_char, p_rec.attribute33),
1848: DECODE(p_rec.attribute34,null, fnd_api.g_miss_char, p_rec.attribute34),
1849: DECODE(p_rec.attribute35,null, fnd_api.g_miss_char, p_rec.attribute35),
1850: DECODE(p_rec.attribute36,null, fnd_api.g_miss_char, p_rec.attribute36),
1851: DECODE(p_rec.attribute37,null, fnd_api.g_miss_char, p_rec.attribute37),
1852: DECODE(p_rec.attribute38,null, fnd_api.g_miss_char, p_rec.attribute38),

Line 1849: DECODE(p_rec.attribute35,null, fnd_api.g_miss_char, p_rec.attribute35),

1845: DECODE(p_rec.attribute31,null, fnd_api.g_miss_char, p_rec.attribute31),
1846: DECODE(p_rec.attribute32,null, fnd_api.g_miss_char, p_rec.attribute32),
1847: DECODE(p_rec.attribute33,null, fnd_api.g_miss_char, p_rec.attribute33),
1848: DECODE(p_rec.attribute34,null, fnd_api.g_miss_char, p_rec.attribute34),
1849: DECODE(p_rec.attribute35,null, fnd_api.g_miss_char, p_rec.attribute35),
1850: DECODE(p_rec.attribute36,null, fnd_api.g_miss_char, p_rec.attribute36),
1851: DECODE(p_rec.attribute37,null, fnd_api.g_miss_char, p_rec.attribute37),
1852: DECODE(p_rec.attribute38,null, fnd_api.g_miss_char, p_rec.attribute38),
1853: DECODE(p_rec.attribute39,null, fnd_api.g_miss_char, p_rec.attribute39),

Line 1850: DECODE(p_rec.attribute36,null, fnd_api.g_miss_char, p_rec.attribute36),

1846: DECODE(p_rec.attribute32,null, fnd_api.g_miss_char, p_rec.attribute32),
1847: DECODE(p_rec.attribute33,null, fnd_api.g_miss_char, p_rec.attribute33),
1848: DECODE(p_rec.attribute34,null, fnd_api.g_miss_char, p_rec.attribute34),
1849: DECODE(p_rec.attribute35,null, fnd_api.g_miss_char, p_rec.attribute35),
1850: DECODE(p_rec.attribute36,null, fnd_api.g_miss_char, p_rec.attribute36),
1851: DECODE(p_rec.attribute37,null, fnd_api.g_miss_char, p_rec.attribute37),
1852: DECODE(p_rec.attribute38,null, fnd_api.g_miss_char, p_rec.attribute38),
1853: DECODE(p_rec.attribute39,null, fnd_api.g_miss_char, p_rec.attribute39),
1854: DECODE(p_rec.attribute40,null, fnd_api.g_miss_char, p_rec.attribute40),

Line 1851: DECODE(p_rec.attribute37,null, fnd_api.g_miss_char, p_rec.attribute37),

1847: DECODE(p_rec.attribute33,null, fnd_api.g_miss_char, p_rec.attribute33),
1848: DECODE(p_rec.attribute34,null, fnd_api.g_miss_char, p_rec.attribute34),
1849: DECODE(p_rec.attribute35,null, fnd_api.g_miss_char, p_rec.attribute35),
1850: DECODE(p_rec.attribute36,null, fnd_api.g_miss_char, p_rec.attribute36),
1851: DECODE(p_rec.attribute37,null, fnd_api.g_miss_char, p_rec.attribute37),
1852: DECODE(p_rec.attribute38,null, fnd_api.g_miss_char, p_rec.attribute38),
1853: DECODE(p_rec.attribute39,null, fnd_api.g_miss_char, p_rec.attribute39),
1854: DECODE(p_rec.attribute40,null, fnd_api.g_miss_char, p_rec.attribute40),
1855: DECODE(p_rec.attribute41,null, fnd_api.g_miss_char, p_rec.attribute41),

Line 1852: DECODE(p_rec.attribute38,null, fnd_api.g_miss_char, p_rec.attribute38),

1848: DECODE(p_rec.attribute34,null, fnd_api.g_miss_char, p_rec.attribute34),
1849: DECODE(p_rec.attribute35,null, fnd_api.g_miss_char, p_rec.attribute35),
1850: DECODE(p_rec.attribute36,null, fnd_api.g_miss_char, p_rec.attribute36),
1851: DECODE(p_rec.attribute37,null, fnd_api.g_miss_char, p_rec.attribute37),
1852: DECODE(p_rec.attribute38,null, fnd_api.g_miss_char, p_rec.attribute38),
1853: DECODE(p_rec.attribute39,null, fnd_api.g_miss_char, p_rec.attribute39),
1854: DECODE(p_rec.attribute40,null, fnd_api.g_miss_char, p_rec.attribute40),
1855: DECODE(p_rec.attribute41,null, fnd_api.g_miss_char, p_rec.attribute41),
1856: DECODE(p_rec.attribute42,null, fnd_api.g_miss_char, p_rec.attribute42),

Line 1853: DECODE(p_rec.attribute39,null, fnd_api.g_miss_char, p_rec.attribute39),

1849: DECODE(p_rec.attribute35,null, fnd_api.g_miss_char, p_rec.attribute35),
1850: DECODE(p_rec.attribute36,null, fnd_api.g_miss_char, p_rec.attribute36),
1851: DECODE(p_rec.attribute37,null, fnd_api.g_miss_char, p_rec.attribute37),
1852: DECODE(p_rec.attribute38,null, fnd_api.g_miss_char, p_rec.attribute38),
1853: DECODE(p_rec.attribute39,null, fnd_api.g_miss_char, p_rec.attribute39),
1854: DECODE(p_rec.attribute40,null, fnd_api.g_miss_char, p_rec.attribute40),
1855: DECODE(p_rec.attribute41,null, fnd_api.g_miss_char, p_rec.attribute41),
1856: DECODE(p_rec.attribute42,null, fnd_api.g_miss_char, p_rec.attribute42),
1857: DECODE(p_rec.attribute43,null, fnd_api.g_miss_char, p_rec.attribute43),

Line 1854: DECODE(p_rec.attribute40,null, fnd_api.g_miss_char, p_rec.attribute40),

1850: DECODE(p_rec.attribute36,null, fnd_api.g_miss_char, p_rec.attribute36),
1851: DECODE(p_rec.attribute37,null, fnd_api.g_miss_char, p_rec.attribute37),
1852: DECODE(p_rec.attribute38,null, fnd_api.g_miss_char, p_rec.attribute38),
1853: DECODE(p_rec.attribute39,null, fnd_api.g_miss_char, p_rec.attribute39),
1854: DECODE(p_rec.attribute40,null, fnd_api.g_miss_char, p_rec.attribute40),
1855: DECODE(p_rec.attribute41,null, fnd_api.g_miss_char, p_rec.attribute41),
1856: DECODE(p_rec.attribute42,null, fnd_api.g_miss_char, p_rec.attribute42),
1857: DECODE(p_rec.attribute43,null, fnd_api.g_miss_char, p_rec.attribute43),
1858: DECODE(p_rec.attribute44,null, fnd_api.g_miss_char, p_rec.attribute44),

Line 1855: DECODE(p_rec.attribute41,null, fnd_api.g_miss_char, p_rec.attribute41),

1851: DECODE(p_rec.attribute37,null, fnd_api.g_miss_char, p_rec.attribute37),
1852: DECODE(p_rec.attribute38,null, fnd_api.g_miss_char, p_rec.attribute38),
1853: DECODE(p_rec.attribute39,null, fnd_api.g_miss_char, p_rec.attribute39),
1854: DECODE(p_rec.attribute40,null, fnd_api.g_miss_char, p_rec.attribute40),
1855: DECODE(p_rec.attribute41,null, fnd_api.g_miss_char, p_rec.attribute41),
1856: DECODE(p_rec.attribute42,null, fnd_api.g_miss_char, p_rec.attribute42),
1857: DECODE(p_rec.attribute43,null, fnd_api.g_miss_char, p_rec.attribute43),
1858: DECODE(p_rec.attribute44,null, fnd_api.g_miss_char, p_rec.attribute44),
1859: DECODE(p_rec.attribute45,null, fnd_api.g_miss_char, p_rec.attribute45),

Line 1856: DECODE(p_rec.attribute42,null, fnd_api.g_miss_char, p_rec.attribute42),

1852: DECODE(p_rec.attribute38,null, fnd_api.g_miss_char, p_rec.attribute38),
1853: DECODE(p_rec.attribute39,null, fnd_api.g_miss_char, p_rec.attribute39),
1854: DECODE(p_rec.attribute40,null, fnd_api.g_miss_char, p_rec.attribute40),
1855: DECODE(p_rec.attribute41,null, fnd_api.g_miss_char, p_rec.attribute41),
1856: DECODE(p_rec.attribute42,null, fnd_api.g_miss_char, p_rec.attribute42),
1857: DECODE(p_rec.attribute43,null, fnd_api.g_miss_char, p_rec.attribute43),
1858: DECODE(p_rec.attribute44,null, fnd_api.g_miss_char, p_rec.attribute44),
1859: DECODE(p_rec.attribute45,null, fnd_api.g_miss_char, p_rec.attribute45),
1860: DECODE(p_rec.attribute46,null, fnd_api.g_miss_char, p_rec.attribute46),

Line 1857: DECODE(p_rec.attribute43,null, fnd_api.g_miss_char, p_rec.attribute43),

1853: DECODE(p_rec.attribute39,null, fnd_api.g_miss_char, p_rec.attribute39),
1854: DECODE(p_rec.attribute40,null, fnd_api.g_miss_char, p_rec.attribute40),
1855: DECODE(p_rec.attribute41,null, fnd_api.g_miss_char, p_rec.attribute41),
1856: DECODE(p_rec.attribute42,null, fnd_api.g_miss_char, p_rec.attribute42),
1857: DECODE(p_rec.attribute43,null, fnd_api.g_miss_char, p_rec.attribute43),
1858: DECODE(p_rec.attribute44,null, fnd_api.g_miss_char, p_rec.attribute44),
1859: DECODE(p_rec.attribute45,null, fnd_api.g_miss_char, p_rec.attribute45),
1860: DECODE(p_rec.attribute46,null, fnd_api.g_miss_char, p_rec.attribute46),
1861: DECODE(p_rec.attribute47,null, fnd_api.g_miss_char, p_rec.attribute47),

Line 1858: DECODE(p_rec.attribute44,null, fnd_api.g_miss_char, p_rec.attribute44),

1854: DECODE(p_rec.attribute40,null, fnd_api.g_miss_char, p_rec.attribute40),
1855: DECODE(p_rec.attribute41,null, fnd_api.g_miss_char, p_rec.attribute41),
1856: DECODE(p_rec.attribute42,null, fnd_api.g_miss_char, p_rec.attribute42),
1857: DECODE(p_rec.attribute43,null, fnd_api.g_miss_char, p_rec.attribute43),
1858: DECODE(p_rec.attribute44,null, fnd_api.g_miss_char, p_rec.attribute44),
1859: DECODE(p_rec.attribute45,null, fnd_api.g_miss_char, p_rec.attribute45),
1860: DECODE(p_rec.attribute46,null, fnd_api.g_miss_char, p_rec.attribute46),
1861: DECODE(p_rec.attribute47,null, fnd_api.g_miss_char, p_rec.attribute47),
1862: DECODE(p_rec.attribute48,null, fnd_api.g_miss_char, p_rec.attribute48),

Line 1859: DECODE(p_rec.attribute45,null, fnd_api.g_miss_char, p_rec.attribute45),

1855: DECODE(p_rec.attribute41,null, fnd_api.g_miss_char, p_rec.attribute41),
1856: DECODE(p_rec.attribute42,null, fnd_api.g_miss_char, p_rec.attribute42),
1857: DECODE(p_rec.attribute43,null, fnd_api.g_miss_char, p_rec.attribute43),
1858: DECODE(p_rec.attribute44,null, fnd_api.g_miss_char, p_rec.attribute44),
1859: DECODE(p_rec.attribute45,null, fnd_api.g_miss_char, p_rec.attribute45),
1860: DECODE(p_rec.attribute46,null, fnd_api.g_miss_char, p_rec.attribute46),
1861: DECODE(p_rec.attribute47,null, fnd_api.g_miss_char, p_rec.attribute47),
1862: DECODE(p_rec.attribute48,null, fnd_api.g_miss_char, p_rec.attribute48),
1863: DECODE(p_rec.attribute49,null, fnd_api.g_miss_char, p_rec.attribute49),

Line 1860: DECODE(p_rec.attribute46,null, fnd_api.g_miss_char, p_rec.attribute46),

1856: DECODE(p_rec.attribute42,null, fnd_api.g_miss_char, p_rec.attribute42),
1857: DECODE(p_rec.attribute43,null, fnd_api.g_miss_char, p_rec.attribute43),
1858: DECODE(p_rec.attribute44,null, fnd_api.g_miss_char, p_rec.attribute44),
1859: DECODE(p_rec.attribute45,null, fnd_api.g_miss_char, p_rec.attribute45),
1860: DECODE(p_rec.attribute46,null, fnd_api.g_miss_char, p_rec.attribute46),
1861: DECODE(p_rec.attribute47,null, fnd_api.g_miss_char, p_rec.attribute47),
1862: DECODE(p_rec.attribute48,null, fnd_api.g_miss_char, p_rec.attribute48),
1863: DECODE(p_rec.attribute49,null, fnd_api.g_miss_char, p_rec.attribute49),
1864: DECODE(p_rec.attribute50,null, fnd_api.g_miss_char, p_rec.attribute50),

Line 1861: DECODE(p_rec.attribute47,null, fnd_api.g_miss_char, p_rec.attribute47),

1857: DECODE(p_rec.attribute43,null, fnd_api.g_miss_char, p_rec.attribute43),
1858: DECODE(p_rec.attribute44,null, fnd_api.g_miss_char, p_rec.attribute44),
1859: DECODE(p_rec.attribute45,null, fnd_api.g_miss_char, p_rec.attribute45),
1860: DECODE(p_rec.attribute46,null, fnd_api.g_miss_char, p_rec.attribute46),
1861: DECODE(p_rec.attribute47,null, fnd_api.g_miss_char, p_rec.attribute47),
1862: DECODE(p_rec.attribute48,null, fnd_api.g_miss_char, p_rec.attribute48),
1863: DECODE(p_rec.attribute49,null, fnd_api.g_miss_char, p_rec.attribute49),
1864: DECODE(p_rec.attribute50,null, fnd_api.g_miss_char, p_rec.attribute50),
1865: DECODE(p_rec.attribute51,null, fnd_api.g_miss_char, p_rec.attribute51),

Line 1862: DECODE(p_rec.attribute48,null, fnd_api.g_miss_char, p_rec.attribute48),

1858: DECODE(p_rec.attribute44,null, fnd_api.g_miss_char, p_rec.attribute44),
1859: DECODE(p_rec.attribute45,null, fnd_api.g_miss_char, p_rec.attribute45),
1860: DECODE(p_rec.attribute46,null, fnd_api.g_miss_char, p_rec.attribute46),
1861: DECODE(p_rec.attribute47,null, fnd_api.g_miss_char, p_rec.attribute47),
1862: DECODE(p_rec.attribute48,null, fnd_api.g_miss_char, p_rec.attribute48),
1863: DECODE(p_rec.attribute49,null, fnd_api.g_miss_char, p_rec.attribute49),
1864: DECODE(p_rec.attribute50,null, fnd_api.g_miss_char, p_rec.attribute50),
1865: DECODE(p_rec.attribute51,null, fnd_api.g_miss_char, p_rec.attribute51),
1866: DECODE(p_rec.attribute52,null, fnd_api.g_miss_char, p_rec.attribute52),

Line 1863: DECODE(p_rec.attribute49,null, fnd_api.g_miss_char, p_rec.attribute49),

1859: DECODE(p_rec.attribute45,null, fnd_api.g_miss_char, p_rec.attribute45),
1860: DECODE(p_rec.attribute46,null, fnd_api.g_miss_char, p_rec.attribute46),
1861: DECODE(p_rec.attribute47,null, fnd_api.g_miss_char, p_rec.attribute47),
1862: DECODE(p_rec.attribute48,null, fnd_api.g_miss_char, p_rec.attribute48),
1863: DECODE(p_rec.attribute49,null, fnd_api.g_miss_char, p_rec.attribute49),
1864: DECODE(p_rec.attribute50,null, fnd_api.g_miss_char, p_rec.attribute50),
1865: DECODE(p_rec.attribute51,null, fnd_api.g_miss_char, p_rec.attribute51),
1866: DECODE(p_rec.attribute52,null, fnd_api.g_miss_char, p_rec.attribute52),
1867: DECODE(p_rec.attribute53,null, fnd_api.g_miss_char, p_rec.attribute53),

Line 1864: DECODE(p_rec.attribute50,null, fnd_api.g_miss_char, p_rec.attribute50),

1860: DECODE(p_rec.attribute46,null, fnd_api.g_miss_char, p_rec.attribute46),
1861: DECODE(p_rec.attribute47,null, fnd_api.g_miss_char, p_rec.attribute47),
1862: DECODE(p_rec.attribute48,null, fnd_api.g_miss_char, p_rec.attribute48),
1863: DECODE(p_rec.attribute49,null, fnd_api.g_miss_char, p_rec.attribute49),
1864: DECODE(p_rec.attribute50,null, fnd_api.g_miss_char, p_rec.attribute50),
1865: DECODE(p_rec.attribute51,null, fnd_api.g_miss_char, p_rec.attribute51),
1866: DECODE(p_rec.attribute52,null, fnd_api.g_miss_char, p_rec.attribute52),
1867: DECODE(p_rec.attribute53,null, fnd_api.g_miss_char, p_rec.attribute53),
1868: DECODE(p_rec.attribute54,null, fnd_api.g_miss_char, p_rec.attribute54),

Line 1865: DECODE(p_rec.attribute51,null, fnd_api.g_miss_char, p_rec.attribute51),

1861: DECODE(p_rec.attribute47,null, fnd_api.g_miss_char, p_rec.attribute47),
1862: DECODE(p_rec.attribute48,null, fnd_api.g_miss_char, p_rec.attribute48),
1863: DECODE(p_rec.attribute49,null, fnd_api.g_miss_char, p_rec.attribute49),
1864: DECODE(p_rec.attribute50,null, fnd_api.g_miss_char, p_rec.attribute50),
1865: DECODE(p_rec.attribute51,null, fnd_api.g_miss_char, p_rec.attribute51),
1866: DECODE(p_rec.attribute52,null, fnd_api.g_miss_char, p_rec.attribute52),
1867: DECODE(p_rec.attribute53,null, fnd_api.g_miss_char, p_rec.attribute53),
1868: DECODE(p_rec.attribute54,null, fnd_api.g_miss_char, p_rec.attribute54),
1869: DECODE(p_rec.attribute55,null, fnd_api.g_miss_char, p_rec.attribute55),

Line 1866: DECODE(p_rec.attribute52,null, fnd_api.g_miss_char, p_rec.attribute52),

1862: DECODE(p_rec.attribute48,null, fnd_api.g_miss_char, p_rec.attribute48),
1863: DECODE(p_rec.attribute49,null, fnd_api.g_miss_char, p_rec.attribute49),
1864: DECODE(p_rec.attribute50,null, fnd_api.g_miss_char, p_rec.attribute50),
1865: DECODE(p_rec.attribute51,null, fnd_api.g_miss_char, p_rec.attribute51),
1866: DECODE(p_rec.attribute52,null, fnd_api.g_miss_char, p_rec.attribute52),
1867: DECODE(p_rec.attribute53,null, fnd_api.g_miss_char, p_rec.attribute53),
1868: DECODE(p_rec.attribute54,null, fnd_api.g_miss_char, p_rec.attribute54),
1869: DECODE(p_rec.attribute55,null, fnd_api.g_miss_char, p_rec.attribute55),
1870: DECODE(p_rec.attribute56,null, fnd_api.g_miss_char, p_rec.attribute56),

Line 1867: DECODE(p_rec.attribute53,null, fnd_api.g_miss_char, p_rec.attribute53),

1863: DECODE(p_rec.attribute49,null, fnd_api.g_miss_char, p_rec.attribute49),
1864: DECODE(p_rec.attribute50,null, fnd_api.g_miss_char, p_rec.attribute50),
1865: DECODE(p_rec.attribute51,null, fnd_api.g_miss_char, p_rec.attribute51),
1866: DECODE(p_rec.attribute52,null, fnd_api.g_miss_char, p_rec.attribute52),
1867: DECODE(p_rec.attribute53,null, fnd_api.g_miss_char, p_rec.attribute53),
1868: DECODE(p_rec.attribute54,null, fnd_api.g_miss_char, p_rec.attribute54),
1869: DECODE(p_rec.attribute55,null, fnd_api.g_miss_char, p_rec.attribute55),
1870: DECODE(p_rec.attribute56,null, fnd_api.g_miss_char, p_rec.attribute56),
1871: DECODE(p_rec.attribute57,null, fnd_api.g_miss_char, p_rec.attribute57),

Line 1868: DECODE(p_rec.attribute54,null, fnd_api.g_miss_char, p_rec.attribute54),

1864: DECODE(p_rec.attribute50,null, fnd_api.g_miss_char, p_rec.attribute50),
1865: DECODE(p_rec.attribute51,null, fnd_api.g_miss_char, p_rec.attribute51),
1866: DECODE(p_rec.attribute52,null, fnd_api.g_miss_char, p_rec.attribute52),
1867: DECODE(p_rec.attribute53,null, fnd_api.g_miss_char, p_rec.attribute53),
1868: DECODE(p_rec.attribute54,null, fnd_api.g_miss_char, p_rec.attribute54),
1869: DECODE(p_rec.attribute55,null, fnd_api.g_miss_char, p_rec.attribute55),
1870: DECODE(p_rec.attribute56,null, fnd_api.g_miss_char, p_rec.attribute56),
1871: DECODE(p_rec.attribute57,null, fnd_api.g_miss_char, p_rec.attribute57),
1872: DECODE(p_rec.attribute58,null, fnd_api.g_miss_char, p_rec.attribute58),

Line 1869: DECODE(p_rec.attribute55,null, fnd_api.g_miss_char, p_rec.attribute55),

1865: DECODE(p_rec.attribute51,null, fnd_api.g_miss_char, p_rec.attribute51),
1866: DECODE(p_rec.attribute52,null, fnd_api.g_miss_char, p_rec.attribute52),
1867: DECODE(p_rec.attribute53,null, fnd_api.g_miss_char, p_rec.attribute53),
1868: DECODE(p_rec.attribute54,null, fnd_api.g_miss_char, p_rec.attribute54),
1869: DECODE(p_rec.attribute55,null, fnd_api.g_miss_char, p_rec.attribute55),
1870: DECODE(p_rec.attribute56,null, fnd_api.g_miss_char, p_rec.attribute56),
1871: DECODE(p_rec.attribute57,null, fnd_api.g_miss_char, p_rec.attribute57),
1872: DECODE(p_rec.attribute58,null, fnd_api.g_miss_char, p_rec.attribute58),
1873: DECODE(p_rec.attribute59,null, fnd_api.g_miss_char, p_rec.attribute59),

Line 1870: DECODE(p_rec.attribute56,null, fnd_api.g_miss_char, p_rec.attribute56),

1866: DECODE(p_rec.attribute52,null, fnd_api.g_miss_char, p_rec.attribute52),
1867: DECODE(p_rec.attribute53,null, fnd_api.g_miss_char, p_rec.attribute53),
1868: DECODE(p_rec.attribute54,null, fnd_api.g_miss_char, p_rec.attribute54),
1869: DECODE(p_rec.attribute55,null, fnd_api.g_miss_char, p_rec.attribute55),
1870: DECODE(p_rec.attribute56,null, fnd_api.g_miss_char, p_rec.attribute56),
1871: DECODE(p_rec.attribute57,null, fnd_api.g_miss_char, p_rec.attribute57),
1872: DECODE(p_rec.attribute58,null, fnd_api.g_miss_char, p_rec.attribute58),
1873: DECODE(p_rec.attribute59,null, fnd_api.g_miss_char, p_rec.attribute59),
1874: DECODE(p_rec.attribute60,null, fnd_api.g_miss_char, p_rec.attribute60),

Line 1871: DECODE(p_rec.attribute57,null, fnd_api.g_miss_char, p_rec.attribute57),

1867: DECODE(p_rec.attribute53,null, fnd_api.g_miss_char, p_rec.attribute53),
1868: DECODE(p_rec.attribute54,null, fnd_api.g_miss_char, p_rec.attribute54),
1869: DECODE(p_rec.attribute55,null, fnd_api.g_miss_char, p_rec.attribute55),
1870: DECODE(p_rec.attribute56,null, fnd_api.g_miss_char, p_rec.attribute56),
1871: DECODE(p_rec.attribute57,null, fnd_api.g_miss_char, p_rec.attribute57),
1872: DECODE(p_rec.attribute58,null, fnd_api.g_miss_char, p_rec.attribute58),
1873: DECODE(p_rec.attribute59,null, fnd_api.g_miss_char, p_rec.attribute59),
1874: DECODE(p_rec.attribute60,null, fnd_api.g_miss_char, p_rec.attribute60),
1875: DECODE(p_rec.attribute61,null, fnd_api.g_miss_char, p_rec.attribute61),

Line 1872: DECODE(p_rec.attribute58,null, fnd_api.g_miss_char, p_rec.attribute58),

1868: DECODE(p_rec.attribute54,null, fnd_api.g_miss_char, p_rec.attribute54),
1869: DECODE(p_rec.attribute55,null, fnd_api.g_miss_char, p_rec.attribute55),
1870: DECODE(p_rec.attribute56,null, fnd_api.g_miss_char, p_rec.attribute56),
1871: DECODE(p_rec.attribute57,null, fnd_api.g_miss_char, p_rec.attribute57),
1872: DECODE(p_rec.attribute58,null, fnd_api.g_miss_char, p_rec.attribute58),
1873: DECODE(p_rec.attribute59,null, fnd_api.g_miss_char, p_rec.attribute59),
1874: DECODE(p_rec.attribute60,null, fnd_api.g_miss_char, p_rec.attribute60),
1875: DECODE(p_rec.attribute61,null, fnd_api.g_miss_char, p_rec.attribute61),
1876: DECODE(p_rec.attribute62,null, fnd_api.g_miss_char, p_rec.attribute62),

Line 1873: DECODE(p_rec.attribute59,null, fnd_api.g_miss_char, p_rec.attribute59),

1869: DECODE(p_rec.attribute55,null, fnd_api.g_miss_char, p_rec.attribute55),
1870: DECODE(p_rec.attribute56,null, fnd_api.g_miss_char, p_rec.attribute56),
1871: DECODE(p_rec.attribute57,null, fnd_api.g_miss_char, p_rec.attribute57),
1872: DECODE(p_rec.attribute58,null, fnd_api.g_miss_char, p_rec.attribute58),
1873: DECODE(p_rec.attribute59,null, fnd_api.g_miss_char, p_rec.attribute59),
1874: DECODE(p_rec.attribute60,null, fnd_api.g_miss_char, p_rec.attribute60),
1875: DECODE(p_rec.attribute61,null, fnd_api.g_miss_char, p_rec.attribute61),
1876: DECODE(p_rec.attribute62,null, fnd_api.g_miss_char, p_rec.attribute62),
1877: DECODE(p_rec.attribute63,null, fnd_api.g_miss_char, p_rec.attribute63),

Line 1874: DECODE(p_rec.attribute60,null, fnd_api.g_miss_char, p_rec.attribute60),

1870: DECODE(p_rec.attribute56,null, fnd_api.g_miss_char, p_rec.attribute56),
1871: DECODE(p_rec.attribute57,null, fnd_api.g_miss_char, p_rec.attribute57),
1872: DECODE(p_rec.attribute58,null, fnd_api.g_miss_char, p_rec.attribute58),
1873: DECODE(p_rec.attribute59,null, fnd_api.g_miss_char, p_rec.attribute59),
1874: DECODE(p_rec.attribute60,null, fnd_api.g_miss_char, p_rec.attribute60),
1875: DECODE(p_rec.attribute61,null, fnd_api.g_miss_char, p_rec.attribute61),
1876: DECODE(p_rec.attribute62,null, fnd_api.g_miss_char, p_rec.attribute62),
1877: DECODE(p_rec.attribute63,null, fnd_api.g_miss_char, p_rec.attribute63),
1878: DECODE(p_rec.attribute64,null, fnd_api.g_miss_char, p_rec.attribute64),

Line 1875: DECODE(p_rec.attribute61,null, fnd_api.g_miss_char, p_rec.attribute61),

1871: DECODE(p_rec.attribute57,null, fnd_api.g_miss_char, p_rec.attribute57),
1872: DECODE(p_rec.attribute58,null, fnd_api.g_miss_char, p_rec.attribute58),
1873: DECODE(p_rec.attribute59,null, fnd_api.g_miss_char, p_rec.attribute59),
1874: DECODE(p_rec.attribute60,null, fnd_api.g_miss_char, p_rec.attribute60),
1875: DECODE(p_rec.attribute61,null, fnd_api.g_miss_char, p_rec.attribute61),
1876: DECODE(p_rec.attribute62,null, fnd_api.g_miss_char, p_rec.attribute62),
1877: DECODE(p_rec.attribute63,null, fnd_api.g_miss_char, p_rec.attribute63),
1878: DECODE(p_rec.attribute64,null, fnd_api.g_miss_char, p_rec.attribute64),
1879: DECODE(p_rec.attribute65,null, fnd_api.g_miss_char, p_rec.attribute65),

Line 1876: DECODE(p_rec.attribute62,null, fnd_api.g_miss_char, p_rec.attribute62),

1872: DECODE(p_rec.attribute58,null, fnd_api.g_miss_char, p_rec.attribute58),
1873: DECODE(p_rec.attribute59,null, fnd_api.g_miss_char, p_rec.attribute59),
1874: DECODE(p_rec.attribute60,null, fnd_api.g_miss_char, p_rec.attribute60),
1875: DECODE(p_rec.attribute61,null, fnd_api.g_miss_char, p_rec.attribute61),
1876: DECODE(p_rec.attribute62,null, fnd_api.g_miss_char, p_rec.attribute62),
1877: DECODE(p_rec.attribute63,null, fnd_api.g_miss_char, p_rec.attribute63),
1878: DECODE(p_rec.attribute64,null, fnd_api.g_miss_char, p_rec.attribute64),
1879: DECODE(p_rec.attribute65,null, fnd_api.g_miss_char, p_rec.attribute65),
1880: DECODE(p_rec.attribute66,null, fnd_api.g_miss_char, p_rec.attribute66),

Line 1877: DECODE(p_rec.attribute63,null, fnd_api.g_miss_char, p_rec.attribute63),

1873: DECODE(p_rec.attribute59,null, fnd_api.g_miss_char, p_rec.attribute59),
1874: DECODE(p_rec.attribute60,null, fnd_api.g_miss_char, p_rec.attribute60),
1875: DECODE(p_rec.attribute61,null, fnd_api.g_miss_char, p_rec.attribute61),
1876: DECODE(p_rec.attribute62,null, fnd_api.g_miss_char, p_rec.attribute62),
1877: DECODE(p_rec.attribute63,null, fnd_api.g_miss_char, p_rec.attribute63),
1878: DECODE(p_rec.attribute64,null, fnd_api.g_miss_char, p_rec.attribute64),
1879: DECODE(p_rec.attribute65,null, fnd_api.g_miss_char, p_rec.attribute65),
1880: DECODE(p_rec.attribute66,null, fnd_api.g_miss_char, p_rec.attribute66),
1881: DECODE(p_rec.attribute67,null, fnd_api.g_miss_char, p_rec.attribute67),

Line 1878: DECODE(p_rec.attribute64,null, fnd_api.g_miss_char, p_rec.attribute64),

1874: DECODE(p_rec.attribute60,null, fnd_api.g_miss_char, p_rec.attribute60),
1875: DECODE(p_rec.attribute61,null, fnd_api.g_miss_char, p_rec.attribute61),
1876: DECODE(p_rec.attribute62,null, fnd_api.g_miss_char, p_rec.attribute62),
1877: DECODE(p_rec.attribute63,null, fnd_api.g_miss_char, p_rec.attribute63),
1878: DECODE(p_rec.attribute64,null, fnd_api.g_miss_char, p_rec.attribute64),
1879: DECODE(p_rec.attribute65,null, fnd_api.g_miss_char, p_rec.attribute65),
1880: DECODE(p_rec.attribute66,null, fnd_api.g_miss_char, p_rec.attribute66),
1881: DECODE(p_rec.attribute67,null, fnd_api.g_miss_char, p_rec.attribute67),
1882: DECODE(p_rec.attribute68,null, fnd_api.g_miss_char, p_rec.attribute68),

Line 1879: DECODE(p_rec.attribute65,null, fnd_api.g_miss_char, p_rec.attribute65),

1875: DECODE(p_rec.attribute61,null, fnd_api.g_miss_char, p_rec.attribute61),
1876: DECODE(p_rec.attribute62,null, fnd_api.g_miss_char, p_rec.attribute62),
1877: DECODE(p_rec.attribute63,null, fnd_api.g_miss_char, p_rec.attribute63),
1878: DECODE(p_rec.attribute64,null, fnd_api.g_miss_char, p_rec.attribute64),
1879: DECODE(p_rec.attribute65,null, fnd_api.g_miss_char, p_rec.attribute65),
1880: DECODE(p_rec.attribute66,null, fnd_api.g_miss_char, p_rec.attribute66),
1881: DECODE(p_rec.attribute67,null, fnd_api.g_miss_char, p_rec.attribute67),
1882: DECODE(p_rec.attribute68,null, fnd_api.g_miss_char, p_rec.attribute68),
1883: DECODE(p_rec.attribute69,null, fnd_api.g_miss_char, p_rec.attribute69),

Line 1880: DECODE(p_rec.attribute66,null, fnd_api.g_miss_char, p_rec.attribute66),

1876: DECODE(p_rec.attribute62,null, fnd_api.g_miss_char, p_rec.attribute62),
1877: DECODE(p_rec.attribute63,null, fnd_api.g_miss_char, p_rec.attribute63),
1878: DECODE(p_rec.attribute64,null, fnd_api.g_miss_char, p_rec.attribute64),
1879: DECODE(p_rec.attribute65,null, fnd_api.g_miss_char, p_rec.attribute65),
1880: DECODE(p_rec.attribute66,null, fnd_api.g_miss_char, p_rec.attribute66),
1881: DECODE(p_rec.attribute67,null, fnd_api.g_miss_char, p_rec.attribute67),
1882: DECODE(p_rec.attribute68,null, fnd_api.g_miss_char, p_rec.attribute68),
1883: DECODE(p_rec.attribute69,null, fnd_api.g_miss_char, p_rec.attribute69),
1884: DECODE(p_rec.attribute70,null, fnd_api.g_miss_char, p_rec.attribute70),

Line 1881: DECODE(p_rec.attribute67,null, fnd_api.g_miss_char, p_rec.attribute67),

1877: DECODE(p_rec.attribute63,null, fnd_api.g_miss_char, p_rec.attribute63),
1878: DECODE(p_rec.attribute64,null, fnd_api.g_miss_char, p_rec.attribute64),
1879: DECODE(p_rec.attribute65,null, fnd_api.g_miss_char, p_rec.attribute65),
1880: DECODE(p_rec.attribute66,null, fnd_api.g_miss_char, p_rec.attribute66),
1881: DECODE(p_rec.attribute67,null, fnd_api.g_miss_char, p_rec.attribute67),
1882: DECODE(p_rec.attribute68,null, fnd_api.g_miss_char, p_rec.attribute68),
1883: DECODE(p_rec.attribute69,null, fnd_api.g_miss_char, p_rec.attribute69),
1884: DECODE(p_rec.attribute70,null, fnd_api.g_miss_char, p_rec.attribute70),
1885: DECODE(p_rec.attribute71,null, fnd_api.g_miss_char, p_rec.attribute71),

Line 1882: DECODE(p_rec.attribute68,null, fnd_api.g_miss_char, p_rec.attribute68),

1878: DECODE(p_rec.attribute64,null, fnd_api.g_miss_char, p_rec.attribute64),
1879: DECODE(p_rec.attribute65,null, fnd_api.g_miss_char, p_rec.attribute65),
1880: DECODE(p_rec.attribute66,null, fnd_api.g_miss_char, p_rec.attribute66),
1881: DECODE(p_rec.attribute67,null, fnd_api.g_miss_char, p_rec.attribute67),
1882: DECODE(p_rec.attribute68,null, fnd_api.g_miss_char, p_rec.attribute68),
1883: DECODE(p_rec.attribute69,null, fnd_api.g_miss_char, p_rec.attribute69),
1884: DECODE(p_rec.attribute70,null, fnd_api.g_miss_char, p_rec.attribute70),
1885: DECODE(p_rec.attribute71,null, fnd_api.g_miss_char, p_rec.attribute71),
1886: DECODE(p_rec.attribute72,null, fnd_api.g_miss_char, p_rec.attribute72),

Line 1883: DECODE(p_rec.attribute69,null, fnd_api.g_miss_char, p_rec.attribute69),

1879: DECODE(p_rec.attribute65,null, fnd_api.g_miss_char, p_rec.attribute65),
1880: DECODE(p_rec.attribute66,null, fnd_api.g_miss_char, p_rec.attribute66),
1881: DECODE(p_rec.attribute67,null, fnd_api.g_miss_char, p_rec.attribute67),
1882: DECODE(p_rec.attribute68,null, fnd_api.g_miss_char, p_rec.attribute68),
1883: DECODE(p_rec.attribute69,null, fnd_api.g_miss_char, p_rec.attribute69),
1884: DECODE(p_rec.attribute70,null, fnd_api.g_miss_char, p_rec.attribute70),
1885: DECODE(p_rec.attribute71,null, fnd_api.g_miss_char, p_rec.attribute71),
1886: DECODE(p_rec.attribute72,null, fnd_api.g_miss_char, p_rec.attribute72),
1887: DECODE(p_rec.attribute73,null, fnd_api.g_miss_char, p_rec.attribute73),

Line 1884: DECODE(p_rec.attribute70,null, fnd_api.g_miss_char, p_rec.attribute70),

1880: DECODE(p_rec.attribute66,null, fnd_api.g_miss_char, p_rec.attribute66),
1881: DECODE(p_rec.attribute67,null, fnd_api.g_miss_char, p_rec.attribute67),
1882: DECODE(p_rec.attribute68,null, fnd_api.g_miss_char, p_rec.attribute68),
1883: DECODE(p_rec.attribute69,null, fnd_api.g_miss_char, p_rec.attribute69),
1884: DECODE(p_rec.attribute70,null, fnd_api.g_miss_char, p_rec.attribute70),
1885: DECODE(p_rec.attribute71,null, fnd_api.g_miss_char, p_rec.attribute71),
1886: DECODE(p_rec.attribute72,null, fnd_api.g_miss_char, p_rec.attribute72),
1887: DECODE(p_rec.attribute73,null, fnd_api.g_miss_char, p_rec.attribute73),
1888: DECODE(p_rec.attribute74,null, fnd_api.g_miss_char, p_rec.attribute74),

Line 1885: DECODE(p_rec.attribute71,null, fnd_api.g_miss_char, p_rec.attribute71),

1881: DECODE(p_rec.attribute67,null, fnd_api.g_miss_char, p_rec.attribute67),
1882: DECODE(p_rec.attribute68,null, fnd_api.g_miss_char, p_rec.attribute68),
1883: DECODE(p_rec.attribute69,null, fnd_api.g_miss_char, p_rec.attribute69),
1884: DECODE(p_rec.attribute70,null, fnd_api.g_miss_char, p_rec.attribute70),
1885: DECODE(p_rec.attribute71,null, fnd_api.g_miss_char, p_rec.attribute71),
1886: DECODE(p_rec.attribute72,null, fnd_api.g_miss_char, p_rec.attribute72),
1887: DECODE(p_rec.attribute73,null, fnd_api.g_miss_char, p_rec.attribute73),
1888: DECODE(p_rec.attribute74,null, fnd_api.g_miss_char, p_rec.attribute74),
1889: DECODE(p_rec.attribute75,null, fnd_api.g_miss_char, p_rec.attribute75),

Line 1886: DECODE(p_rec.attribute72,null, fnd_api.g_miss_char, p_rec.attribute72),

1882: DECODE(p_rec.attribute68,null, fnd_api.g_miss_char, p_rec.attribute68),
1883: DECODE(p_rec.attribute69,null, fnd_api.g_miss_char, p_rec.attribute69),
1884: DECODE(p_rec.attribute70,null, fnd_api.g_miss_char, p_rec.attribute70),
1885: DECODE(p_rec.attribute71,null, fnd_api.g_miss_char, p_rec.attribute71),
1886: DECODE(p_rec.attribute72,null, fnd_api.g_miss_char, p_rec.attribute72),
1887: DECODE(p_rec.attribute73,null, fnd_api.g_miss_char, p_rec.attribute73),
1888: DECODE(p_rec.attribute74,null, fnd_api.g_miss_char, p_rec.attribute74),
1889: DECODE(p_rec.attribute75,null, fnd_api.g_miss_char, p_rec.attribute75),
1890: DECODE(p_rec.attribute76,null, fnd_api.g_miss_char, p_rec.attribute76),

Line 1887: DECODE(p_rec.attribute73,null, fnd_api.g_miss_char, p_rec.attribute73),

1883: DECODE(p_rec.attribute69,null, fnd_api.g_miss_char, p_rec.attribute69),
1884: DECODE(p_rec.attribute70,null, fnd_api.g_miss_char, p_rec.attribute70),
1885: DECODE(p_rec.attribute71,null, fnd_api.g_miss_char, p_rec.attribute71),
1886: DECODE(p_rec.attribute72,null, fnd_api.g_miss_char, p_rec.attribute72),
1887: DECODE(p_rec.attribute73,null, fnd_api.g_miss_char, p_rec.attribute73),
1888: DECODE(p_rec.attribute74,null, fnd_api.g_miss_char, p_rec.attribute74),
1889: DECODE(p_rec.attribute75,null, fnd_api.g_miss_char, p_rec.attribute75),
1890: DECODE(p_rec.attribute76,null, fnd_api.g_miss_char, p_rec.attribute76),
1891: DECODE(p_rec.attribute77,null, fnd_api.g_miss_char, p_rec.attribute77),

Line 1888: DECODE(p_rec.attribute74,null, fnd_api.g_miss_char, p_rec.attribute74),

1884: DECODE(p_rec.attribute70,null, fnd_api.g_miss_char, p_rec.attribute70),
1885: DECODE(p_rec.attribute71,null, fnd_api.g_miss_char, p_rec.attribute71),
1886: DECODE(p_rec.attribute72,null, fnd_api.g_miss_char, p_rec.attribute72),
1887: DECODE(p_rec.attribute73,null, fnd_api.g_miss_char, p_rec.attribute73),
1888: DECODE(p_rec.attribute74,null, fnd_api.g_miss_char, p_rec.attribute74),
1889: DECODE(p_rec.attribute75,null, fnd_api.g_miss_char, p_rec.attribute75),
1890: DECODE(p_rec.attribute76,null, fnd_api.g_miss_char, p_rec.attribute76),
1891: DECODE(p_rec.attribute77,null, fnd_api.g_miss_char, p_rec.attribute77),
1892: DECODE(p_rec.attribute78,null, fnd_api.g_miss_char, p_rec.attribute78),

Line 1889: DECODE(p_rec.attribute75,null, fnd_api.g_miss_char, p_rec.attribute75),

1885: DECODE(p_rec.attribute71,null, fnd_api.g_miss_char, p_rec.attribute71),
1886: DECODE(p_rec.attribute72,null, fnd_api.g_miss_char, p_rec.attribute72),
1887: DECODE(p_rec.attribute73,null, fnd_api.g_miss_char, p_rec.attribute73),
1888: DECODE(p_rec.attribute74,null, fnd_api.g_miss_char, p_rec.attribute74),
1889: DECODE(p_rec.attribute75,null, fnd_api.g_miss_char, p_rec.attribute75),
1890: DECODE(p_rec.attribute76,null, fnd_api.g_miss_char, p_rec.attribute76),
1891: DECODE(p_rec.attribute77,null, fnd_api.g_miss_char, p_rec.attribute77),
1892: DECODE(p_rec.attribute78,null, fnd_api.g_miss_char, p_rec.attribute78),
1893: DECODE(p_rec.attribute79,null, fnd_api.g_miss_char, p_rec.attribute79),

Line 1890: DECODE(p_rec.attribute76,null, fnd_api.g_miss_char, p_rec.attribute76),

1886: DECODE(p_rec.attribute72,null, fnd_api.g_miss_char, p_rec.attribute72),
1887: DECODE(p_rec.attribute73,null, fnd_api.g_miss_char, p_rec.attribute73),
1888: DECODE(p_rec.attribute74,null, fnd_api.g_miss_char, p_rec.attribute74),
1889: DECODE(p_rec.attribute75,null, fnd_api.g_miss_char, p_rec.attribute75),
1890: DECODE(p_rec.attribute76,null, fnd_api.g_miss_char, p_rec.attribute76),
1891: DECODE(p_rec.attribute77,null, fnd_api.g_miss_char, p_rec.attribute77),
1892: DECODE(p_rec.attribute78,null, fnd_api.g_miss_char, p_rec.attribute78),
1893: DECODE(p_rec.attribute79,null, fnd_api.g_miss_char, p_rec.attribute79),
1894: DECODE(p_rec.attribute80,null, fnd_api.g_miss_char, p_rec.attribute80),

Line 1891: DECODE(p_rec.attribute77,null, fnd_api.g_miss_char, p_rec.attribute77),

1887: DECODE(p_rec.attribute73,null, fnd_api.g_miss_char, p_rec.attribute73),
1888: DECODE(p_rec.attribute74,null, fnd_api.g_miss_char, p_rec.attribute74),
1889: DECODE(p_rec.attribute75,null, fnd_api.g_miss_char, p_rec.attribute75),
1890: DECODE(p_rec.attribute76,null, fnd_api.g_miss_char, p_rec.attribute76),
1891: DECODE(p_rec.attribute77,null, fnd_api.g_miss_char, p_rec.attribute77),
1892: DECODE(p_rec.attribute78,null, fnd_api.g_miss_char, p_rec.attribute78),
1893: DECODE(p_rec.attribute79,null, fnd_api.g_miss_char, p_rec.attribute79),
1894: DECODE(p_rec.attribute80,null, fnd_api.g_miss_char, p_rec.attribute80),
1895: DECODE(p_rec.attribute81,null, fnd_api.g_miss_char, p_rec.attribute81),

Line 1892: DECODE(p_rec.attribute78,null, fnd_api.g_miss_char, p_rec.attribute78),

1888: DECODE(p_rec.attribute74,null, fnd_api.g_miss_char, p_rec.attribute74),
1889: DECODE(p_rec.attribute75,null, fnd_api.g_miss_char, p_rec.attribute75),
1890: DECODE(p_rec.attribute76,null, fnd_api.g_miss_char, p_rec.attribute76),
1891: DECODE(p_rec.attribute77,null, fnd_api.g_miss_char, p_rec.attribute77),
1892: DECODE(p_rec.attribute78,null, fnd_api.g_miss_char, p_rec.attribute78),
1893: DECODE(p_rec.attribute79,null, fnd_api.g_miss_char, p_rec.attribute79),
1894: DECODE(p_rec.attribute80,null, fnd_api.g_miss_char, p_rec.attribute80),
1895: DECODE(p_rec.attribute81,null, fnd_api.g_miss_char, p_rec.attribute81),
1896: DECODE(p_rec.attribute82,null, fnd_api.g_miss_char, p_rec.attribute82),

Line 1893: DECODE(p_rec.attribute79,null, fnd_api.g_miss_char, p_rec.attribute79),

1889: DECODE(p_rec.attribute75,null, fnd_api.g_miss_char, p_rec.attribute75),
1890: DECODE(p_rec.attribute76,null, fnd_api.g_miss_char, p_rec.attribute76),
1891: DECODE(p_rec.attribute77,null, fnd_api.g_miss_char, p_rec.attribute77),
1892: DECODE(p_rec.attribute78,null, fnd_api.g_miss_char, p_rec.attribute78),
1893: DECODE(p_rec.attribute79,null, fnd_api.g_miss_char, p_rec.attribute79),
1894: DECODE(p_rec.attribute80,null, fnd_api.g_miss_char, p_rec.attribute80),
1895: DECODE(p_rec.attribute81,null, fnd_api.g_miss_char, p_rec.attribute81),
1896: DECODE(p_rec.attribute82,null, fnd_api.g_miss_char, p_rec.attribute82),
1897: DECODE(p_rec.attribute83,null, fnd_api.g_miss_char, p_rec.attribute83),

Line 1894: DECODE(p_rec.attribute80,null, fnd_api.g_miss_char, p_rec.attribute80),

1890: DECODE(p_rec.attribute76,null, fnd_api.g_miss_char, p_rec.attribute76),
1891: DECODE(p_rec.attribute77,null, fnd_api.g_miss_char, p_rec.attribute77),
1892: DECODE(p_rec.attribute78,null, fnd_api.g_miss_char, p_rec.attribute78),
1893: DECODE(p_rec.attribute79,null, fnd_api.g_miss_char, p_rec.attribute79),
1894: DECODE(p_rec.attribute80,null, fnd_api.g_miss_char, p_rec.attribute80),
1895: DECODE(p_rec.attribute81,null, fnd_api.g_miss_char, p_rec.attribute81),
1896: DECODE(p_rec.attribute82,null, fnd_api.g_miss_char, p_rec.attribute82),
1897: DECODE(p_rec.attribute83,null, fnd_api.g_miss_char, p_rec.attribute83),
1898: DECODE(p_rec.attribute84,null, fnd_api.g_miss_char, p_rec.attribute84),

Line 1895: DECODE(p_rec.attribute81,null, fnd_api.g_miss_char, p_rec.attribute81),

1891: DECODE(p_rec.attribute77,null, fnd_api.g_miss_char, p_rec.attribute77),
1892: DECODE(p_rec.attribute78,null, fnd_api.g_miss_char, p_rec.attribute78),
1893: DECODE(p_rec.attribute79,null, fnd_api.g_miss_char, p_rec.attribute79),
1894: DECODE(p_rec.attribute80,null, fnd_api.g_miss_char, p_rec.attribute80),
1895: DECODE(p_rec.attribute81,null, fnd_api.g_miss_char, p_rec.attribute81),
1896: DECODE(p_rec.attribute82,null, fnd_api.g_miss_char, p_rec.attribute82),
1897: DECODE(p_rec.attribute83,null, fnd_api.g_miss_char, p_rec.attribute83),
1898: DECODE(p_rec.attribute84,null, fnd_api.g_miss_char, p_rec.attribute84),
1899: DECODE(p_rec.attribute85,null, fnd_api.g_miss_char, p_rec.attribute85),

Line 1896: DECODE(p_rec.attribute82,null, fnd_api.g_miss_char, p_rec.attribute82),

1892: DECODE(p_rec.attribute78,null, fnd_api.g_miss_char, p_rec.attribute78),
1893: DECODE(p_rec.attribute79,null, fnd_api.g_miss_char, p_rec.attribute79),
1894: DECODE(p_rec.attribute80,null, fnd_api.g_miss_char, p_rec.attribute80),
1895: DECODE(p_rec.attribute81,null, fnd_api.g_miss_char, p_rec.attribute81),
1896: DECODE(p_rec.attribute82,null, fnd_api.g_miss_char, p_rec.attribute82),
1897: DECODE(p_rec.attribute83,null, fnd_api.g_miss_char, p_rec.attribute83),
1898: DECODE(p_rec.attribute84,null, fnd_api.g_miss_char, p_rec.attribute84),
1899: DECODE(p_rec.attribute85,null, fnd_api.g_miss_char, p_rec.attribute85),
1900: DECODE(p_rec.attribute86,null, fnd_api.g_miss_char, p_rec.attribute86),

Line 1897: DECODE(p_rec.attribute83,null, fnd_api.g_miss_char, p_rec.attribute83),

1893: DECODE(p_rec.attribute79,null, fnd_api.g_miss_char, p_rec.attribute79),
1894: DECODE(p_rec.attribute80,null, fnd_api.g_miss_char, p_rec.attribute80),
1895: DECODE(p_rec.attribute81,null, fnd_api.g_miss_char, p_rec.attribute81),
1896: DECODE(p_rec.attribute82,null, fnd_api.g_miss_char, p_rec.attribute82),
1897: DECODE(p_rec.attribute83,null, fnd_api.g_miss_char, p_rec.attribute83),
1898: DECODE(p_rec.attribute84,null, fnd_api.g_miss_char, p_rec.attribute84),
1899: DECODE(p_rec.attribute85,null, fnd_api.g_miss_char, p_rec.attribute85),
1900: DECODE(p_rec.attribute86,null, fnd_api.g_miss_char, p_rec.attribute86),
1901: DECODE(p_rec.attribute87,null, fnd_api.g_miss_char, p_rec.attribute87),

Line 1898: DECODE(p_rec.attribute84,null, fnd_api.g_miss_char, p_rec.attribute84),

1894: DECODE(p_rec.attribute80,null, fnd_api.g_miss_char, p_rec.attribute80),
1895: DECODE(p_rec.attribute81,null, fnd_api.g_miss_char, p_rec.attribute81),
1896: DECODE(p_rec.attribute82,null, fnd_api.g_miss_char, p_rec.attribute82),
1897: DECODE(p_rec.attribute83,null, fnd_api.g_miss_char, p_rec.attribute83),
1898: DECODE(p_rec.attribute84,null, fnd_api.g_miss_char, p_rec.attribute84),
1899: DECODE(p_rec.attribute85,null, fnd_api.g_miss_char, p_rec.attribute85),
1900: DECODE(p_rec.attribute86,null, fnd_api.g_miss_char, p_rec.attribute86),
1901: DECODE(p_rec.attribute87,null, fnd_api.g_miss_char, p_rec.attribute87),
1902: DECODE(p_rec.attribute88,null, fnd_api.g_miss_char, p_rec.attribute88),

Line 1899: DECODE(p_rec.attribute85,null, fnd_api.g_miss_char, p_rec.attribute85),

1895: DECODE(p_rec.attribute81,null, fnd_api.g_miss_char, p_rec.attribute81),
1896: DECODE(p_rec.attribute82,null, fnd_api.g_miss_char, p_rec.attribute82),
1897: DECODE(p_rec.attribute83,null, fnd_api.g_miss_char, p_rec.attribute83),
1898: DECODE(p_rec.attribute84,null, fnd_api.g_miss_char, p_rec.attribute84),
1899: DECODE(p_rec.attribute85,null, fnd_api.g_miss_char, p_rec.attribute85),
1900: DECODE(p_rec.attribute86,null, fnd_api.g_miss_char, p_rec.attribute86),
1901: DECODE(p_rec.attribute87,null, fnd_api.g_miss_char, p_rec.attribute87),
1902: DECODE(p_rec.attribute88,null, fnd_api.g_miss_char, p_rec.attribute88),
1903: DECODE(p_rec.attribute89,null, fnd_api.g_miss_char, p_rec.attribute89),

Line 1900: DECODE(p_rec.attribute86,null, fnd_api.g_miss_char, p_rec.attribute86),

1896: DECODE(p_rec.attribute82,null, fnd_api.g_miss_char, p_rec.attribute82),
1897: DECODE(p_rec.attribute83,null, fnd_api.g_miss_char, p_rec.attribute83),
1898: DECODE(p_rec.attribute84,null, fnd_api.g_miss_char, p_rec.attribute84),
1899: DECODE(p_rec.attribute85,null, fnd_api.g_miss_char, p_rec.attribute85),
1900: DECODE(p_rec.attribute86,null, fnd_api.g_miss_char, p_rec.attribute86),
1901: DECODE(p_rec.attribute87,null, fnd_api.g_miss_char, p_rec.attribute87),
1902: DECODE(p_rec.attribute88,null, fnd_api.g_miss_char, p_rec.attribute88),
1903: DECODE(p_rec.attribute89,null, fnd_api.g_miss_char, p_rec.attribute89),
1904: DECODE(p_rec.attribute90,null, fnd_api.g_miss_char, p_rec.attribute90),

Line 1901: DECODE(p_rec.attribute87,null, fnd_api.g_miss_char, p_rec.attribute87),

1897: DECODE(p_rec.attribute83,null, fnd_api.g_miss_char, p_rec.attribute83),
1898: DECODE(p_rec.attribute84,null, fnd_api.g_miss_char, p_rec.attribute84),
1899: DECODE(p_rec.attribute85,null, fnd_api.g_miss_char, p_rec.attribute85),
1900: DECODE(p_rec.attribute86,null, fnd_api.g_miss_char, p_rec.attribute86),
1901: DECODE(p_rec.attribute87,null, fnd_api.g_miss_char, p_rec.attribute87),
1902: DECODE(p_rec.attribute88,null, fnd_api.g_miss_char, p_rec.attribute88),
1903: DECODE(p_rec.attribute89,null, fnd_api.g_miss_char, p_rec.attribute89),
1904: DECODE(p_rec.attribute90,null, fnd_api.g_miss_char, p_rec.attribute90),
1905: DECODE(p_rec.attribute91,null, fnd_api.g_miss_char, p_rec.attribute91),

Line 1902: DECODE(p_rec.attribute88,null, fnd_api.g_miss_char, p_rec.attribute88),

1898: DECODE(p_rec.attribute84,null, fnd_api.g_miss_char, p_rec.attribute84),
1899: DECODE(p_rec.attribute85,null, fnd_api.g_miss_char, p_rec.attribute85),
1900: DECODE(p_rec.attribute86,null, fnd_api.g_miss_char, p_rec.attribute86),
1901: DECODE(p_rec.attribute87,null, fnd_api.g_miss_char, p_rec.attribute87),
1902: DECODE(p_rec.attribute88,null, fnd_api.g_miss_char, p_rec.attribute88),
1903: DECODE(p_rec.attribute89,null, fnd_api.g_miss_char, p_rec.attribute89),
1904: DECODE(p_rec.attribute90,null, fnd_api.g_miss_char, p_rec.attribute90),
1905: DECODE(p_rec.attribute91,null, fnd_api.g_miss_char, p_rec.attribute91),
1906: DECODE(p_rec.attribute92,null, fnd_api.g_miss_char, p_rec.attribute92),

Line 1903: DECODE(p_rec.attribute89,null, fnd_api.g_miss_char, p_rec.attribute89),

1899: DECODE(p_rec.attribute85,null, fnd_api.g_miss_char, p_rec.attribute85),
1900: DECODE(p_rec.attribute86,null, fnd_api.g_miss_char, p_rec.attribute86),
1901: DECODE(p_rec.attribute87,null, fnd_api.g_miss_char, p_rec.attribute87),
1902: DECODE(p_rec.attribute88,null, fnd_api.g_miss_char, p_rec.attribute88),
1903: DECODE(p_rec.attribute89,null, fnd_api.g_miss_char, p_rec.attribute89),
1904: DECODE(p_rec.attribute90,null, fnd_api.g_miss_char, p_rec.attribute90),
1905: DECODE(p_rec.attribute91,null, fnd_api.g_miss_char, p_rec.attribute91),
1906: DECODE(p_rec.attribute92,null, fnd_api.g_miss_char, p_rec.attribute92),
1907: DECODE(p_rec.attribute93,null, fnd_api.g_miss_char, p_rec.attribute93),

Line 1904: DECODE(p_rec.attribute90,null, fnd_api.g_miss_char, p_rec.attribute90),

1900: DECODE(p_rec.attribute86,null, fnd_api.g_miss_char, p_rec.attribute86),
1901: DECODE(p_rec.attribute87,null, fnd_api.g_miss_char, p_rec.attribute87),
1902: DECODE(p_rec.attribute88,null, fnd_api.g_miss_char, p_rec.attribute88),
1903: DECODE(p_rec.attribute89,null, fnd_api.g_miss_char, p_rec.attribute89),
1904: DECODE(p_rec.attribute90,null, fnd_api.g_miss_char, p_rec.attribute90),
1905: DECODE(p_rec.attribute91,null, fnd_api.g_miss_char, p_rec.attribute91),
1906: DECODE(p_rec.attribute92,null, fnd_api.g_miss_char, p_rec.attribute92),
1907: DECODE(p_rec.attribute93,null, fnd_api.g_miss_char, p_rec.attribute93),
1908: DECODE(p_rec.attribute94,null, fnd_api.g_miss_char, p_rec.attribute94),

Line 1905: DECODE(p_rec.attribute91,null, fnd_api.g_miss_char, p_rec.attribute91),

1901: DECODE(p_rec.attribute87,null, fnd_api.g_miss_char, p_rec.attribute87),
1902: DECODE(p_rec.attribute88,null, fnd_api.g_miss_char, p_rec.attribute88),
1903: DECODE(p_rec.attribute89,null, fnd_api.g_miss_char, p_rec.attribute89),
1904: DECODE(p_rec.attribute90,null, fnd_api.g_miss_char, p_rec.attribute90),
1905: DECODE(p_rec.attribute91,null, fnd_api.g_miss_char, p_rec.attribute91),
1906: DECODE(p_rec.attribute92,null, fnd_api.g_miss_char, p_rec.attribute92),
1907: DECODE(p_rec.attribute93,null, fnd_api.g_miss_char, p_rec.attribute93),
1908: DECODE(p_rec.attribute94,null, fnd_api.g_miss_char, p_rec.attribute94),
1909: DECODE(p_rec.attribute95,null, fnd_api.g_miss_char, p_rec.attribute95),

Line 1906: DECODE(p_rec.attribute92,null, fnd_api.g_miss_char, p_rec.attribute92),

1902: DECODE(p_rec.attribute88,null, fnd_api.g_miss_char, p_rec.attribute88),
1903: DECODE(p_rec.attribute89,null, fnd_api.g_miss_char, p_rec.attribute89),
1904: DECODE(p_rec.attribute90,null, fnd_api.g_miss_char, p_rec.attribute90),
1905: DECODE(p_rec.attribute91,null, fnd_api.g_miss_char, p_rec.attribute91),
1906: DECODE(p_rec.attribute92,null, fnd_api.g_miss_char, p_rec.attribute92),
1907: DECODE(p_rec.attribute93,null, fnd_api.g_miss_char, p_rec.attribute93),
1908: DECODE(p_rec.attribute94,null, fnd_api.g_miss_char, p_rec.attribute94),
1909: DECODE(p_rec.attribute95,null, fnd_api.g_miss_char, p_rec.attribute95),
1910: DECODE(p_rec.attribute96,null, fnd_api.g_miss_char, p_rec.attribute96),

Line 1907: DECODE(p_rec.attribute93,null, fnd_api.g_miss_char, p_rec.attribute93),

1903: DECODE(p_rec.attribute89,null, fnd_api.g_miss_char, p_rec.attribute89),
1904: DECODE(p_rec.attribute90,null, fnd_api.g_miss_char, p_rec.attribute90),
1905: DECODE(p_rec.attribute91,null, fnd_api.g_miss_char, p_rec.attribute91),
1906: DECODE(p_rec.attribute92,null, fnd_api.g_miss_char, p_rec.attribute92),
1907: DECODE(p_rec.attribute93,null, fnd_api.g_miss_char, p_rec.attribute93),
1908: DECODE(p_rec.attribute94,null, fnd_api.g_miss_char, p_rec.attribute94),
1909: DECODE(p_rec.attribute95,null, fnd_api.g_miss_char, p_rec.attribute95),
1910: DECODE(p_rec.attribute96,null, fnd_api.g_miss_char, p_rec.attribute96),
1911: DECODE(p_rec.attribute97,null, fnd_api.g_miss_char, p_rec.attribute97),

Line 1908: DECODE(p_rec.attribute94,null, fnd_api.g_miss_char, p_rec.attribute94),

1904: DECODE(p_rec.attribute90,null, fnd_api.g_miss_char, p_rec.attribute90),
1905: DECODE(p_rec.attribute91,null, fnd_api.g_miss_char, p_rec.attribute91),
1906: DECODE(p_rec.attribute92,null, fnd_api.g_miss_char, p_rec.attribute92),
1907: DECODE(p_rec.attribute93,null, fnd_api.g_miss_char, p_rec.attribute93),
1908: DECODE(p_rec.attribute94,null, fnd_api.g_miss_char, p_rec.attribute94),
1909: DECODE(p_rec.attribute95,null, fnd_api.g_miss_char, p_rec.attribute95),
1910: DECODE(p_rec.attribute96,null, fnd_api.g_miss_char, p_rec.attribute96),
1911: DECODE(p_rec.attribute97,null, fnd_api.g_miss_char, p_rec.attribute97),
1912: DECODE(p_rec.attribute98,null, fnd_api.g_miss_char, p_rec.attribute98),

Line 1909: DECODE(p_rec.attribute95,null, fnd_api.g_miss_char, p_rec.attribute95),

1905: DECODE(p_rec.attribute91,null, fnd_api.g_miss_char, p_rec.attribute91),
1906: DECODE(p_rec.attribute92,null, fnd_api.g_miss_char, p_rec.attribute92),
1907: DECODE(p_rec.attribute93,null, fnd_api.g_miss_char, p_rec.attribute93),
1908: DECODE(p_rec.attribute94,null, fnd_api.g_miss_char, p_rec.attribute94),
1909: DECODE(p_rec.attribute95,null, fnd_api.g_miss_char, p_rec.attribute95),
1910: DECODE(p_rec.attribute96,null, fnd_api.g_miss_char, p_rec.attribute96),
1911: DECODE(p_rec.attribute97,null, fnd_api.g_miss_char, p_rec.attribute97),
1912: DECODE(p_rec.attribute98,null, fnd_api.g_miss_char, p_rec.attribute98),
1913: DECODE(p_rec.attribute99,null, fnd_api.g_miss_char, p_rec.attribute99),

Line 1910: DECODE(p_rec.attribute96,null, fnd_api.g_miss_char, p_rec.attribute96),

1906: DECODE(p_rec.attribute92,null, fnd_api.g_miss_char, p_rec.attribute92),
1907: DECODE(p_rec.attribute93,null, fnd_api.g_miss_char, p_rec.attribute93),
1908: DECODE(p_rec.attribute94,null, fnd_api.g_miss_char, p_rec.attribute94),
1909: DECODE(p_rec.attribute95,null, fnd_api.g_miss_char, p_rec.attribute95),
1910: DECODE(p_rec.attribute96,null, fnd_api.g_miss_char, p_rec.attribute96),
1911: DECODE(p_rec.attribute97,null, fnd_api.g_miss_char, p_rec.attribute97),
1912: DECODE(p_rec.attribute98,null, fnd_api.g_miss_char, p_rec.attribute98),
1913: DECODE(p_rec.attribute99,null, fnd_api.g_miss_char, p_rec.attribute99),
1914: DECODE(p_rec.attribute100,null, fnd_api.g_miss_char, p_rec.attribute100),

Line 1911: DECODE(p_rec.attribute97,null, fnd_api.g_miss_char, p_rec.attribute97),

1907: DECODE(p_rec.attribute93,null, fnd_api.g_miss_char, p_rec.attribute93),
1908: DECODE(p_rec.attribute94,null, fnd_api.g_miss_char, p_rec.attribute94),
1909: DECODE(p_rec.attribute95,null, fnd_api.g_miss_char, p_rec.attribute95),
1910: DECODE(p_rec.attribute96,null, fnd_api.g_miss_char, p_rec.attribute96),
1911: DECODE(p_rec.attribute97,null, fnd_api.g_miss_char, p_rec.attribute97),
1912: DECODE(p_rec.attribute98,null, fnd_api.g_miss_char, p_rec.attribute98),
1913: DECODE(p_rec.attribute99,null, fnd_api.g_miss_char, p_rec.attribute99),
1914: DECODE(p_rec.attribute100,null, fnd_api.g_miss_char, p_rec.attribute100),
1915: DECODE(p_rec.direct_salesrep_number,null,fnd_api.g_miss_char, p_rec.direct_salesrep_number),

Line 1912: DECODE(p_rec.attribute98,null, fnd_api.g_miss_char, p_rec.attribute98),

1908: DECODE(p_rec.attribute94,null, fnd_api.g_miss_char, p_rec.attribute94),
1909: DECODE(p_rec.attribute95,null, fnd_api.g_miss_char, p_rec.attribute95),
1910: DECODE(p_rec.attribute96,null, fnd_api.g_miss_char, p_rec.attribute96),
1911: DECODE(p_rec.attribute97,null, fnd_api.g_miss_char, p_rec.attribute97),
1912: DECODE(p_rec.attribute98,null, fnd_api.g_miss_char, p_rec.attribute98),
1913: DECODE(p_rec.attribute99,null, fnd_api.g_miss_char, p_rec.attribute99),
1914: DECODE(p_rec.attribute100,null, fnd_api.g_miss_char, p_rec.attribute100),
1915: DECODE(p_rec.direct_salesrep_number,null,fnd_api.g_miss_char, p_rec.direct_salesrep_number),
1916: DECODE(p_rec.comm_lines_api_id,null,fnd_api.g_miss_num, p_rec.comm_lines_api_id),

Line 1913: DECODE(p_rec.attribute99,null, fnd_api.g_miss_char, p_rec.attribute99),

1909: DECODE(p_rec.attribute95,null, fnd_api.g_miss_char, p_rec.attribute95),
1910: DECODE(p_rec.attribute96,null, fnd_api.g_miss_char, p_rec.attribute96),
1911: DECODE(p_rec.attribute97,null, fnd_api.g_miss_char, p_rec.attribute97),
1912: DECODE(p_rec.attribute98,null, fnd_api.g_miss_char, p_rec.attribute98),
1913: DECODE(p_rec.attribute99,null, fnd_api.g_miss_char, p_rec.attribute99),
1914: DECODE(p_rec.attribute100,null, fnd_api.g_miss_char, p_rec.attribute100),
1915: DECODE(p_rec.direct_salesrep_number,null,fnd_api.g_miss_char, p_rec.direct_salesrep_number),
1916: DECODE(p_rec.comm_lines_api_id,null,fnd_api.g_miss_num, p_rec.comm_lines_api_id),
1917: DECODE(p_rec.rollup_date,NULL, fnd_api.g_miss_date,

Line 1914: DECODE(p_rec.attribute100,null, fnd_api.g_miss_char, p_rec.attribute100),

1910: DECODE(p_rec.attribute96,null, fnd_api.g_miss_char, p_rec.attribute96),
1911: DECODE(p_rec.attribute97,null, fnd_api.g_miss_char, p_rec.attribute97),
1912: DECODE(p_rec.attribute98,null, fnd_api.g_miss_char, p_rec.attribute98),
1913: DECODE(p_rec.attribute99,null, fnd_api.g_miss_char, p_rec.attribute99),
1914: DECODE(p_rec.attribute100,null, fnd_api.g_miss_char, p_rec.attribute100),
1915: DECODE(p_rec.direct_salesrep_number,null,fnd_api.g_miss_char, p_rec.direct_salesrep_number),
1916: DECODE(p_rec.comm_lines_api_id,null,fnd_api.g_miss_num, p_rec.comm_lines_api_id),
1917: DECODE(p_rec.rollup_date,NULL, fnd_api.g_miss_date,
1918: p_rec.rollup_date),

Line 1915: DECODE(p_rec.direct_salesrep_number,null,fnd_api.g_miss_char, p_rec.direct_salesrep_number),

1911: DECODE(p_rec.attribute97,null, fnd_api.g_miss_char, p_rec.attribute97),
1912: DECODE(p_rec.attribute98,null, fnd_api.g_miss_char, p_rec.attribute98),
1913: DECODE(p_rec.attribute99,null, fnd_api.g_miss_char, p_rec.attribute99),
1914: DECODE(p_rec.attribute100,null, fnd_api.g_miss_char, p_rec.attribute100),
1915: DECODE(p_rec.direct_salesrep_number,null,fnd_api.g_miss_char, p_rec.direct_salesrep_number),
1916: DECODE(p_rec.comm_lines_api_id,null,fnd_api.g_miss_num, p_rec.comm_lines_api_id),
1917: DECODE(p_rec.rollup_date,NULL, fnd_api.g_miss_date,
1918: p_rec.rollup_date),
1919: DECODE(p_rec.source_doc_type,NULL, fnd_api.g_miss_char,

Line 1916: DECODE(p_rec.comm_lines_api_id,null,fnd_api.g_miss_num, p_rec.comm_lines_api_id),

1912: DECODE(p_rec.attribute98,null, fnd_api.g_miss_char, p_rec.attribute98),
1913: DECODE(p_rec.attribute99,null, fnd_api.g_miss_char, p_rec.attribute99),
1914: DECODE(p_rec.attribute100,null, fnd_api.g_miss_char, p_rec.attribute100),
1915: DECODE(p_rec.direct_salesrep_number,null,fnd_api.g_miss_char, p_rec.direct_salesrep_number),
1916: DECODE(p_rec.comm_lines_api_id,null,fnd_api.g_miss_num, p_rec.comm_lines_api_id),
1917: DECODE(p_rec.rollup_date,NULL, fnd_api.g_miss_date,
1918: p_rec.rollup_date),
1919: DECODE(p_rec.source_doc_type,NULL, fnd_api.g_miss_char,
1920: p_rec.source_doc_type),

Line 1917: DECODE(p_rec.rollup_date,NULL, fnd_api.g_miss_date,

1913: DECODE(p_rec.attribute99,null, fnd_api.g_miss_char, p_rec.attribute99),
1914: DECODE(p_rec.attribute100,null, fnd_api.g_miss_char, p_rec.attribute100),
1915: DECODE(p_rec.direct_salesrep_number,null,fnd_api.g_miss_char, p_rec.direct_salesrep_number),
1916: DECODE(p_rec.comm_lines_api_id,null,fnd_api.g_miss_num, p_rec.comm_lines_api_id),
1917: DECODE(p_rec.rollup_date,NULL, fnd_api.g_miss_date,
1918: p_rec.rollup_date),
1919: DECODE(p_rec.source_doc_type,NULL, fnd_api.g_miss_char,
1920: p_rec.source_doc_type),
1921: DECODE(p_rec.orig_currency_code,NULL, fnd_api.g_miss_char,

Line 1919: DECODE(p_rec.source_doc_type,NULL, fnd_api.g_miss_char,

1915: DECODE(p_rec.direct_salesrep_number,null,fnd_api.g_miss_char, p_rec.direct_salesrep_number),
1916: DECODE(p_rec.comm_lines_api_id,null,fnd_api.g_miss_num, p_rec.comm_lines_api_id),
1917: DECODE(p_rec.rollup_date,NULL, fnd_api.g_miss_date,
1918: p_rec.rollup_date),
1919: DECODE(p_rec.source_doc_type,NULL, fnd_api.g_miss_char,
1920: p_rec.source_doc_type),
1921: DECODE(p_rec.orig_currency_code,NULL, fnd_api.g_miss_char,
1922: p_rec.orig_currency_code),
1923: DECODE(p_rec.exchange_rate,NULL, fnd_api.g_miss_num,

Line 1921: DECODE(p_rec.orig_currency_code,NULL, fnd_api.g_miss_char,

1917: DECODE(p_rec.rollup_date,NULL, fnd_api.g_miss_date,
1918: p_rec.rollup_date),
1919: DECODE(p_rec.source_doc_type,NULL, fnd_api.g_miss_char,
1920: p_rec.source_doc_type),
1921: DECODE(p_rec.orig_currency_code,NULL, fnd_api.g_miss_char,
1922: p_rec.orig_currency_code),
1923: DECODE(p_rec.exchange_rate,NULL, fnd_api.g_miss_num,
1924: p_rec.exchange_rate),
1925: DECODE(p_rec.transaction_amount_orig,NULL, fnd_api.g_miss_num,

Line 1923: DECODE(p_rec.exchange_rate,NULL, fnd_api.g_miss_num,

1919: DECODE(p_rec.source_doc_type,NULL, fnd_api.g_miss_char,
1920: p_rec.source_doc_type),
1921: DECODE(p_rec.orig_currency_code,NULL, fnd_api.g_miss_char,
1922: p_rec.orig_currency_code),
1923: DECODE(p_rec.exchange_rate,NULL, fnd_api.g_miss_num,
1924: p_rec.exchange_rate),
1925: DECODE(p_rec.transaction_amount_orig,NULL, fnd_api.g_miss_num,
1926: p_rec.transaction_amount_orig),
1927: DECODE(p_rec.trx_id,NULL, fnd_api.g_miss_num,

Line 1925: DECODE(p_rec.transaction_amount_orig,NULL, fnd_api.g_miss_num,

1921: DECODE(p_rec.orig_currency_code,NULL, fnd_api.g_miss_char,
1922: p_rec.orig_currency_code),
1923: DECODE(p_rec.exchange_rate,NULL, fnd_api.g_miss_num,
1924: p_rec.exchange_rate),
1925: DECODE(p_rec.transaction_amount_orig,NULL, fnd_api.g_miss_num,
1926: p_rec.transaction_amount_orig),
1927: DECODE(p_rec.trx_id,NULL, fnd_api.g_miss_num,
1928: p_rec.trx_id),
1929: DECODE(p_rec.trx_line_id,NULL, fnd_api.g_miss_num,

Line 1927: DECODE(p_rec.trx_id,NULL, fnd_api.g_miss_num,

1923: DECODE(p_rec.exchange_rate,NULL, fnd_api.g_miss_num,
1924: p_rec.exchange_rate),
1925: DECODE(p_rec.transaction_amount_orig,NULL, fnd_api.g_miss_num,
1926: p_rec.transaction_amount_orig),
1927: DECODE(p_rec.trx_id,NULL, fnd_api.g_miss_num,
1928: p_rec.trx_id),
1929: DECODE(p_rec.trx_line_id,NULL, fnd_api.g_miss_num,
1930: p_rec.trx_line_id),
1931: DECODE(p_rec.trx_sales_line_id,NULL, fnd_api.g_miss_num,

Line 1929: DECODE(p_rec.trx_line_id,NULL, fnd_api.g_miss_num,

1925: DECODE(p_rec.transaction_amount_orig,NULL, fnd_api.g_miss_num,
1926: p_rec.transaction_amount_orig),
1927: DECODE(p_rec.trx_id,NULL, fnd_api.g_miss_num,
1928: p_rec.trx_id),
1929: DECODE(p_rec.trx_line_id,NULL, fnd_api.g_miss_num,
1930: p_rec.trx_line_id),
1931: DECODE(p_rec.trx_sales_line_id,NULL, fnd_api.g_miss_num,
1932: p_rec.trx_sales_line_id),
1933: DECODE(p_rec.quantity,NULL, fnd_api.g_miss_num,

Line 1931: DECODE(p_rec.trx_sales_line_id,NULL, fnd_api.g_miss_num,

1927: DECODE(p_rec.trx_id,NULL, fnd_api.g_miss_num,
1928: p_rec.trx_id),
1929: DECODE(p_rec.trx_line_id,NULL, fnd_api.g_miss_num,
1930: p_rec.trx_line_id),
1931: DECODE(p_rec.trx_sales_line_id,NULL, fnd_api.g_miss_num,
1932: p_rec.trx_sales_line_id),
1933: DECODE(p_rec.quantity,NULL, fnd_api.g_miss_num,
1934: p_rec.quantity),
1935: DECODE(p_rec.source_trx_number,NULL, fnd_api.g_miss_char,

Line 1933: DECODE(p_rec.quantity,NULL, fnd_api.g_miss_num,

1929: DECODE(p_rec.trx_line_id,NULL, fnd_api.g_miss_num,
1930: p_rec.trx_line_id),
1931: DECODE(p_rec.trx_sales_line_id,NULL, fnd_api.g_miss_num,
1932: p_rec.trx_sales_line_id),
1933: DECODE(p_rec.quantity,NULL, fnd_api.g_miss_num,
1934: p_rec.quantity),
1935: DECODE(p_rec.source_trx_number,NULL, fnd_api.g_miss_char,
1936: p_rec.source_trx_number),
1937: DECODE(p_rec.discount_percentage,NULL, fnd_api.g_miss_num,

Line 1935: DECODE(p_rec.source_trx_number,NULL, fnd_api.g_miss_char,

1931: DECODE(p_rec.trx_sales_line_id,NULL, fnd_api.g_miss_num,
1932: p_rec.trx_sales_line_id),
1933: DECODE(p_rec.quantity,NULL, fnd_api.g_miss_num,
1934: p_rec.quantity),
1935: DECODE(p_rec.source_trx_number,NULL, fnd_api.g_miss_char,
1936: p_rec.source_trx_number),
1937: DECODE(p_rec.discount_percentage,NULL, fnd_api.g_miss_num,
1938: p_rec.discount_percentage),
1939: DECODE(p_rec.margin_percentage,NULL, fnd_api.g_miss_num,

Line 1937: DECODE(p_rec.discount_percentage,NULL, fnd_api.g_miss_num,

1933: DECODE(p_rec.quantity,NULL, fnd_api.g_miss_num,
1934: p_rec.quantity),
1935: DECODE(p_rec.source_trx_number,NULL, fnd_api.g_miss_char,
1936: p_rec.source_trx_number),
1937: DECODE(p_rec.discount_percentage,NULL, fnd_api.g_miss_num,
1938: p_rec.discount_percentage),
1939: DECODE(p_rec.margin_percentage,NULL, fnd_api.g_miss_num,
1940: p_rec.margin_percentage),
1941: DECODE(p_rec.forecast_id,NULL, fnd_api.g_miss_num,

Line 1939: DECODE(p_rec.margin_percentage,NULL, fnd_api.g_miss_num,

1935: DECODE(p_rec.source_trx_number,NULL, fnd_api.g_miss_char,
1936: p_rec.source_trx_number),
1937: DECODE(p_rec.discount_percentage,NULL, fnd_api.g_miss_num,
1938: p_rec.discount_percentage),
1939: DECODE(p_rec.margin_percentage,NULL, fnd_api.g_miss_num,
1940: p_rec.margin_percentage),
1941: DECODE(p_rec.forecast_id,NULL, fnd_api.g_miss_num,
1942: p_rec.forecast_id),
1943: DECODE(p_rec.upside_quantity,NULL, fnd_api.g_miss_num,

Line 1941: DECODE(p_rec.forecast_id,NULL, fnd_api.g_miss_num,

1937: DECODE(p_rec.discount_percentage,NULL, fnd_api.g_miss_num,
1938: p_rec.discount_percentage),
1939: DECODE(p_rec.margin_percentage,NULL, fnd_api.g_miss_num,
1940: p_rec.margin_percentage),
1941: DECODE(p_rec.forecast_id,NULL, fnd_api.g_miss_num,
1942: p_rec.forecast_id),
1943: DECODE(p_rec.upside_quantity,NULL, fnd_api.g_miss_num,
1944: p_rec.upside_quantity),
1945: DECODE(p_rec.upside_amount,NULL, fnd_api.g_miss_num,

Line 1943: DECODE(p_rec.upside_quantity,NULL, fnd_api.g_miss_num,

1939: DECODE(p_rec.margin_percentage,NULL, fnd_api.g_miss_num,
1940: p_rec.margin_percentage),
1941: DECODE(p_rec.forecast_id,NULL, fnd_api.g_miss_num,
1942: p_rec.forecast_id),
1943: DECODE(p_rec.upside_quantity,NULL, fnd_api.g_miss_num,
1944: p_rec.upside_quantity),
1945: DECODE(p_rec.upside_amount,NULL, fnd_api.g_miss_num,
1946: p_rec.upside_amount),
1947: DECODE(p_rec.uom_code,NULL, fnd_api.g_miss_char,

Line 1945: DECODE(p_rec.upside_amount,NULL, fnd_api.g_miss_num,

1941: DECODE(p_rec.forecast_id,NULL, fnd_api.g_miss_num,
1942: p_rec.forecast_id),
1943: DECODE(p_rec.upside_quantity,NULL, fnd_api.g_miss_num,
1944: p_rec.upside_quantity),
1945: DECODE(p_rec.upside_amount,NULL, fnd_api.g_miss_num,
1946: p_rec.upside_amount),
1947: DECODE(p_rec.uom_code,NULL, fnd_api.g_miss_char,
1948: p_rec.uom_code),
1949: DECODE(p_rec.source_trx_id,NULL, fnd_api.g_miss_num,

Line 1947: DECODE(p_rec.uom_code,NULL, fnd_api.g_miss_char,

1943: DECODE(p_rec.upside_quantity,NULL, fnd_api.g_miss_num,
1944: p_rec.upside_quantity),
1945: DECODE(p_rec.upside_amount,NULL, fnd_api.g_miss_num,
1946: p_rec.upside_amount),
1947: DECODE(p_rec.uom_code,NULL, fnd_api.g_miss_char,
1948: p_rec.uom_code),
1949: DECODE(p_rec.source_trx_id,NULL, fnd_api.g_miss_num,
1950: p_rec.source_trx_id),
1951: DECODE(p_rec.source_trx_line_id,NULL, fnd_api.g_miss_num,

Line 1949: DECODE(p_rec.source_trx_id,NULL, fnd_api.g_miss_num,

1945: DECODE(p_rec.upside_amount,NULL, fnd_api.g_miss_num,
1946: p_rec.upside_amount),
1947: DECODE(p_rec.uom_code,NULL, fnd_api.g_miss_char,
1948: p_rec.uom_code),
1949: DECODE(p_rec.source_trx_id,NULL, fnd_api.g_miss_num,
1950: p_rec.source_trx_id),
1951: DECODE(p_rec.source_trx_line_id,NULL, fnd_api.g_miss_num,
1952: p_rec.source_trx_line_id),
1953: DECODE(p_rec.source_trx_sales_line_id,NULL, fnd_api.g_miss_num,

Line 1951: DECODE(p_rec.source_trx_line_id,NULL, fnd_api.g_miss_num,

1947: DECODE(p_rec.uom_code,NULL, fnd_api.g_miss_char,
1948: p_rec.uom_code),
1949: DECODE(p_rec.source_trx_id,NULL, fnd_api.g_miss_num,
1950: p_rec.source_trx_id),
1951: DECODE(p_rec.source_trx_line_id,NULL, fnd_api.g_miss_num,
1952: p_rec.source_trx_line_id),
1953: DECODE(p_rec.source_trx_sales_line_id,NULL, fnd_api.g_miss_num,
1954: p_rec.source_trx_sales_line_id),
1955: DECODE(p_rec.customer_id, NULL, fnd_api.g_miss_num, p_rec.customer_id),

Line 1953: DECODE(p_rec.source_trx_sales_line_id,NULL, fnd_api.g_miss_num,

1949: DECODE(p_rec.source_trx_id,NULL, fnd_api.g_miss_num,
1950: p_rec.source_trx_id),
1951: DECODE(p_rec.source_trx_line_id,NULL, fnd_api.g_miss_num,
1952: p_rec.source_trx_line_id),
1953: DECODE(p_rec.source_trx_sales_line_id,NULL, fnd_api.g_miss_num,
1954: p_rec.source_trx_sales_line_id),
1955: DECODE(p_rec.customer_id, NULL, fnd_api.g_miss_num, p_rec.customer_id),
1956: DECODE(p_rec.inventory_item_id, NULL, fnd_api.g_miss_num,p_rec.inventory_item_id),
1957: DECODE(p_rec.order_number,NULL, fnd_api.g_miss_num,

Line 1955: DECODE(p_rec.customer_id, NULL, fnd_api.g_miss_num, p_rec.customer_id),

1951: DECODE(p_rec.source_trx_line_id,NULL, fnd_api.g_miss_num,
1952: p_rec.source_trx_line_id),
1953: DECODE(p_rec.source_trx_sales_line_id,NULL, fnd_api.g_miss_num,
1954: p_rec.source_trx_sales_line_id),
1955: DECODE(p_rec.customer_id, NULL, fnd_api.g_miss_num, p_rec.customer_id),
1956: DECODE(p_rec.inventory_item_id, NULL, fnd_api.g_miss_num,p_rec.inventory_item_id),
1957: DECODE(p_rec.order_number,NULL, fnd_api.g_miss_num,
1958: p_rec.order_number),
1959: DECODE(p_rec.order_date,NULL, fnd_api.g_miss_date,

Line 1956: DECODE(p_rec.inventory_item_id, NULL, fnd_api.g_miss_num,p_rec.inventory_item_id),

1952: p_rec.source_trx_line_id),
1953: DECODE(p_rec.source_trx_sales_line_id,NULL, fnd_api.g_miss_num,
1954: p_rec.source_trx_sales_line_id),
1955: DECODE(p_rec.customer_id, NULL, fnd_api.g_miss_num, p_rec.customer_id),
1956: DECODE(p_rec.inventory_item_id, NULL, fnd_api.g_miss_num,p_rec.inventory_item_id),
1957: DECODE(p_rec.order_number,NULL, fnd_api.g_miss_num,
1958: p_rec.order_number),
1959: DECODE(p_rec.order_date,NULL, fnd_api.g_miss_date,
1960: p_rec.order_date),

Line 1957: DECODE(p_rec.order_number,NULL, fnd_api.g_miss_num,

1953: DECODE(p_rec.source_trx_sales_line_id,NULL, fnd_api.g_miss_num,
1954: p_rec.source_trx_sales_line_id),
1955: DECODE(p_rec.customer_id, NULL, fnd_api.g_miss_num, p_rec.customer_id),
1956: DECODE(p_rec.inventory_item_id, NULL, fnd_api.g_miss_num,p_rec.inventory_item_id),
1957: DECODE(p_rec.order_number,NULL, fnd_api.g_miss_num,
1958: p_rec.order_number),
1959: DECODE(p_rec.order_date,NULL, fnd_api.g_miss_date,
1960: p_rec.order_date),
1961: DECODE(p_rec.invoice_number,NULL, fnd_api.g_miss_char,

Line 1959: DECODE(p_rec.order_date,NULL, fnd_api.g_miss_date,

1955: DECODE(p_rec.customer_id, NULL, fnd_api.g_miss_num, p_rec.customer_id),
1956: DECODE(p_rec.inventory_item_id, NULL, fnd_api.g_miss_num,p_rec.inventory_item_id),
1957: DECODE(p_rec.order_number,NULL, fnd_api.g_miss_num,
1958: p_rec.order_number),
1959: DECODE(p_rec.order_date,NULL, fnd_api.g_miss_date,
1960: p_rec.order_date),
1961: DECODE(p_rec.invoice_number,NULL, fnd_api.g_miss_char,
1962: p_rec.invoice_number),
1963: DECODE(p_rec.invoice_date,NULL, fnd_api.g_miss_date,

Line 1961: DECODE(p_rec.invoice_number,NULL, fnd_api.g_miss_char,

1957: DECODE(p_rec.order_number,NULL, fnd_api.g_miss_num,
1958: p_rec.order_number),
1959: DECODE(p_rec.order_date,NULL, fnd_api.g_miss_date,
1960: p_rec.order_date),
1961: DECODE(p_rec.invoice_number,NULL, fnd_api.g_miss_char,
1962: p_rec.invoice_number),
1963: DECODE(p_rec.invoice_date,NULL, fnd_api.g_miss_date,
1964: p_rec.invoice_date),
1965: DECODE(p_rec.bill_to_address_id,NULL, fnd_api.g_miss_num,

Line 1963: DECODE(p_rec.invoice_date,NULL, fnd_api.g_miss_date,

1959: DECODE(p_rec.order_date,NULL, fnd_api.g_miss_date,
1960: p_rec.order_date),
1961: DECODE(p_rec.invoice_number,NULL, fnd_api.g_miss_char,
1962: p_rec.invoice_number),
1963: DECODE(p_rec.invoice_date,NULL, fnd_api.g_miss_date,
1964: p_rec.invoice_date),
1965: DECODE(p_rec.bill_to_address_id,NULL, fnd_api.g_miss_num,
1966: p_rec.bill_to_address_id),
1967: DECODE(p_rec.ship_to_address_id,NULL, fnd_api.g_miss_num,

Line 1965: DECODE(p_rec.bill_to_address_id,NULL, fnd_api.g_miss_num,

1961: DECODE(p_rec.invoice_number,NULL, fnd_api.g_miss_char,
1962: p_rec.invoice_number),
1963: DECODE(p_rec.invoice_date,NULL, fnd_api.g_miss_date,
1964: p_rec.invoice_date),
1965: DECODE(p_rec.bill_to_address_id,NULL, fnd_api.g_miss_num,
1966: p_rec.bill_to_address_id),
1967: DECODE(p_rec.ship_to_address_id,NULL, fnd_api.g_miss_num,
1968: p_rec.ship_to_address_id),
1969: DECODE(p_rec.bill_to_contact_id,NULL, fnd_api.g_miss_num,

Line 1967: DECODE(p_rec.ship_to_address_id,NULL, fnd_api.g_miss_num,

1963: DECODE(p_rec.invoice_date,NULL, fnd_api.g_miss_date,
1964: p_rec.invoice_date),
1965: DECODE(p_rec.bill_to_address_id,NULL, fnd_api.g_miss_num,
1966: p_rec.bill_to_address_id),
1967: DECODE(p_rec.ship_to_address_id,NULL, fnd_api.g_miss_num,
1968: p_rec.ship_to_address_id),
1969: DECODE(p_rec.bill_to_contact_id,NULL, fnd_api.g_miss_num,
1970: p_rec.bill_to_contact_id),
1971: DECODE(p_rec.ship_to_contact_id,NULL, fnd_api.g_miss_num,

Line 1969: DECODE(p_rec.bill_to_contact_id,NULL, fnd_api.g_miss_num,

1965: DECODE(p_rec.bill_to_address_id,NULL, fnd_api.g_miss_num,
1966: p_rec.bill_to_address_id),
1967: DECODE(p_rec.ship_to_address_id,NULL, fnd_api.g_miss_num,
1968: p_rec.ship_to_address_id),
1969: DECODE(p_rec.bill_to_contact_id,NULL, fnd_api.g_miss_num,
1970: p_rec.bill_to_contact_id),
1971: DECODE(p_rec.ship_to_contact_id,NULL, fnd_api.g_miss_num,
1972: p_rec.ship_to_contact_id),
1973: DECODE(p_rec.adj_comm_lines_api_id,NULL, fnd_api.g_miss_num,

Line 1971: DECODE(p_rec.ship_to_contact_id,NULL, fnd_api.g_miss_num,

1967: DECODE(p_rec.ship_to_address_id,NULL, fnd_api.g_miss_num,
1968: p_rec.ship_to_address_id),
1969: DECODE(p_rec.bill_to_contact_id,NULL, fnd_api.g_miss_num,
1970: p_rec.bill_to_contact_id),
1971: DECODE(p_rec.ship_to_contact_id,NULL, fnd_api.g_miss_num,
1972: p_rec.ship_to_contact_id),
1973: DECODE(p_rec.adj_comm_lines_api_id,NULL, fnd_api.g_miss_num,
1974: p_rec.adj_comm_lines_api_id),
1975: DECODE(p_rec.adjust_date,NULL, fnd_api.g_miss_date,

Line 1973: DECODE(p_rec.adj_comm_lines_api_id,NULL, fnd_api.g_miss_num,

1969: DECODE(p_rec.bill_to_contact_id,NULL, fnd_api.g_miss_num,
1970: p_rec.bill_to_contact_id),
1971: DECODE(p_rec.ship_to_contact_id,NULL, fnd_api.g_miss_num,
1972: p_rec.ship_to_contact_id),
1973: DECODE(p_rec.adj_comm_lines_api_id,NULL, fnd_api.g_miss_num,
1974: p_rec.adj_comm_lines_api_id),
1975: DECODE(p_rec.adjust_date,NULL, fnd_api.g_miss_date,
1976: p_rec.adjust_date),
1977: DECODE(p_rec.adjusted_by,NULL, fnd_api.g_miss_char,

Line 1975: DECODE(p_rec.adjust_date,NULL, fnd_api.g_miss_date,

1971: DECODE(p_rec.ship_to_contact_id,NULL, fnd_api.g_miss_num,
1972: p_rec.ship_to_contact_id),
1973: DECODE(p_rec.adj_comm_lines_api_id,NULL, fnd_api.g_miss_num,
1974: p_rec.adj_comm_lines_api_id),
1975: DECODE(p_rec.adjust_date,NULL, fnd_api.g_miss_date,
1976: p_rec.adjust_date),
1977: DECODE(p_rec.adjusted_by,NULL, fnd_api.g_miss_char,
1978: p_rec.adjusted_by),
1979: DECODE(p_rec.revenue_type,NULL, fnd_api.g_miss_char,

Line 1977: DECODE(p_rec.adjusted_by,NULL, fnd_api.g_miss_char,

1973: DECODE(p_rec.adj_comm_lines_api_id,NULL, fnd_api.g_miss_num,
1974: p_rec.adj_comm_lines_api_id),
1975: DECODE(p_rec.adjust_date,NULL, fnd_api.g_miss_date,
1976: p_rec.adjust_date),
1977: DECODE(p_rec.adjusted_by,NULL, fnd_api.g_miss_char,
1978: p_rec.adjusted_by),
1979: DECODE(p_rec.revenue_type,NULL, fnd_api.g_miss_char,
1980: p_rec.revenue_type),
1981: DECODE(p_rec.adjust_rollup_flag,NULL, fnd_api.g_miss_char,

Line 1979: DECODE(p_rec.revenue_type,NULL, fnd_api.g_miss_char,

1975: DECODE(p_rec.adjust_date,NULL, fnd_api.g_miss_date,
1976: p_rec.adjust_date),
1977: DECODE(p_rec.adjusted_by,NULL, fnd_api.g_miss_char,
1978: p_rec.adjusted_by),
1979: DECODE(p_rec.revenue_type,NULL, fnd_api.g_miss_char,
1980: p_rec.revenue_type),
1981: DECODE(p_rec.adjust_rollup_flag,NULL, fnd_api.g_miss_char,
1982: p_rec.adjust_rollup_flag),
1983: DECODE(p_rec.adjust_comments,NULL, fnd_api.g_miss_char,

Line 1981: DECODE(p_rec.adjust_rollup_flag,NULL, fnd_api.g_miss_char,

1977: DECODE(p_rec.adjusted_by,NULL, fnd_api.g_miss_char,
1978: p_rec.adjusted_by),
1979: DECODE(p_rec.revenue_type,NULL, fnd_api.g_miss_char,
1980: p_rec.revenue_type),
1981: DECODE(p_rec.adjust_rollup_flag,NULL, fnd_api.g_miss_char,
1982: p_rec.adjust_rollup_flag),
1983: DECODE(p_rec.adjust_comments,NULL, fnd_api.g_miss_char,
1984: p_rec.adjust_comments),
1985: NVL(DECODE(p_rec.adjust_status,NULL, fnd_api.g_miss_char,

Line 1983: DECODE(p_rec.adjust_comments,NULL, fnd_api.g_miss_char,

1979: DECODE(p_rec.revenue_type,NULL, fnd_api.g_miss_char,
1980: p_rec.revenue_type),
1981: DECODE(p_rec.adjust_rollup_flag,NULL, fnd_api.g_miss_char,
1982: p_rec.adjust_rollup_flag),
1983: DECODE(p_rec.adjust_comments,NULL, fnd_api.g_miss_char,
1984: p_rec.adjust_comments),
1985: NVL(DECODE(p_rec.adjust_status,NULL, fnd_api.g_miss_char,
1986: p_rec.adjust_status),'NEW'),
1987: DECODE(p_rec.line_number,NULL, fnd_api.g_miss_num,

Line 1985: NVL(DECODE(p_rec.adjust_status,NULL, fnd_api.g_miss_char,

1981: DECODE(p_rec.adjust_rollup_flag,NULL, fnd_api.g_miss_char,
1982: p_rec.adjust_rollup_flag),
1983: DECODE(p_rec.adjust_comments,NULL, fnd_api.g_miss_char,
1984: p_rec.adjust_comments),
1985: NVL(DECODE(p_rec.adjust_status,NULL, fnd_api.g_miss_char,
1986: p_rec.adjust_status),'NEW'),
1987: DECODE(p_rec.line_number,NULL, fnd_api.g_miss_num,
1988: p_rec.line_number),
1989: DECODE(p_rec.reason_code,NULL, fnd_api.g_miss_char,

Line 1987: DECODE(p_rec.line_number,NULL, fnd_api.g_miss_num,

1983: DECODE(p_rec.adjust_comments,NULL, fnd_api.g_miss_char,
1984: p_rec.adjust_comments),
1985: NVL(DECODE(p_rec.adjust_status,NULL, fnd_api.g_miss_char,
1986: p_rec.adjust_status),'NEW'),
1987: DECODE(p_rec.line_number,NULL, fnd_api.g_miss_num,
1988: p_rec.line_number),
1989: DECODE(p_rec.reason_code,NULL, fnd_api.g_miss_char,
1990: p_rec.reason_code),
1991: DECODE(p_rec.attribute_category,NULL, fnd_api.g_miss_char,

Line 1989: DECODE(p_rec.reason_code,NULL, fnd_api.g_miss_char,

1985: NVL(DECODE(p_rec.adjust_status,NULL, fnd_api.g_miss_char,
1986: p_rec.adjust_status),'NEW'),
1987: DECODE(p_rec.line_number,NULL, fnd_api.g_miss_num,
1988: p_rec.line_number),
1989: DECODE(p_rec.reason_code,NULL, fnd_api.g_miss_char,
1990: p_rec.reason_code),
1991: DECODE(p_rec.attribute_category,NULL, fnd_api.g_miss_char,
1992: p_rec.attribute_category),
1993: DECODE(p_rec.type,NULL, fnd_api.g_miss_char,

Line 1991: DECODE(p_rec.attribute_category,NULL, fnd_api.g_miss_char,

1987: DECODE(p_rec.line_number,NULL, fnd_api.g_miss_num,
1988: p_rec.line_number),
1989: DECODE(p_rec.reason_code,NULL, fnd_api.g_miss_char,
1990: p_rec.reason_code),
1991: DECODE(p_rec.attribute_category,NULL, fnd_api.g_miss_char,
1992: p_rec.attribute_category),
1993: DECODE(p_rec.type,NULL, fnd_api.g_miss_char,
1994: p_rec.type),
1995: DECODE(p_rec.pre_processed_code,NULL, fnd_api.g_miss_char,

Line 1993: DECODE(p_rec.type,NULL, fnd_api.g_miss_char,

1989: DECODE(p_rec.reason_code,NULL, fnd_api.g_miss_char,
1990: p_rec.reason_code),
1991: DECODE(p_rec.attribute_category,NULL, fnd_api.g_miss_char,
1992: p_rec.attribute_category),
1993: DECODE(p_rec.type,NULL, fnd_api.g_miss_char,
1994: p_rec.type),
1995: DECODE(p_rec.pre_processed_code,NULL, fnd_api.g_miss_char,
1996: p_rec.pre_processed_code),
1997: DECODE(p_rec.quota_id,NULL, fnd_api.g_miss_num,

Line 1995: DECODE(p_rec.pre_processed_code,NULL, fnd_api.g_miss_char,

1991: DECODE(p_rec.attribute_category,NULL, fnd_api.g_miss_char,
1992: p_rec.attribute_category),
1993: DECODE(p_rec.type,NULL, fnd_api.g_miss_char,
1994: p_rec.type),
1995: DECODE(p_rec.pre_processed_code,NULL, fnd_api.g_miss_char,
1996: p_rec.pre_processed_code),
1997: DECODE(p_rec.quota_id,NULL, fnd_api.g_miss_num,
1998: p_rec.quota_id),
1999: DECODE(p_rec.srp_plan_assign_id,NULL, fnd_api.g_miss_num,

Line 1997: DECODE(p_rec.quota_id,NULL, fnd_api.g_miss_num,

1993: DECODE(p_rec.type,NULL, fnd_api.g_miss_char,
1994: p_rec.type),
1995: DECODE(p_rec.pre_processed_code,NULL, fnd_api.g_miss_char,
1996: p_rec.pre_processed_code),
1997: DECODE(p_rec.quota_id,NULL, fnd_api.g_miss_num,
1998: p_rec.quota_id),
1999: DECODE(p_rec.srp_plan_assign_id,NULL, fnd_api.g_miss_num,
2000: p_rec.srp_plan_assign_id),
2001: DECODE(p_rec.role_id,NULL, fnd_api.g_miss_num,

Line 1999: DECODE(p_rec.srp_plan_assign_id,NULL, fnd_api.g_miss_num,

1995: DECODE(p_rec.pre_processed_code,NULL, fnd_api.g_miss_char,
1996: p_rec.pre_processed_code),
1997: DECODE(p_rec.quota_id,NULL, fnd_api.g_miss_num,
1998: p_rec.quota_id),
1999: DECODE(p_rec.srp_plan_assign_id,NULL, fnd_api.g_miss_num,
2000: p_rec.srp_plan_assign_id),
2001: DECODE(p_rec.role_id,NULL, fnd_api.g_miss_num,
2002: p_rec.role_id),
2003: DECODE(p_rec.comp_group_id,NULL, fnd_api.g_miss_num,

Line 2001: DECODE(p_rec.role_id,NULL, fnd_api.g_miss_num,

1997: DECODE(p_rec.quota_id,NULL, fnd_api.g_miss_num,
1998: p_rec.quota_id),
1999: DECODE(p_rec.srp_plan_assign_id,NULL, fnd_api.g_miss_num,
2000: p_rec.srp_plan_assign_id),
2001: DECODE(p_rec.role_id,NULL, fnd_api.g_miss_num,
2002: p_rec.role_id),
2003: DECODE(p_rec.comp_group_id,NULL, fnd_api.g_miss_num,
2004: p_rec.comp_group_id),
2005: DECODE(p_rec.commission_amount,NULL, fnd_api.g_miss_num,

Line 2003: DECODE(p_rec.comp_group_id,NULL, fnd_api.g_miss_num,

1999: DECODE(p_rec.srp_plan_assign_id,NULL, fnd_api.g_miss_num,
2000: p_rec.srp_plan_assign_id),
2001: DECODE(p_rec.role_id,NULL, fnd_api.g_miss_num,
2002: p_rec.role_id),
2003: DECODE(p_rec.comp_group_id,NULL, fnd_api.g_miss_num,
2004: p_rec.comp_group_id),
2005: DECODE(p_rec.commission_amount,NULL, fnd_api.g_miss_num,
2006: p_rec.commission_amount),
2007: DECODE(p_rec.sales_channel,NULL, fnd_api.g_miss_char,

Line 2005: DECODE(p_rec.commission_amount,NULL, fnd_api.g_miss_num,

2001: DECODE(p_rec.role_id,NULL, fnd_api.g_miss_num,
2002: p_rec.role_id),
2003: DECODE(p_rec.comp_group_id,NULL, fnd_api.g_miss_num,
2004: p_rec.comp_group_id),
2005: DECODE(p_rec.commission_amount,NULL, fnd_api.g_miss_num,
2006: p_rec.commission_amount),
2007: DECODE(p_rec.sales_channel,NULL, fnd_api.g_miss_char,
2008: p_rec.sales_channel),
2009: DECODE(p_rec.split_pct,NULL, fnd_api.g_miss_num,

Line 2007: DECODE(p_rec.sales_channel,NULL, fnd_api.g_miss_char,

2003: DECODE(p_rec.comp_group_id,NULL, fnd_api.g_miss_num,
2004: p_rec.comp_group_id),
2005: DECODE(p_rec.commission_amount,NULL, fnd_api.g_miss_num,
2006: p_rec.commission_amount),
2007: DECODE(p_rec.sales_channel,NULL, fnd_api.g_miss_char,
2008: p_rec.sales_channel),
2009: DECODE(p_rec.split_pct,NULL, fnd_api.g_miss_num,
2010: p_rec.split_pct),
2011: DECODE(p_rec.split_status,NULL, fnd_api.g_miss_char,

Line 2009: DECODE(p_rec.split_pct,NULL, fnd_api.g_miss_num,

2005: DECODE(p_rec.commission_amount,NULL, fnd_api.g_miss_num,
2006: p_rec.commission_amount),
2007: DECODE(p_rec.sales_channel,NULL, fnd_api.g_miss_char,
2008: p_rec.sales_channel),
2009: DECODE(p_rec.split_pct,NULL, fnd_api.g_miss_num,
2010: p_rec.split_pct),
2011: DECODE(p_rec.split_status,NULL, fnd_api.g_miss_char,
2012: p_rec.split_status),
2013: DECODE(p_rec.org_id,NULL, fnd_api.g_miss_num,

Line 2011: DECODE(p_rec.split_status,NULL, fnd_api.g_miss_char,

2007: DECODE(p_rec.sales_channel,NULL, fnd_api.g_miss_char,
2008: p_rec.sales_channel),
2009: DECODE(p_rec.split_pct,NULL, fnd_api.g_miss_num,
2010: p_rec.split_pct),
2011: DECODE(p_rec.split_status,NULL, fnd_api.g_miss_char,
2012: p_rec.split_status),
2013: DECODE(p_rec.org_id,NULL, fnd_api.g_miss_num,
2014: p_rec.org_id),
2015: DECODE(p_rec.terr_id,NULL, fnd_api.g_miss_num,

Line 2013: DECODE(p_rec.org_id,NULL, fnd_api.g_miss_num,

2009: DECODE(p_rec.split_pct,NULL, fnd_api.g_miss_num,
2010: p_rec.split_pct),
2011: DECODE(p_rec.split_status,NULL, fnd_api.g_miss_char,
2012: p_rec.split_status),
2013: DECODE(p_rec.org_id,NULL, fnd_api.g_miss_num,
2014: p_rec.org_id),
2015: DECODE(p_rec.terr_id,NULL, fnd_api.g_miss_num,
2016: p_rec.terr_id),
2017: NVL(DECODE(p_rec.preserve_credit_override_flag,NULL, fnd_api.g_miss_char,

Line 2015: DECODE(p_rec.terr_id,NULL, fnd_api.g_miss_num,

2011: DECODE(p_rec.split_status,NULL, fnd_api.g_miss_char,
2012: p_rec.split_status),
2013: DECODE(p_rec.org_id,NULL, fnd_api.g_miss_num,
2014: p_rec.org_id),
2015: DECODE(p_rec.terr_id,NULL, fnd_api.g_miss_num,
2016: p_rec.terr_id),
2017: NVL(DECODE(p_rec.preserve_credit_override_flag,NULL, fnd_api.g_miss_char,
2018: p_rec.preserve_credit_override_flag),'N')
2019: INTO x_api_rec.direct_salesrep_id,x_api_rec.processed_date,

Line 2017: NVL(DECODE(p_rec.preserve_credit_override_flag,NULL, fnd_api.g_miss_char,

2013: DECODE(p_rec.org_id,NULL, fnd_api.g_miss_num,
2014: p_rec.org_id),
2015: DECODE(p_rec.terr_id,NULL, fnd_api.g_miss_num,
2016: p_rec.terr_id),
2017: NVL(DECODE(p_rec.preserve_credit_override_flag,NULL, fnd_api.g_miss_char,
2018: p_rec.preserve_credit_override_flag),'N')
2019: INTO x_api_rec.direct_salesrep_id,x_api_rec.processed_date,
2020: x_api_rec.processed_period_id,x_api_rec.transaction_amount,
2021: x_api_rec.trx_type,x_api_rec.revenue_class_id,