APPS.PO_AUTOSOURCE_SV dependencies on FND_PROFILE

Line 1236: fnd_profile.get('PO_AUTO_SOURCE_DOC', x_auto_source_doc);

1232:
1233: l_progress := '050';
1234: --Do the check for the profile option 'PO: Automatic Document Sourcing'.
1235: --If set to 'Y' then get the latest document. If set to 'N' then get it from ASL.
1236: fnd_profile.get('PO_AUTO_SOURCE_DOC', x_auto_source_doc);
1237: IF nvl(x_auto_source_doc, 'N') = 'N' THEN
1238: l_progress := '060';
1239: IF g_debug_stmt THEN
1240: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Looking at ASLs for Sourcing');

Line 1596: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --

1592: AND NVL (pol.cancel_flag, 'N') = 'N'
1593: )
1594: --
1595: OR ( poh.type_lookup_code = 'CONTRACT'
1596: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
1597: and poh.approved_date is not null --
1598: )
1599: or nvl(poh.approved_flag,'N') = 'Y'
1600: )

Line 1728: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --

1724: )
1725: AND (
1726: --
1727: poh.type_lookup_code = 'CONTRACT'
1728: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
1729: and poh.approved_date is not null)
1730: OR
1731: nvl(poh.approved_flag,'N') = 'Y'
1732: )

Line 2694: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --

2690: WHERE ( x_destination_doc_type = 'REQ'
2691: OR x_destination_doc_type = 'REQ_NONCATALOG' --
2692: OR x_destination_doc_type IS NULL
2693: )
2694: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
2695: and poh.approved_date is not null)
2696: OR
2697: nvl(poh.approved_flag,'N') = 'Y'
2698: )

Line 2821: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --

2817: --
2818: )
2819: AND (
2820: ( poh.type_lookup_code = 'CONTRACT'
2821: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
2822: and poh.approved_date is not null)
2823: OR
2824: nvl(poh.approved_flag,'N') = 'Y'
2825: )

Line 3871: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --

3867: AND NVL (pol.cancel_flag, 'N') = 'N'
3868: )
3869: --
3870: OR ( poh.type_lookup_code = 'CONTRACT'
3871: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
3872: and poh.approved_date is not null)
3873: OR
3874: nvl(poh.approved_flag,'N') = 'Y'
3875: )

Line 4244: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --

4240: AND NVL (pol.cancel_flag, 'N') = 'N'
4241: )
4242: --
4243: OR ( poh.type_lookup_code = 'CONTRACT'
4244: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
4245: and poh.approved_date is not null)
4246: OR
4247: nvl(poh.approved_flag,'N') = 'Y'
4248: )

Line 6018: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --

6014: >= trunc(sysdate)
6015: AND nvl(pol.cancel_flag,'N') = 'N')
6016: --
6017: OR ( poh.type_lookup_code = 'CONTRACT'
6018: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
6019: and poh.approved_date is not null)
6020: OR
6021: nvl(poh.approved_flag,'N') = 'Y'
6022: )

Line 6280: IF (nvl(fnd_profile.value('PO_AUTO_SOURCE_DOC'),'N') = 'N') THEN

6276: -- Sourcing" will be ignored for temp labor lines and behaves as if it is
6277: -- set to Yes.
6278: -- This code section is not being deleted for possible future references.
6279: /*
6280: IF (nvl(fnd_profile.value('PO_AUTO_SOURCE_DOC'),'N') = 'N') THEN
6281:
6282: l_progress := '040';
6283: IF g_debug_stmt THEN
6284: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Open Cursor l_get_docs_on_asl_csr');