DBA Data[Home] [Help]

APPS.IGS_PE_STAT_PKG dependencies on FND_API

Line 653: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);

649:
650: -- initialize the party record
651:
652: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
653: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
654: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
655: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);

Line 654: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);

650: -- initialize the party record
651:
652: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
653: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
654: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
655: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
658: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);

Line 655: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);

651:
652: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
653: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
654: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
655: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
658: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
659: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;

Line 656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);

652: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
653: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
654: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
655: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
658: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
659: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
660: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);

Line 657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);

653: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
654: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
655: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
658: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
659: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
660: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
661:

Line 658: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);

654: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
655: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
658: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
659: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
660: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
661:
662: -- do not initialise the attribute 1.20 and do not pass global attributes 1.20

Line 660: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);

656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
658: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
659: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
660: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
661:
662: -- do not initialise the attribute 1.20 and do not pass global attributes 1.20
663:
664: IF X_ACTION ='INSERT' THEN

Line 691: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

687: fnd_message.set_name ('AR',Y_MSG_DATA);
688: --Code added by sbaliga as part of #2338473
689: IF z_msg_count > 1 THEN
690: FOR i IN 1..z_msg_count LOOP
691: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
692: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
693: END LOOP;
694: z_msg_data := l_tmp_var1;
695: END IF;

Line 988: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);

984: CLOSE PARTY_CUR;
985:
986:
987: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
988: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
989: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
990: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);

Line 989: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);

985:
986:
987: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
988: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
989: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
990: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
993: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);

Line 990: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);

986:
987: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
988: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
989: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
990: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
993: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
994: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;

Line 991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);

987: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
988: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
989: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
990: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
993: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
994: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
995: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);

Line 992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);

988: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
989: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
990: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
993: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
994: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
995: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
996:

Line 993: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);

989: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
990: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
993: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
994: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
995: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
996:
997:

Line 995: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);

991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
993: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
994: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
995: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
996:
997:
998: IF X_ACTION ='UPDATE' THEN
999:

Line 1024: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1020: -- fnd_message.set_name ('AR', Y_MSG_DATA);
1021: --Code added by sbaliga as part of #2338473
1022: IF z_msg_count > 1 THEN
1023: FOR i IN 1..z_msg_count LOOP
1024: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1025: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
1026: END LOOP;
1027: z_msg_data := l_tmp_var1;
1028: END IF;