APPS.OKC_QP_UPGRADE_PUB dependencies on OKC_K_HEADERS_B

Line 623: FROM okc_k_headers_b chr1

619: chr1.contract_number,
620: chr1.contract_number_modifier,
621: chr1.estimated_amount ,
622: chr1.object_version_number obj
623: FROM okc_k_headers_b chr1
624: WHERE chr1.application_id IN (510,871)
625: AND NVL(chr1.buy_or_sell,'X') = 'S'
626: AND chr1.scs_code = p_category_code
627: AND chr1.id NOT IN

Line 994: UPDATE okc_k_headers_b

990:
991: -- we will update the header even if the l_hdr_list_price and l_hdr_price_list are null
992: -- we update the header with the estimated amt and user estimated amt
993:
994: UPDATE okc_k_headers_b
995: SET object_version_number = object_version_number+1,
996: last_updated_by = -1901903 ,--bug number
997: last_update_date = sysdate,
998: total_line_list_price = l_hdr_list_price,

Line 1090: p_chr_id IN okc_k_headers_b.id%TYPE ,

1086: ----------------------------------------------------------------------------*/
1087: PROCEDURE ins_contract_rec
1088: (
1089: p_category_code IN okc_subclasses_b.code%TYPE,
1090: p_chr_id IN okc_k_headers_b.id%TYPE ,
1091: p_contract_number IN okc_k_headers_b.contract_number%TYPE,
1092: p_contract_number_modifier IN okc_k_headers_b.contract_number_modifier%TYPE
1093: )
1094: IS

Line 1091: p_contract_number IN okc_k_headers_b.contract_number%TYPE,

1087: PROCEDURE ins_contract_rec
1088: (
1089: p_category_code IN okc_subclasses_b.code%TYPE,
1090: p_chr_id IN okc_k_headers_b.id%TYPE ,
1091: p_contract_number IN okc_k_headers_b.contract_number%TYPE,
1092: p_contract_number_modifier IN okc_k_headers_b.contract_number_modifier%TYPE
1093: )
1094: IS
1095: /*

Line 1092: p_contract_number_modifier IN okc_k_headers_b.contract_number_modifier%TYPE

1088: (
1089: p_category_code IN okc_subclasses_b.code%TYPE,
1090: p_chr_id IN okc_k_headers_b.id%TYPE ,
1091: p_contract_number IN okc_k_headers_b.contract_number%TYPE,
1092: p_contract_number_modifier IN okc_k_headers_b.contract_number_modifier%TYPE
1093: )
1094: IS
1095: /*
1096: This procedure will insert record into okc_qp_upgrade table with line_type=CONTRACT

Line 1903: p_chr_id IN okc_k_headers_b.id%TYPE

1899: FUNCTION compute_estimated_amt
1900: ----------------------------------------------------------------------------*/
1901: FUNCTION compute_estimated_amt
1902: (
1903: p_chr_id IN okc_k_headers_b.id%TYPE
1904: )
1905: RETURN number
1906: IS
1907: /*

Line 1965: p_chr_id IN okc_k_headers_b.id%TYPE

1961: PROCEDURE create_manual_adjustment
1962: ----------------------------------------------------------------------------*/
1963: PROCEDURE create_manual_adjustment
1964: (
1965: p_chr_id IN okc_k_headers_b.id%TYPE
1966: )
1967: IS
1968: /*
1969: This procedure will check if there is any difference between line_list_price and