962: l_msg_data VARCHAR2(2000);
963:
964: CURSOR c1 IS
965: SELECT period_type_id
966: FROM cn_period_types
967: WHERE period_type = x_period_type
968: AND org_id = x_org_id;
969: CURSOR c2 IS
970: SELECT period_set_id
994: ORDER BY Abs(cal_period_id - x_period_id);
995:
996: BEGIN
997:
998: -- get the period_type_id from cn_period_types,
999: -- if there is no matching record, create one
1000: OPEN c1;
1001: FETCH c1 INTO x_period_type_id;
1002:
1000: OPEN c1;
1001: FETCH c1 INTO x_period_type_id;
1002:
1003: IF (c1%NOTFOUND) THEN
1004: SELECT cn_period_types_s.NEXTVAL
1005: INTO x_period_type_id
1006: FROM dual;
1007: INSERT INTO cn_period_types
1008: (period_type_id,
1003: IF (c1%NOTFOUND) THEN
1004: SELECT cn_period_types_s.NEXTVAL
1005: INTO x_period_type_id
1006: FROM dual;
1007: INSERT INTO cn_period_types
1008: (period_type_id,
1009: period_type,
1010: org_id)
1011: VALUES