APPS.OKL_TRANS_PRICING_PARAMS_PVT dependencies on OKL_ST_GEN_PRC_PARAMS

Line 42: l_id okl_st_gen_prc_params.id%TYPE;

38: l_found VARCHAR2(1) := 'N';
39: l_api_version CONSTANT NUMBER := 1;
40: l_row_notfound BOOLEAN :=TRUE;
41:
42: l_id okl_st_gen_prc_params.id%TYPE;
43: l_name okl_st_gen_prc_params.name%TYPE;
44: l_display_yn okl_st_gen_prc_params.display_yn%TYPE;
45: l_update_yn okl_st_gen_prc_params.update_yn%TYPE;
46: l_default_value okl_st_gen_prc_params.default_value%TYPE;

Line 43: l_name okl_st_gen_prc_params.name%TYPE;

39: l_api_version CONSTANT NUMBER := 1;
40: l_row_notfound BOOLEAN :=TRUE;
41:
42: l_id okl_st_gen_prc_params.id%TYPE;
43: l_name okl_st_gen_prc_params.name%TYPE;
44: l_display_yn okl_st_gen_prc_params.display_yn%TYPE;
45: l_update_yn okl_st_gen_prc_params.update_yn%TYPE;
46: l_default_value okl_st_gen_prc_params.default_value%TYPE;
47: l_prc_eng_ident okl_st_gen_prc_params.prc_eng_ident%TYPE;

Line 44: l_display_yn okl_st_gen_prc_params.display_yn%TYPE;

40: l_row_notfound BOOLEAN :=TRUE;
41:
42: l_id okl_st_gen_prc_params.id%TYPE;
43: l_name okl_st_gen_prc_params.name%TYPE;
44: l_display_yn okl_st_gen_prc_params.display_yn%TYPE;
45: l_update_yn okl_st_gen_prc_params.update_yn%TYPE;
46: l_default_value okl_st_gen_prc_params.default_value%TYPE;
47: l_prc_eng_ident okl_st_gen_prc_params.prc_eng_ident%TYPE;
48: l_description okl_st_gen_prc_params.description%TYPE;

Line 45: l_update_yn okl_st_gen_prc_params.update_yn%TYPE;

41:
42: l_id okl_st_gen_prc_params.id%TYPE;
43: l_name okl_st_gen_prc_params.name%TYPE;
44: l_display_yn okl_st_gen_prc_params.display_yn%TYPE;
45: l_update_yn okl_st_gen_prc_params.update_yn%TYPE;
46: l_default_value okl_st_gen_prc_params.default_value%TYPE;
47: l_prc_eng_ident okl_st_gen_prc_params.prc_eng_ident%TYPE;
48: l_description okl_st_gen_prc_params.description%TYPE;
49:

Line 46: l_default_value okl_st_gen_prc_params.default_value%TYPE;

42: l_id okl_st_gen_prc_params.id%TYPE;
43: l_name okl_st_gen_prc_params.name%TYPE;
44: l_display_yn okl_st_gen_prc_params.display_yn%TYPE;
45: l_update_yn okl_st_gen_prc_params.update_yn%TYPE;
46: l_default_value okl_st_gen_prc_params.default_value%TYPE;
47: l_prc_eng_ident okl_st_gen_prc_params.prc_eng_ident%TYPE;
48: l_description okl_st_gen_prc_params.description%TYPE;
49:
50: CURSOR st_gen_prc_params(p_gts_id NUMBER) IS

Line 47: l_prc_eng_ident okl_st_gen_prc_params.prc_eng_ident%TYPE;

43: l_name okl_st_gen_prc_params.name%TYPE;
44: l_display_yn okl_st_gen_prc_params.display_yn%TYPE;
45: l_update_yn okl_st_gen_prc_params.update_yn%TYPE;
46: l_default_value okl_st_gen_prc_params.default_value%TYPE;
47: l_prc_eng_ident okl_st_gen_prc_params.prc_eng_ident%TYPE;
48: l_description okl_st_gen_prc_params.description%TYPE;
49:
50: CURSOR st_gen_prc_params(p_gts_id NUMBER) IS
51: SELECT pp.id, pp.name, pp.display_yn,pp.update_yn,

Line 48: l_description okl_st_gen_prc_params.description%TYPE;

44: l_display_yn okl_st_gen_prc_params.display_yn%TYPE;
45: l_update_yn okl_st_gen_prc_params.update_yn%TYPE;
46: l_default_value okl_st_gen_prc_params.default_value%TYPE;
47: l_prc_eng_ident okl_st_gen_prc_params.prc_eng_ident%TYPE;
48: l_description okl_st_gen_prc_params.description%TYPE;
49:
50: CURSOR st_gen_prc_params(p_gts_id NUMBER) IS
51: SELECT pp.id, pp.name, pp.display_yn,pp.update_yn,
52: pp.default_value, pp.prc_eng_ident, pp.description

Line 55: okl_st_gen_prc_params pp

51: SELECT pp.id, pp.name, pp.display_yn,pp.update_yn,
52: pp.default_value, pp.prc_eng_ident, pp.description
53: FROM okl_st_gen_tmpt_sets temp_set,
54: okl_st_gen_templates template,
55: okl_st_gen_prc_params pp
56: WHERE temp_set.id = template.gts_id
57: AND template.id = pp.gtt_id
58: AND temp_set.id = p_gts_id;
59: