DBA Data[Home] [Help]

APPS.OKE_AGREEMENT_PVT dependencies on PA_INTERFACE_UTILS_PUB

Line 1362: IF (p_agreement_in_rec_new.revenue_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1358: p_agreement_in_rec_new.amount := l_agreement_row.amount + nvl(p_agreement_in_rec.amount, 0);
1359: p_agreement_amount := l_agreement_row.amount;
1360: p_agreement_in_rec_new.agreement_currency_code := l_agreement_row.agreement_currency_code;
1361:
1362: IF (p_agreement_in_rec_new.revenue_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1363: p_agreement_in_rec_new.revenue_limit_flag := l_agreement_row.revenue_limit_flag;
1364: END IF;
1365:
1366: IF (p_agreement_in_rec_new.invoice_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 1366: IF (p_agreement_in_rec_new.invoice_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1362: IF (p_agreement_in_rec_new.revenue_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1363: p_agreement_in_rec_new.revenue_limit_flag := l_agreement_row.revenue_limit_flag;
1364: END IF;
1365:
1366: IF (p_agreement_in_rec_new.invoice_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1367: p_agreement_in_rec_new.invoice_limit_flag := l_agreement_row.invoice_limit_flag;
1368: END IF;
1369:
1370: IF (p_agreement_in_rec_new.term_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

Line 1370: IF (p_agreement_in_rec_new.term_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1366: IF (p_agreement_in_rec_new.invoice_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1367: p_agreement_in_rec_new.invoice_limit_flag := l_agreement_row.invoice_limit_flag;
1368: END IF;
1369:
1370: IF (p_agreement_in_rec_new.term_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1371: p_agreement_in_rec_new.term_id := l_agreement_row.term_id;
1372: END IF;
1373:
1374: IF (p_agreement_in_rec_new.owning_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

Line 1374: IF (p_agreement_in_rec_new.owning_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1370: IF (p_agreement_in_rec_new.term_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1371: p_agreement_in_rec_new.term_id := l_agreement_row.term_id;
1372: END IF;
1373:
1374: IF (p_agreement_in_rec_new.owning_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1375: p_agreement_in_rec_new.owning_organization_id := l_agreement_row.owning_organization_id;
1376: END IF;
1377:
1378: IF (p_agreement_in_rec_new.owned_by_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

Line 1378: IF (p_agreement_in_rec_new.owned_by_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1374: IF (p_agreement_in_rec_new.owning_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1375: p_agreement_in_rec_new.owning_organization_id := l_agreement_row.owning_organization_id;
1376: END IF;
1377:
1378: IF (p_agreement_in_rec_new.owned_by_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1379: p_agreement_in_rec_new.owned_by_person_id := l_agreement_row.owned_by_person_id;
1380: END IF;
1381: /*
1382: IF (p_agreement_in_rec_new.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 1382: IF (p_agreement_in_rec_new.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1378: IF (p_agreement_in_rec_new.owned_by_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1379: p_agreement_in_rec_new.owned_by_person_id := l_agreement_row.owned_by_person_id;
1380: END IF;
1381: /*
1382: IF (p_agreement_in_rec_new.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1383: p_agreement_in_rec_new.attribute_category := l_agreement_row.attribute_category;
1384: END IF;
1385:
1386: IF (p_agreement_in_rec_new.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 1386: IF (p_agreement_in_rec_new.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1382: IF (p_agreement_in_rec_new.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1383: p_agreement_in_rec_new.attribute_category := l_agreement_row.attribute_category;
1384: END IF;
1385:
1386: IF (p_agreement_in_rec_new.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1387: p_agreement_in_rec_new.attribute1 := l_agreement_row.attribute1;
1388: END IF;
1389:
1390: IF (p_agreement_in_rec_new.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 1390: IF (p_agreement_in_rec_new.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1386: IF (p_agreement_in_rec_new.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1387: p_agreement_in_rec_new.attribute1 := l_agreement_row.attribute1;
1388: END IF;
1389:
1390: IF (p_agreement_in_rec_new.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1391: p_agreement_in_rec_new.attribute2 := l_agreement_row.attribute2;
1392: END IF;
1393:
1394: IF (p_agreement_in_rec_new.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 1394: IF (p_agreement_in_rec_new.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1390: IF (p_agreement_in_rec_new.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1391: p_agreement_in_rec_new.attribute2 := l_agreement_row.attribute2;
1392: END IF;
1393:
1394: IF (p_agreement_in_rec_new.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1395: p_agreement_in_rec_new.attribute3 := l_agreement_row.attribute3;
1396: END IF;
1397:
1398: IF (p_agreement_in_rec_new.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 1398: IF (p_agreement_in_rec_new.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1394: IF (p_agreement_in_rec_new.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1395: p_agreement_in_rec_new.attribute3 := l_agreement_row.attribute3;
1396: END IF;
1397:
1398: IF (p_agreement_in_rec_new.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1399: p_agreement_in_rec_new.attribute4 := l_agreement_row.attribute4;
1400: END IF;
1401:
1402: IF (p_agreement_in_rec_new.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 1402: IF (p_agreement_in_rec_new.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1398: IF (p_agreement_in_rec_new.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1399: p_agreement_in_rec_new.attribute4 := l_agreement_row.attribute4;
1400: END IF;
1401:
1402: IF (p_agreement_in_rec_new.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1403: p_agreement_in_rec_new.attribute5 := l_agreement_row.attribute5;
1404: END IF;
1405:
1406: IF (p_agreement_in_rec_new.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 1406: IF (p_agreement_in_rec_new.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1402: IF (p_agreement_in_rec_new.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1403: p_agreement_in_rec_new.attribute5 := l_agreement_row.attribute5;
1404: END IF;
1405:
1406: IF (p_agreement_in_rec_new.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1407: p_agreement_in_rec_new.attribute6 := l_agreement_row.attribute6;
1408: END IF;
1409:
1410: IF (p_agreement_in_rec_new.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 1410: IF (p_agreement_in_rec_new.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1406: IF (p_agreement_in_rec_new.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1407: p_agreement_in_rec_new.attribute6 := l_agreement_row.attribute6;
1408: END IF;
1409:
1410: IF (p_agreement_in_rec_new.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1411: p_agreement_in_rec_new.attribute7 := l_agreement_row.attribute7;
1412: END IF;
1413:
1414: IF (p_agreement_in_rec_new.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 1414: IF (p_agreement_in_rec_new.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1410: IF (p_agreement_in_rec_new.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1411: p_agreement_in_rec_new.attribute7 := l_agreement_row.attribute7;
1412: END IF;
1413:
1414: IF (p_agreement_in_rec_new.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1415: p_agreement_in_rec_new.attribute8 := l_agreement_row.attribute8;
1416: END IF;
1417:
1418: IF (p_agreement_in_rec_new.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 1418: IF (p_agreement_in_rec_new.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1414: IF (p_agreement_in_rec_new.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1415: p_agreement_in_rec_new.attribute8 := l_agreement_row.attribute8;
1416: END IF;
1417:
1418: IF (p_agreement_in_rec_new.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1419: p_agreement_in_rec_new.attribute9 := l_agreement_row.attribute9;
1420: END IF;
1421:
1422: IF (p_agreement_in_rec_new.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 1422: IF (p_agreement_in_rec_new.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1418: IF (p_agreement_in_rec_new.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1419: p_agreement_in_rec_new.attribute9 := l_agreement_row.attribute9;
1420: END IF;
1421:
1422: IF (p_agreement_in_rec_new.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1423: p_agreement_in_rec_new.attribute10 := l_agreement_row.attribute10;
1424: END IF;
1425: */
1426: IF (p_agreement_in_rec_new.template_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 1426: IF (p_agreement_in_rec_new.template_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1422: IF (p_agreement_in_rec_new.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1423: p_agreement_in_rec_new.attribute10 := l_agreement_row.attribute10;
1424: END IF;
1425: */
1426: IF (p_agreement_in_rec_new.template_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1427: p_agreement_in_rec_new.template_flag := l_agreement_row.template_flag;
1428: END IF;
1429:
1430: EXCEPTION