APPS.PO_AUTOSOURCE_SV dependencies on FND_PROFILE

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

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

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

1601: AND NVL (pol.cancel_flag, 'N') = 'N'
1602: )
1603: --
1604: OR ( poh.type_lookup_code = 'CONTRACT'
1605: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
1606: and poh.approved_date is not null --
1607: )
1608: or nvl(poh.approved_flag,'N') = 'Y'
1609: )

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

1737: )
1738: AND (
1739: --
1740: poh.type_lookup_code = 'CONTRACT'
1741: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
1742: and poh.approved_date is not null)
1743: OR
1744: nvl(poh.approved_flag,'N') = 'Y'
1745: )

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

2711: OR x_destination_doc_type = 'REQ_NONCATALOG' --
2712: OR x_destination_doc_type = 'STANDARD PO' --ER 12625661
2713: OR x_destination_doc_type IS NULL
2714: )
2715: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
2716: and poh.approved_date is not null)
2717: OR
2718: nvl(poh.approved_flag,'N') = 'Y'
2719: )

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

2840: --
2841: )
2842: AND (
2843: ( poh.type_lookup_code = 'CONTRACT'
2844: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
2845: and poh.approved_date is not null)
2846: OR
2847: nvl(poh.approved_flag,'N') = 'Y'
2848: )

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

3895: AND NVL (pol.cancel_flag, 'N') = 'N'
3896: )
3897: --
3898: OR ( poh.type_lookup_code = 'CONTRACT'
3899: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
3900: and poh.approved_date is not null)
3901: OR
3902: nvl(poh.approved_flag,'N') = 'Y'
3903: )

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

4268: AND NVL (pol.cancel_flag, 'N') = 'N'
4269: )
4270: --
4271: OR ( poh.type_lookup_code = 'CONTRACT'
4272: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
4273: and poh.approved_date is not null)
4274: OR
4275: nvl(poh.approved_flag,'N') = 'Y'
4276: )

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

6091: >= trunc(sysdate)
6092: AND nvl(pol.cancel_flag,'N') = 'N')
6093: --
6094: OR ( poh.type_lookup_code = 'CONTRACT'
6095: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
6096: and poh.approved_date is not null)
6097: OR
6098: nvl(poh.approved_flag,'N') = 'Y'
6099: )

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

6353: -- Sourcing" will be ignored for temp labor lines and behaves as if it is
6354: -- set to Yes.
6355: -- This code section is not being deleted for possible future references.
6356: /*
6357: IF (nvl(fnd_profile.value('PO_AUTO_SOURCE_DOC'),'N') = 'N') THEN
6358:
6359: l_progress := '040';
6360: IF g_debug_stmt THEN
6361: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Open Cursor l_get_docs_on_asl_csr');