APPS.PAY_MX_UTILITY dependencies on PAY_ELE_TMPLT_CLASS_USAGES

Line 808: ** PAY_ELE_TMPLT_CLASS_USAGES table.

804: /**********************************************************************
805: ** Type : Procedure
806: ** Name : create_ele_tmplt_class_usg
807: ** Purpose : This procedure creates records for
808: ** PAY_ELE_TMPLT_CLASS_USAGES table.
809: **
810: ** Arguments : IN Parameters
811: ** p_classification_id -> Classification ID
812: ** p_template_id -> Template ID

Line 830: FROM pay_ele_tmplt_class_usages

826: BEGIN --create_ele_tmplt_class_usg
827:
828: SELECT COUNT(*)
829: INTO ln_exists
830: FROM pay_ele_tmplt_class_usages
831: WHERE classification_id = p_classification_id
832: AND template_id = p_template_id;
833:
834: hr_utility.trace('ln_exists ' ||ln_exists);

Line 844: INSERT INTO pay_ele_tmplt_class_usages

840: FROM dual;
841:
842: hr_utility.trace('ln_ele_tmplt_class_id ' ||ln_ele_tmplt_class_id);
843:
844: INSERT INTO pay_ele_tmplt_class_usages
845: ( ele_template_classification_id
846: ,classification_id
847: ,template_id
848: ,display_process_mode

Line 866: ** PAY_ELE_TMPLT_CLASS_USAGES table.

862: ** Name : create_template_classification
863: ** Purpose : This procedure is getting called from the template
864: ** with Template ID and Classification Type and will
865: ** decides how many record to be created for
866: ** PAY_ELE_TMPLT_CLASS_USAGES table.
867: **
868: ** Arguments : IN Parameters
869: ** p_template_id -> Template ID
870: ** p_classification_type -> Display Process Mode