APPS.OKC_QP_UPGRADE_PUB dependencies on OKC_SUBCLASSES_B

Line 11: g_category_code okc_subclasses_b.code%TYPE;

7: --
8: g_package varchar2(33) := ' OKC_QP_UPGRADE_PUB.'; -- Global package name
9: --
10: g_error_exception exception;
11: g_category_code okc_subclasses_b.code%TYPE;
12: g_dflt_price_list_id number;
13: g_k_price_list_id number;
14:
15: FUNCTION get_seq_id RETURN NUMBER;

Line 27: p_category_code IN okc_subclasses_b.code%TYPE ,

23: (
24: errbuf OUT NOCOPY VARCHAR2,
25: retcode OUT NOCOPY VARCHAR2,
26: p_dflt_price_list_id IN NUMBER,
27: p_category_code IN okc_subclasses_b.code%TYPE ,
28: p_enable_qp_profile IN VARCHAR2 ,
29: p_rpt_upgrade_status IN VARCHAR2
30: )
31: IS

Line 352: p_category_code IN okc_subclasses_b.code%TYPE

348: PROCEDURE ins_category_rec
349: ----------------------------------------------------------------------------*/
350: PROCEDURE ins_category_rec
351: (
352: p_category_code IN okc_subclasses_b.code%TYPE
353: )
354: IS
355: /*
356: This procedure will insert record into okc_qp_upgrade with line_type=CATEGORY

Line 602: p_category_code IN okc_subclasses_b.code%TYPE

598: PROCEDURE start_category_upgrade
599: ----------------------------------------------------------------------------*/
600: PROCEDURE start_category_upgrade
601: (
602: p_category_code IN okc_subclasses_b.code%TYPE
603: )
604: IS
605: /*
606: This procedure will call the upgrade script .

Line 1089: p_category_code IN okc_subclasses_b.code%TYPE,

1085: PROCEDURE ins_contract_rec
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: )

Line 1186: p_category_code IN okc_subclasses_b.code%TYPE

1182: PROCEDURE call_qp_upgrade
1183: ----------------------------------------------------------------------------*/
1184: PROCEDURE call_qp_upgrade
1185: (
1186: p_category_code IN okc_subclasses_b.code%TYPE
1187: )
1188: IS
1189: /*
1190: This procedure will do the following

Line 1210: FROM okc_subclasses_b scs,

1206:
1207: -- category cursor for all/ specific categories in OKC and OKO
1208: CURSOR csr_category IS
1209: SELECT scs.code
1210: FROM okc_subclasses_b scs,
1211: okc_classes_b cs
1212: WHERE scs.cls_code = cs.code
1213: AND cs.application_id IN (510,871)
1214: AND scs.code = NVL(p_category_code,scs.code) ;

Line 1217: l_code okc_subclasses_b.code%TYPE;

1213: AND cs.application_id IN (510,871)
1214: AND scs.code = NVL(p_category_code,scs.code) ;
1215:
1216:
1217: l_code okc_subclasses_b.code%TYPE;
1218: l_qp_upgrade_rec okc_qp_upgrade%ROWTYPE;
1219:
1220:
1221: BEGIN

Line 1308: p_category_code IN okc_subclasses_b.code%TYPE,

1304: PROCEDURE upd_category_rec
1305: ----------------------------------------------------------------------------*/
1306: PROCEDURE upd_category_rec
1307: (
1308: p_category_code IN okc_subclasses_b.code%TYPE,
1309: p_status IN varchar2
1310: )
1311: IS
1312: /*

Line 1411: FROM okc_subclasses_b scs, okc_classes_b cs

1407: l_categories_done number(9);
1408:
1409: CURSOR csr_total_categories IS
1410: SELECT COUNT(scs.code)
1411: FROM okc_subclasses_b scs, okc_classes_b cs
1412: WHERE scs.cls_code = cs.code
1413: AND cs.application_id IN ( 510, 871 );
1414:
1415: CURSOR csr_categories_done IS