DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PON_CONTERMS_UTL_PVT

Line 1150: l_doc_type := PON_CONTERMS_UTL_PVT.get_negotiation_doc_type(l_doc_type_id);

1146: --have privilege to view contract terms
1147: if (p_printing_warning_flag = 'Y' OR nvl(l_contracts_installed, 'N') = 'N') then
1148: l_cont_attach_doc_flag := 'N';
1149: else
1150: l_doc_type := PON_CONTERMS_UTL_PVT.get_negotiation_doc_type(l_doc_type_id);
1151: if (PON_CONTERMS_UTL_PVT.isDocumentMergeable(l_doc_type, to_number(p_auction_header_id)) = 'N') then
1152: l_cont_nonmerge_flag := 'Y';
1153: else
1154: l_cont_nonmerge_flag := 'N';

Line 1151: if (PON_CONTERMS_UTL_PVT.isDocumentMergeable(l_doc_type, to_number(p_auction_header_id)) = 'N') then

1147: if (p_printing_warning_flag = 'Y' OR nvl(l_contracts_installed, 'N') = 'N') then
1148: l_cont_attach_doc_flag := 'N';
1149: else
1150: l_doc_type := PON_CONTERMS_UTL_PVT.get_negotiation_doc_type(l_doc_type_id);
1151: if (PON_CONTERMS_UTL_PVT.isDocumentMergeable(l_doc_type, to_number(p_auction_header_id)) = 'N') then
1152: l_cont_nonmerge_flag := 'Y';
1153: else
1154: l_cont_nonmerge_flag := 'N';
1155: end if;

Line 1157: if (PON_CONTERMS_UTL_PVT.isAttachedDocument (l_doc_type, to_number(p_auction_header_id)) = 'Y') then

1153: else
1154: l_cont_nonmerge_flag := 'N';
1155: end if;
1156:
1157: if (PON_CONTERMS_UTL_PVT.isAttachedDocument (l_doc_type, to_number(p_auction_header_id)) = 'Y') then
1158: l_cont_attach_doc_flag := 'Y';
1159: else
1160: l_cont_attach_doc_flag := 'N';
1161: end if;

Line 3211: and pon_conterms_utl_pvt.get_legal_entity_id(pah.org_id) = entity.organization_id(+)

3207: = nvl(hr_general.get_business_group_id, nvl(loc_ship.business_group_id(+), -99))
3208: and pah.org_id = ou.organization_id(+)
3209: and nvl(ou.date_from(+),sysdate-1) < sysdate
3210: and nvl(ou.date_to(+),sysdate+1) > sysdate
3211: and pon_conterms_utl_pvt.get_legal_entity_id(pah.org_id) = entity.organization_id(+)
3212: and entity.organization_id = entitytl.organization_id(+)
3213: and entitytl.language(+) = l_printing_language
3214: and entity.location_id = entity_loc.location_id(+)
3215: and nvl(entity_loc.inactive_date(+), sysdate+1) > sysdate