APPS.PA_AGREEMENT_CORE dependencies on PA_INTERFACE_UTILS_PUB

Line 484: IF p_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

480: l_fund_rec1 c1%ROWTYPE;
481: l_fund_rec2 c2%ROWTYPE;
482:
483: BEGIN
484: IF p_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
485: OPEN c1;
486: FETCH c1 INTO l_fund_rec1;
487: IF c1%FOUND THEN
488: RETURN 'U';

Line 493: ELSIF p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

489: ELSE
490: RETURN 'A';
491: END IF;
492: CLOSE c1;
493: ELSIF p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
494: OPEN c2;
495: FETCH c2 INTO l_fund_rec2;
496: IF c2%FOUND THEN
497: RETURN 'U';

Line 545: -- OR (p_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

541: -- dbms_output.put_line('Inside: PA_AGREEMENT_CORE.GET_AGREEMENT_ID');
542: -- dbms_output.put_line('p_funding_id = '||nvl(to_char(p_funding_id),'NULL'));
543: -- dbms_output.put_line('p_funding_reference ='||nvl(p_funding_reference,'NULL'));
544: IF p_funding_reference is NOT NULL
545: -- OR (p_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
546: THEN
547: -- dbms_output.put_line('Funding Id is available: '||nvl(to_char(p_funding_id),'NULL'));
548: OPEN c2;
549: FETCH c2 INTO l_fund_rec2;

Line 559: -- OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

555: NULL; -- Fix bug#1581381
556: END IF;
557: CLOSE c2;
558: ELSIF p_funding_id is NOT NULL
559: -- OR (p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
560: THEN
561: -- dbms_output.put_line('Funding ref is available: '||nvl(p_funding_reference,'NULL'));
562: OPEN c1;
563: FETCH c1 INTO l_fund_rec1;

Line 617: -- OR p_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

613:
614: BEGIN
615: -- dbms_output.put_line('Inside: PA_AGREEMENT_CORE.GET_PROJECT_ID');
616: IF p_funding_reference IS NOT NULL
617: -- OR p_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
618: THEN
619: OPEN c2;
620: FETCH c2 INTO l_fund_rec2;
621: IF c2%FOUND THEN

Line 626: -- OR p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

622: RETURN l_fund_rec2.project_id;
623: END IF;
624: CLOSE c2;
625: ELSIF p_funding_id is NOT NULL
626: -- OR p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
627: THEN
628: OPEN c1;
629: FETCH c1 INTO l_fund_rec1;
630: IF c1%FOUND THEN

Line 676: -- OR p_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

672:
673: BEGIN
674: -- dbms_output.put_line('Inside: PA_AGREEMENT_CORE.GET_TASK_ID');
675: IF p_funding_reference IS NOT NULL
676: -- OR p_funding_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
677: THEN
678: OPEN c2;
679: FETCH c2 INTO l_fund_rec2;
680: IF c2%FOUND THEN

Line 685: -- OR p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

681: RETURN l_fund_rec2.task_id;
682: END IF;
683: CLOSE c2;
684: ELSIF p_funding_id IS NOT NULL
685: -- OR p_funding_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
686: THEN
687: OPEN c1;
688: FETCH c1 INTO l_fund_rec1;
689: IF c1%FOUND THEN

Line 740: AND (p_funding_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

736: BEGIN
737: /** Giving higher precedence to funding_id over funding_reference to determine customer_id bug 2434153 **/
738: -- dbms_output.put_line('Inside: PA_AGREEMENT_CORE.GET_CUSTOMER_ID');
739: IF p_funding_id IS NOT NULL
740: AND (p_funding_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
741: THEN
742: OPEN c1;
743: FETCH c1 INTO l_fund_rec1;
744: IF c1%FOUND THEN

Line 750: AND (p_funding_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

746: RETURN l_fund_rec1.customer_id;
747: END IF;
748: CLOSE c1;
749: ELSIF p_funding_reference IS NOT NULL
750: AND (p_funding_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
751: THEN
752: OPEN c2;
753: FETCH c2 INTO l_fund_rec2;
754: IF c2%FOUND THEN