DBA Data[Home] [Help]

APPS.OKE_AGREEMENT_PVT dependencies on PA_INTERFACE_UTILS_PUB

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

1373: p_agreement_in_rec_new.amount := l_agreement_row.amount + nvl(p_agreement_in_rec.amount, 0);
1374: p_agreement_amount := l_agreement_row.amount;
1375: p_agreement_in_rec_new.agreement_currency_code := l_agreement_row.agreement_currency_code;
1376:
1377: IF (p_agreement_in_rec_new.revenue_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1378: p_agreement_in_rec_new.revenue_limit_flag := l_agreement_row.revenue_limit_flag;
1379: END IF;
1380:
1381: IF (p_agreement_in_rec_new.invoice_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

1377: IF (p_agreement_in_rec_new.revenue_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1378: p_agreement_in_rec_new.revenue_limit_flag := l_agreement_row.revenue_limit_flag;
1379: END IF;
1380:
1381: IF (p_agreement_in_rec_new.invoice_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1382: p_agreement_in_rec_new.invoice_limit_flag := l_agreement_row.invoice_limit_flag;
1383: END IF;
1384:
1385: IF (p_agreement_in_rec_new.term_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

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

1381: IF (p_agreement_in_rec_new.invoice_limit_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1382: p_agreement_in_rec_new.invoice_limit_flag := l_agreement_row.invoice_limit_flag;
1383: END IF;
1384:
1385: IF (p_agreement_in_rec_new.term_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1386: p_agreement_in_rec_new.term_id := l_agreement_row.term_id;
1387: END IF;
1388:
1389: IF (p_agreement_in_rec_new.owning_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

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

1385: IF (p_agreement_in_rec_new.term_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1386: p_agreement_in_rec_new.term_id := l_agreement_row.term_id;
1387: END IF;
1388:
1389: IF (p_agreement_in_rec_new.owning_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1390: p_agreement_in_rec_new.owning_organization_id := l_agreement_row.owning_organization_id;
1391: END IF;
1392:
1393: IF (p_agreement_in_rec_new.owned_by_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

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

1389: IF (p_agreement_in_rec_new.owning_organization_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1390: p_agreement_in_rec_new.owning_organization_id := l_agreement_row.owning_organization_id;
1391: END IF;
1392:
1393: IF (p_agreement_in_rec_new.owned_by_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1394: p_agreement_in_rec_new.owned_by_person_id := l_agreement_row.owned_by_person_id;
1395: END IF;
1396: /*
1397: IF (p_agreement_in_rec_new.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

1393: IF (p_agreement_in_rec_new.owned_by_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1394: p_agreement_in_rec_new.owned_by_person_id := l_agreement_row.owned_by_person_id;
1395: END IF;
1396: /*
1397: IF (p_agreement_in_rec_new.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1398: p_agreement_in_rec_new.attribute_category := l_agreement_row.attribute_category;
1399: END IF;
1400:
1401: IF (p_agreement_in_rec_new.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

1397: IF (p_agreement_in_rec_new.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1398: p_agreement_in_rec_new.attribute_category := l_agreement_row.attribute_category;
1399: END IF;
1400:
1401: IF (p_agreement_in_rec_new.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1402: p_agreement_in_rec_new.attribute1 := l_agreement_row.attribute1;
1403: END IF;
1404:
1405: IF (p_agreement_in_rec_new.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

1401: IF (p_agreement_in_rec_new.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1402: p_agreement_in_rec_new.attribute1 := l_agreement_row.attribute1;
1403: END IF;
1404:
1405: IF (p_agreement_in_rec_new.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1406: p_agreement_in_rec_new.attribute2 := l_agreement_row.attribute2;
1407: END IF;
1408:
1409: IF (p_agreement_in_rec_new.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

1405: IF (p_agreement_in_rec_new.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1406: p_agreement_in_rec_new.attribute2 := l_agreement_row.attribute2;
1407: END IF;
1408:
1409: IF (p_agreement_in_rec_new.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1410: p_agreement_in_rec_new.attribute3 := l_agreement_row.attribute3;
1411: END IF;
1412:
1413: IF (p_agreement_in_rec_new.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

1409: IF (p_agreement_in_rec_new.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1410: p_agreement_in_rec_new.attribute3 := l_agreement_row.attribute3;
1411: END IF;
1412:
1413: IF (p_agreement_in_rec_new.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1414: p_agreement_in_rec_new.attribute4 := l_agreement_row.attribute4;
1415: END IF;
1416:
1417: IF (p_agreement_in_rec_new.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

1413: IF (p_agreement_in_rec_new.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1414: p_agreement_in_rec_new.attribute4 := l_agreement_row.attribute4;
1415: END IF;
1416:
1417: IF (p_agreement_in_rec_new.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1418: p_agreement_in_rec_new.attribute5 := l_agreement_row.attribute5;
1419: END IF;
1420:
1421: IF (p_agreement_in_rec_new.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

1417: IF (p_agreement_in_rec_new.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1418: p_agreement_in_rec_new.attribute5 := l_agreement_row.attribute5;
1419: END IF;
1420:
1421: IF (p_agreement_in_rec_new.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1422: p_agreement_in_rec_new.attribute6 := l_agreement_row.attribute6;
1423: END IF;
1424:
1425: IF (p_agreement_in_rec_new.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

1421: IF (p_agreement_in_rec_new.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1422: p_agreement_in_rec_new.attribute6 := l_agreement_row.attribute6;
1423: END IF;
1424:
1425: IF (p_agreement_in_rec_new.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1426: p_agreement_in_rec_new.attribute7 := l_agreement_row.attribute7;
1427: END IF;
1428:
1429: IF (p_agreement_in_rec_new.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

1425: IF (p_agreement_in_rec_new.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1426: p_agreement_in_rec_new.attribute7 := l_agreement_row.attribute7;
1427: END IF;
1428:
1429: IF (p_agreement_in_rec_new.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1430: p_agreement_in_rec_new.attribute8 := l_agreement_row.attribute8;
1431: END IF;
1432:
1433: IF (p_agreement_in_rec_new.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

1429: IF (p_agreement_in_rec_new.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1430: p_agreement_in_rec_new.attribute8 := l_agreement_row.attribute8;
1431: END IF;
1432:
1433: IF (p_agreement_in_rec_new.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1434: p_agreement_in_rec_new.attribute9 := l_agreement_row.attribute9;
1435: END IF;
1436:
1437: IF (p_agreement_in_rec_new.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

1433: IF (p_agreement_in_rec_new.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1434: p_agreement_in_rec_new.attribute9 := l_agreement_row.attribute9;
1435: END IF;
1436:
1437: IF (p_agreement_in_rec_new.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1438: p_agreement_in_rec_new.attribute10 := l_agreement_row.attribute10;
1439: END IF;
1440: */
1441: IF (p_agreement_in_rec_new.template_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

1437: IF (p_agreement_in_rec_new.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1438: p_agreement_in_rec_new.attribute10 := l_agreement_row.attribute10;
1439: END IF;
1440: */
1441: IF (p_agreement_in_rec_new.template_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1442: p_agreement_in_rec_new.template_flag := l_agreement_row.template_flag;
1443: END IF;
1444:
1445: EXCEPTION